Oracle 10g express 和 11g express DB 主页未显示

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/7901928/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 00:24:14  来源:igfitidea点击:

Oracle 10g express and 11g express DB homepage is not showing up

oracleoracle10goracle11g

提问by Simon Levesque

I just installed Oracle for the first time and the last step of the installer is to ask if I want to check the home page. I checked it, the browser opened a local website, but this website does not exists. So I am simply stuck here.

我是第一次安装Oracle,安装程序的最后一步是问我要不要查看主页。我查了一下,浏览器打开了一个本地网站,但是这个网站不存在。所以我只是被困在这里。

I tried 10g first, I uninstalled it and tried 11g. I always get a non-running webpage. I tried it because I saw in some answers that 10g was not supported by Windows 7 32 bits and that 11g was.

我先试了10g,卸载了再试11g。我总是得到一个非运行的网页。我尝试了它,因为我在一些答案中看到 Windows 7 32 位不支持 10g 而 11g 是。

Each time, I checked if all the Oracle services were up and they are. I also checked if the port 8080 was used and it is not. Also, disabling the Windows firewall gives nothing.

每次,我都会检查是否所有 Oracle 服务都已启动,并且它们都已启动。我还检查了是否使用了端口 8080 而不是。此外,禁用 Windows 防火墙没有任何意义。

I know nothing about Oracle so please give me some links if you are talking about Oracle specific things.

我对 Oracle 一无所知,所以如果您在谈论 Oracle 特定的事情,请给我一些链接。

If you don't know the problem with the website, could you tell me which service is supposed to start the website and were is its logfile so that I could see the error?

如果你不知道网站的问题,你能告诉我哪个服务应该启动网站,它的日志文件是什么,以便我可以看到错误?

Thanks

谢谢



In a side note, in the project install guide, I am supposed to run "sqlplus system@xe" after Oracle is installed. When I do it, I have to enter the password and then I get "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor". Each questions about that error was about "it worked fine for a week and now no more"which is clearly not my situation, so this is not my question, just a side note.

在旁注中,在项目安装指南中,我应该在安装 Oracle 后运行“sqlplus system@xe”。当我这样做时,我必须输入密码,然后我得到“ORA-12514:TNS:侦听器当前不知道连接描述符中请求的服务”。关于该错误的每个问题都是关于“它可以正常工作一个星期,现在不行了”,这显然不是我的情况,所以这不是我的问题,只是一个旁注。

采纳答案by Simon Levesque

One of my teammate found the answer. The problem was in the installation and here is what worked:

我的一位队友找到了答案。问题出在安装中,这是有效的:

Warning for Windows7 only:
Oracle 10g installation on windows 7 32-bit completes without error but it is incomplete. In order to fix the problem, before installing Oracle, shut down your PC, unplug your network cable, boot your PC and install Oracle (not a joke), and reconnect only after the installation of Oracle 10g.

仅适用于 Windows7 的警告
在 32 位 Windows 7 上安装 Oracle 10g 没有错误,但它不完整。为了解决这个问题,在安装Oracle之前,关闭你的PC,拔掉你的网线,启动你的PC并安装Oracle(不是开玩笑),只有在安装Oracle 10g后重新连接。

That is weird, but it worked

这很奇怪,但它有效

NOTE----This method doesn't worked with 11g express R2 . (ofcourse i am talking of windows 7)

注意----此方法不适用于 11g express R2 。(当然我说的是 Windows 7)

回答by Nagul Saida

I too faced the same issue and fixed by following the below steps.

我也遇到了同样的问题,并按照以下步骤进行了修复。

go to your Oracle XE 10g console using sqlplus. Replace mypassword with that your SYS user password (as specified during the installation process). Note that the number 2, 3, 4 at the left side is generated by the sqlplus tools prompt (you don't need to type them in).

使用 sqlplus 转到 Oracle XE 10g 控制台。将 mypassword 替换为您的 SYS 用户密码(在安装过程中指定)。注意左边的数字2、3、4是sqlplus工具提示生成的(不需要输入)。

[sourcecode lang="sql"]
C:\> sqlplus sys/mypassword@xe as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 18 17:53:47 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

连接到:Oracle 数据库 10g 快捷版 10.2.0.1.0 版 - 生产

SQL> begin
2 dbms_xdb.sethttpport('8484');
3 end;
4 /
[/sourcecode]

Oracle XE should reply:

Oracle XE 应该回复:

[sourcecode lang="sql"]
PL/SQL procedure successfully completed.
[/sourcecode]

After that check to ensure that the configuration has been changed properly:

之后检查以确保配置已正确更改:

[sourcecode lang="sql"]
SQL> select dbms_xdb.gethttpport as "HTTP-Port is " from dual;
[/sourcecode]

You should get a message like this:

你应该收到这样的消息:

[sourcecode lang="sql"]
HTTP-Port is
------------
8484
[/sourcecode]

Exit from sqlplus by typing "exit" at the prompt. Now restart the PC and check.e same issue.

通过在提示符下键入“exit”退出 sqlplus。现在重新启动 PC 并检查相同的问题。

回答by WCRC

Try this:

尝试这个:

1) First, make sure it's running. It sounds like it is from the error message you got in step 2, but double check that the Services (OracleServiceXE and OracleXETNSListener) are both started. Those are the only two services you need, and it does sound like the OracleServiceXE may not be running.

1) 首先,确保它正在运行。这听起来像是您在步骤 2 中收到的错误消息,但请仔细检查服务(OracleServiceXE 和 OracleXETNSListener)是否都已启动。这是您唯一需要的两个服务,而且听起来 OracleServiceXE 可能没有运行。

2) Make sure it's not running on a non-8080 port. From a command prompt, run netstat -an and see if anything is listening on port 8080. I've seen it get installed on alternate ports (including 9080) in the past.

2) 确保它没有在非 8080 端口上运行。在命令提示符下,运行 netstat -an 并查看是否有任何东西在侦听端口 8080。我过去曾看到它安装在备用端口(包括 9080)上。

3) If there's something listening on port 8080, try http://localhost:8080/in your browser. If there's something on 9080, try that.

3) 如果有东西在监听 8080 端口,请在浏览器中尝试http://localhost:8080/。如果 9080 上有东西,试试那个。