Oracle 10g Express 主页无法显示
我的Oracle 10g Express Edition，我可以登录SQL plus，但无法通过SQL Developer登录oracle，也无法查看链接http://127.0.0.1:8080/apex。直到昨天为止，这一切都运行良好。
我已经通过 (WINDOWS)netstat -ab 检查过，没有其他应用程序正在使用 8080 端口。
我今天做的唯一一件事就是将 SQL Server 2005 Developer 版本从 Windows 身份验证更改为混合模式身份验证。
谁能告诉我如何让 Oracle 网页和 SQL Developer 工作。
我将不胜感激。
谢谢！
阿德南·A.
My Oracle 10g Express Edition , I can login in the SQL plus but I cannot login into oracle via SQL developer and cannot view the Home page at link http://127.0.0.1:8080/apex. This was working fine until yesterday.
I have checked via (WINDOWS)netstat -ab and no other app is using the 8080 port.
The only thing I did today was I changed my SQL server 2005 Developer edition from Windows authentication to Mixed Mode authentication.
Can anyone let me know how to get the Oracle Web page and the SQL Developer to work.
I will gratly appreciate that.
Thanks!
Adnan A.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
好的！我弄清楚了
一直以来，我以为我的侦听器正在运行，但是当我使用命令
“lsnrctl status”
时，我注意到 lisnter 没有运行并且失败，因为我的主机名是正确的。
我记得当我激活 SQL Server 2005 的混合模式配置时，我必须给我的 SQL 服务器一个主机名，该主机名与通用 WIndows XP 主机名不同。
因此，我通过在 Windows 上搜索 TNSNAMES.ORA 和 LISTENER.ORA 文件来编辑它们，然后修复主机名。
重新启动 Oracle XE 服务，现在 WEB 页面可以工作，SQL DeVELOPER 也可以工作。
所以我想我应该与你分享补救措施。
感谢大家的帮助和努力。你们都很棒。
OK! I figured it out
All this time, I thought My listener was running but when i used the command
'lsnrctl status'
I noticed that lisnter was not running and was failing becasue my host name was correct.
I remember when I activated the Mixed Mode config for SQL Server 2005 , i had to give my SQL server a host name and which was different than generic WIndows XP hostname.
So i edited my TNSNAMES.ORA and LISTENER.ORA file by doind a search on windows for them and then fixed the hostnames.
Restarteds the Oracle XE services and now the WEB Page works and so does the SQL DeVELOPER.
SO I thought I should share with you the remedy.
Thanks for everyones help and efforts. YOu were all great.
重新启动 Oracle 服务吗？如果仍然不起作用，请检查事件查看器中是否有任何有意义的 Oracle 事件。
并检查您是否没有打开软件防火墙（Windows防火墙或您的AV程序可能有防火墙）
Restart your Oracle services? If it still doesn't work then check the event viewer for any meaningful Oracle events.
And check that you didn't switch on a software firewall (Windows firewall or your AV program may have a firewall)
这并不是说这是最近出现的问题，但我确实惊恐地发现，与 XE 一起使用时，工作站名称过长会导致主页无法加载。我将名称从（不要笑！）GenericXPWorkstation 更改为 VMORACLE，并确保 Listener.ora 和 tnsnames.ora 显示主机的这些值，并添加条目
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
到 SQLNET.ORA，我现在看到了愚蠢的 XE 管理主页。
我没有修改 Windows HOSTS 文件。
Not that this is a recent issue, but I did find to my horror that an overly long workstation name when used with XE will cause the home page to not load. I changed the name from (do not laugh!) GenericXPWorkstation to VMORACLE and made sure Listener.ora and tnsnames.ora showed those values for host, as well as adding the entry
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
to SQLNET.ORA and I now see the stupid XE admin homepage.
I did NOT screw with the Windows HOSTS file.