SQL Oracle 10g express 主页出不来

Oracle 10g express home page is not coming up

提问by lostinbytes

I installed Oracle 10g express. Installation went well, But the home page is not coming up. I can connect using sqlplus but not with Sql Developer. I checked tnsnames.ora and listener.ora everything looks fine. Listener is also started. I can always reinstall and see. But I thought better inquire the cause.

我安装了 Oracle 10g express。安装顺利，但是主页不出来。我可以使用 sqlplus 连接，但不能使用 Sql Developer。我检查了 tnsnames.ora 和 listener.ora 一切正常。监听器也启动了。我总是可以重新安装并查看。但我想最好问问原因。

Regarding the home page. This is the address that comes up in browser. Localhost:8080 http://127.0.0.1:8080/apexI did a netstat to see whether there is any port conflict for 8080, but that port is not in use.

关于主页。这是浏览器中出现的地址。Localhost:8080 http://127.0.0.1:8080/apex我做了一个netstat，看看8080 是否有任何端口冲突，但那个端口没有被使用。

Have anybody faced this issue?

有人遇到过这个问题吗？

回答by Gary Myers

Yes. It is practically a FAQ on the XE Oracle forum. Firstly, can you connect to Oracle using

是的。它实际上是 XE Oracle 论坛上的常见问题解答。首先，您可以使用连接到 Oracle 吗

sqlplus user/pass

If so, Oracle is up an running (which appears to be your situation, but may not be for a future reader with a similar problem). If not, you can try

如果是这样，Oracle 正在运行（这似乎是您的情况，但可能不适用于未来遇到类似问题的读者）。如果没有，你可以试试

sqlplus / as sysdba
startup

Once Oracle is up, check that the listener can see the Oracle instance by sqlplus user/pass@xe If not, then either the listener is not up, or the 'listener does not know of the service'. Make sure the listener is started (lsnrctl, then start). Make sure the database is registered with the listener

Oracle 启动后，通过 sqlplus user/pass@xe 检查侦听器是否可以看到 Oracle 实例。如果没有，则要么是侦听器未启动，要么是“侦听器不知道该服务”。确保侦听器已启动（lsnrctl，然后启动）。确保数据库已注册到侦听器

sqlplus / as sysdba
alter system register;

Now you should be able to connect using the '@xe' syntax. Worthwhile verifying the embedded PL/SQL gateway is set up to use the 8080 port

现在您应该能够使用“@xe”语法进行连接。值得验证嵌入式PL/SQL网关是否设置为使用8080端口

select dbms_xdb.GETHTTPPORT from dual;

On Windows you can use netstat -ab to see if tnslsnr.exe is listening on the port.

在 Windows 上，您可以使用 netstat -ab 来查看 tnslsnr.exe 是否正在侦听端口。

Then I'd suggest looking at browser settings (specifically any proxy settings that might be forwarding your request to a machine that has no idea what to do with it) and firewalls (which could well be set to ignore or hide any access to the port).

然后我建议查看浏览器设置（特别是可能将您的请求转发到不知道如何处理它的机器的任何代理设置）和防火墙（很可能设置为忽略或隐藏对端口的任何访问）。

回答by vishal

I had the same problem. I tried this and it sorted out my problem... 1. goto start->run
2.type services.msc and hit enter
3.In the applet that opened, scroll down(in right pane) to figure out the option of "OracleServiceXE" and right click on it. 4. In general tab do->>> startup type "Automatic" and click the "start button". 5. Repeat step 4. for the option "OracleXETNSListener". close the window.

我有同样的问题。我试过了，它解决了我的问题...... 1. 转到开始-> 运行
2.type services.msc 并按 Enter
3.在打开的小程序中，向下滚动（在右侧窗格中）以找出“ OracleServiceXE”并右键单击它。4. 在常规选项卡 do->>> 启动类型“自动”，然后单击“启动按钮”。5. 对选项“OracleXETNSListener”重复步骤 4.。关上窗户。

now, i hope, the problem should be solved....

现在，我希望，问题应该得到解决......

回答by anurag

Check your windows firewall,If it is on it blocks the opening of the homepage.Either you shut down the windows firewall or allow these following ports : 1521: Oracle database listener

