Oracle XE 11g Homepage Does Not Display

Question

I have been looking for a solution to my problem for a while, but no one seems to be working, this is my last attempt before I proceed to reinstall.

Today I installed Oracle XE 11g Release 2 using the installation wizard, and everything went fine. The problem that I seem to encounter is that I cannot open the browser home page.

Browsers give me an error: cannot establish a connection to the server at 127.0.0.1:8080

I am on a 32-bit version of Windows 7 and I downloaded and installed XE for the same.

Of all the possible answers, I realized that some information may be needed before answering my question. So, the results of the various commands that I executed, all the answers were requested.

one)

 C:\Users\lenove> netstat -nao | find "8080" 

No result for this.

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

 SQL> SELECT dbms_xdb.gethttpport FROM dual; SP2-0640 : Not Connected 

4) Content oraclexe / app / oracle / product / 11.20 / server / network / ADMIN / listener.ora (oraclexe is the default installation directory suggested by the installation wizard)

 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oracle\oraclexe\app\oracle\product\11.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.

Note: This is my first oracle attempt, so I was a little afraid to try every solution suggested by threads, hence my own thread.

Thanx in advance!

Answer 1

I recommend that you proceed with the installation using the local administrative user.

On my computer: windows 7 professional, 64 bit

• associated with a user from a domain in the administration group: installation failed, without any message. In the log files located in /oraclexe/app/oracle/product/11.2.0/server/config/log , I found a lot of "unrelated" messages (sorry, I did not save the log files)

• associated with the local administrative user: installation work and menu work getStarted: the browser displays the Oracle Database XE 11.2 administration home page.

Answer 2

I installed on Windows 7 pro (under the local administrator account) and it went smoothly. I installed the same package on Windows 7 Home Premium (UAC is requesting a upgrade to local ADMIN), and I had a problem: there is no XE homepage.

First check which Windows services (through Control Panel> Admin Tools> Services) OracleServiceXE and OracleXETNSListener are actually running.

Then you can check (as shown in the top post) the TNS status provider using (adjust \ Oracle \ XE to the installation path)

 C:\Oracle\XE\app\oracle\product\11.2.0\server\bin\lsnrctl status 

which gives the listening endpoints, and if you don't see line three , for example (the third is probably missing!):

  (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 exactly where the problem is. The trick is to take into account the host name on which the TNS service is listening (for example, BHPPC in the example above). Then add the en entry to your C:\Windows\System32\drivers\etc\hosts as (on a separate line, with no space up to 127.0.0.1, and then spaces or a tab followed by your hostname):

  127.0.0.1 BHPPC 

and restart both of the Windows services listed above. Check the listening endpoints again with the lsnrctl status command; if the magic third row is now displayed, the XE home page will work. In fact, there is an error in resolving the host name, and you must provide the TNS service with an explicit IP address mapping, which, surprisingly, does not need to listen to OK on port 1521.