Oracle XE 11g 主页不显示
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14398879/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle XE 11g homepage not displaying
提问by Surender Thakran
I have been searching for a solution to my problem for a while now but none seems to be working, this is my last attempt before I go for re-installation.
我一直在寻找解决我的问题的方法有一段时间了，但似乎没有任何效果，这是我重新安装之前的最后一次尝试。
I today installed Oracle XE 11g Release 2 through its installation wizard and it went fine. The trouble I seem to be having is that I can't open the browser homepage.
我今天通过其安装向导安装了 Oracle XE 11g 第 2 版，并且一切顺利。我似乎遇到的麻烦是我无法打开浏览器主页。
The browsers are giving me the error: cannot establish a connection to the server at 127.0.0.1:8080
浏览器给了我错误： cannot establish a connection to the server at 127.0.0.1:8080
I am on Windows 7 32-bit and i have downloaded & installed the XE for the same.
我使用的是 32 位 Windows 7，并且我已经下载并安装了相同的 XE。
From reading all the possible answers I gathered that some info might be needed before my question is answered. So are the results from various commands that I have run which all the answers asked for.
通过阅读所有可能的答案，我收集到在回答我的问题之前可能需要一些信息。我运行的各种命令的结果也是如此，所有的答案都是如此。
1)
1)
C:\Users\lenove> netstat -nao | find "8080"
No result for this one
这个没有结果
2)
2)
C:\Users\lenovo> lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 18-JAN-2013 16:46:43
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 18-JAN-2013 16:18:54
Uptime 0 days 0 hr. 27 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oracle\oraclexe\app\oracle\product.2.0\server\network\admin\listener.ora
Listener Log File C:\oracle\oraclexe\app\oracle\diag\tnslsnr\Voldemort\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Voldemort)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
3)
3)
SQL> SELECT dbms_xdb.gethttpport FROM dual;
SP2-0640 : Not Connected
4) Contents of oraclexe/app/oracle/product/11.20/server/network/ADMIN/listener.ora (oraclexe is the default installation directory suggested by the Installation Wizard)
4）oraclexe/app/oracle/product/11.20/server/network/ADMIN/listener.ora的内容（oraclexe是安装向导建议的默认安装目录）
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\oraclexe\app\oracle\product.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\oraclexe\app\oracle\product.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Voldemort)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
I tried using both chrome and firefox (latest versions of both) but still couldn't get it.
我尝试同时使用 chrome 和 firefox（两者的最新版本），但仍然无法获得。
Note:This is my first attempt at oracle so I was a bit wary of trying every solution suggested by the threads, hence my own thread.
注意：这是我第一次尝试 oracle，所以我对尝试线程建议的每个解决方案都有些谨慎，因此是我自己的线程。
Thanx in advance!
提前谢谢！
回答by berhauz
I installed on a Windows 7 pro (under local administrator account) and it ran smooth. I installed the exact same bundle on a Windows 7 Home Premium (the UAC prompts for elevation to local ADMIN) and I had the issue: no XE home page.
我安装在 Windows 7 专业版上（在本地管理员帐户下）并且运行流畅。我在 Windows 7 Home Premium 上安装了完全相同的包（UAC 提示提升到本地管理员），但我遇到了问题：没有 XE 主页。
You shall check first that windows services (via control panel > Admin tools > services) OracleServiceXE and OracleXETNSListener are indeed started.
您应首先检查 Windows 服务（通过控制面板 > 管理工具 > 服务）OracleServiceXE 和 OracleXETNSListener 确实已启动。
You can then check (as illustrated in top post) the TNS listner status with (adjust \Oracle\XE to your installation path)
然后，您可以使用（将 \Oracle\XE 调整到您的安装路径）来检查（如顶部帖子所示）TNS 侦听器状态
C:\Oracle\XE\app\oracle\product.2.0\server\bin\lsnrctl status
which yields the Listening Endpoints, and if you do not see threelines like (the third one likely missing !):
这产生听力端点，如果你没有看到3线，如（第三个可能丢失！）：
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BHPPC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BHPPC)(PORT=8080))(Presentation=HTTP)(Session=RAW))
then that's exactly where the problem is. The trick is to take note of the host name on which the TNS service listens (e.g. BHPPC in the above example). Then do add en entry into your C:\Windows\System32\drivers\etc\hostslike (on a line of its own, no space before 127.0.0.1, followed by spaces or tab, followed by your hostname):
那么这正是问题所在。诀窍是记下 TNS 服务侦听的主机名（例如上例中的 BHPPC）。然后将 en 条目添加到您的C:\Windows\System32\drivers\etc\hosts喜欢中（单独一行，127.0.0.1 之前没有空格，后跟空格或制表符，后跟您的主机名）：
127.0.0.1 BHPPC
and restart both windows services listed above. Check again the Listening Endpointswith the lsnrctl statuscommand; if the magical third line is now listed, the XE home page will work. There's indeed a bug in hostname resolution and you shall provide the TNS service with an explicit IP address mapping which, surprisingly, it doesn't need to listen OK to port 1521.
并重新启动上面列出的两个 Windows 服务。使用命令再次检查侦听端点lsnrctl status；如果现在列出神奇的第三行，则 XE 主页将起作用。主机名解析确实存在错误，您应该为 TNS 服务提供显式 IP 地址映射，令人惊讶的是，它不需要监听 1521 端口。
回答by user2462210
I recommand you to proceed to the installation from a localadministrative user.
我建议您从本地管理用户继续安装。
On my computer : windows 7 professional, 64 bits
在我的电脑上：Windows 7 Professional，64 位
connected with user from a domain, in Administrative group : installation fail, without any message. In the log files located in /oraclexe/app/oracle/product/11.2.0/server/config/log, I found a lot of "not connected" messages (sorry, I did not keep the log files)
connected with local administrative user : installation works and menu getStarted works : browser display the Oracle Database XE 11.2 administration home page.
与来自域的用户连接，在管理组中：安装失败，没有任何消息。在位于/oraclex/app/oracle/product/11.2.0/server/config/log的日志文件中，我发现了很多“未连接”消息（抱歉，我没有保留日志文件）
与本地管理用户连接：安装工作和菜单 getStarted 工作：浏览器显示 Oracle Database XE 11.2 管理主页。