检查您的 windows 防火墙，如果它阻止了主页的打开。要么关闭 windows 防火墙，要么允许以下端口：1521：Oracle 数据库侦听器

2030: Oracle Services for Microsoft Transaction Server

2030 年：面向 Microsoft 事务服务器的 Oracle 服务

8080: HTTP port for Oracle XML DB and the Oracle Database XE graphical user interface

8080：用于 Oracle XML DB 和 Oracle Database XE 图形用户界面的 HTTP 端口

See software requirements in the below URL:

请参阅以下 URL 中的软件要求：

http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#BABEBCDB

http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#BABEBCDB

It worked for me!

它对我有用！

回答by OscarRyz

Try this ( I'm assuming Windows system )

试试这个（我假设是 Windows 系统）

using

使用

netstat 

without anyother parameter would tell you if port 8080 is already open.

没有任何其他参数会告诉您端口 8080 是否已经打开。

Also you can try this:

你也可以试试这个：

telnet localhost 8080

If the server answers ( the screen goes blank [or black] ) then the server is up and running.

如果服务器应答（屏幕变为空白 [或黑色]），则服务器已启动并正在运行。

Try using your hostname instead of localhost.

尝试使用您的主机名而不是 localhost。

See if you're using a proxy and not skipping the local addresses.

查看您是否使用代理而不是跳过本地地址。

Also you can see what's the executable that starts the home page and see if it could start successfully.

您还可以看到启动主页的可执行文件是什么，看看它是否可以成功启动。

回答by lostinbytes

Thanks for the response guys. I finally figured out how to solve the issue, but not really the root cause.

谢谢各位的回复。我终于想出了如何解决这个问题，但不是真正的根本原因。

Problem 1 - Can not login to oracle admin console. It was the problem with not adding 127.0.0.1 in the IE intranet sites. Go to tools>internet options>security>local intranet sites>advanced> add http://127.0.0.1:8080/apexin the list.

问题 1 - 无法登录到 oracle 管理控制台。没有在 IE 内网站点中添加 127.0.0.1 的问题。转到工具> Internet 选项> 安全> 本地 Intranet 站点> 高级>在列表中添加http://127.0.0.1:8080/apex。

It works fine after this. But if I go back to the same place again and see the sites, I cant find the url I added sometimes back... Dont know why that is happening. May be some company security is messing up. Anyways the admin console is now coming up.

在此之后它工作正常。但是，如果我再次回到同一个地方并查看网站，我将无法找到我有时添加的网址...不知道为什么会发生这种情况。可能是某些公司的安全出了问题。无论如何，管理控制台现在正在出现。

Problem 2 - Cannot connect using SQL Developer. After I did the fix for problem 1, this is also magically working. I still don't know how security settings in IE affects SQL Developer? Any comments on this?

问题 2 - 无法使用 SQL Developer 进行连接。在我修复了问题 1 之后，这也神奇地起作用了。还是不知道IE中的安全设置对SQL Developer有什么影响？对此有何评论？

回答by M.E.

For Windows 8 simply click on Get Started With OracleXE.... When internet explorer opens up, select the View on the desktopoption in the Page Viewicon (icon with a wrench).

对于 Windows 8，只需单击Get Started With OracleXE.... 当 Internet Explorer 打开时，选择图标中的View on the desktop选项Page View（带扳手的图标）。

You should now be able to view your page.

您现在应该可以查看您的页面了。

回答by Rorschach

I had a similar problem, I was able to connect to SQLPLUS using terminal but on access in browser as it was showing error as you have described. So, I went back to terminal and mounted my database using

我遇到了类似的问题，我能够使用终端连接到 SQLPLUS，但是在浏览器中访问时，因为它显示了您所描述的错误。所以，我回到终端并使用

startup

启动

and it resolved my problem. This might be the case.

它解决了我的问题。情况可能是这样。

回答by VArUN the Virus

hey guys one important fact if u r using IE7 (explorer7) then u wd face certain problem in using 10g, such as not displaying home page.

嘿伙计们，一个重要的事实是，如果您使用 IE7 (explorer7)，那么您在使用 10g 时会遇到某些问题，例如不显示主页。