Oracle 10g Express主页未显示 [英] Oracle 10g express home page is not coming up

问题描述

我安装了Oracle 10g Express.安装进行得很好，但是主页没有显示出来. 我可以使用sqlplus进行连接，但不能与Sql Developer进行连接. 我检查了tnsnames.ora和listener.ora一切看起来都很好. 侦听器也已启动.我可以随时重新安装并查看.但是我认为最好查询原因.

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.

关于主页.这是浏览器中出现的地址.本地主机:8080 http://127.0.0.1:8080/apex 我做了一个netstat来查看8080是否存在任何端口冲突，但是该端口未使用.

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

有人遇到过这个问题吗?

Have anybody faced this issue?

推荐答案

是.实际上，它是XE Oracle论坛上的FAQ. 首先，您可以使用

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

sqlplus user/pass

如果是这样，Oracle正在运行(这似乎是您的情况，但可能不适合将来遇到类似问题的读者).如果没有，您可以尝试

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

sqlplus / as sysdba
startup

一旦Oracle启动，请检查侦听器是否可以通过以下方式查看Oracle实例: sqlplus用户/pass @ xe 如果不是，则侦听器未启动，或者侦听器不知道该服务".确保侦听器已启动(lsnrctl，然后启动).确保数据库已在侦听器中注册

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

sqlplus / as sysdba
alter system register;

现在，您应该可以使用'@xe'语法进行连接.值得验证的是，将嵌入式PL/SQL网关设置为使用8080端口

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

select dbms_xdb.GETHTTPPORT from dual;

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

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

然后，我建议您查看浏览器设置(特别是可能将您的请求转发到不知道如何处理它的计算机的任何代理设置)和防火墙(可以将其设置为忽略或隐藏任何访问权限)到端口).

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).

这篇关于Oracle 10g Express主页未显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！