Oracle 10g express home page is not coming up

Question

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.

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?

Answer 1

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

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

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

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

select dbms_xdb.GETHTTPPORT from dual;

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

Answer 2

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.

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

Answer 3

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

2030: Oracle Services for Microsoft Transaction Server

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

See software requirements in the below URL:

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

It worked for me!