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

Thanks for the response guys. I finally figured out how to solve the issue, but not really the root cause.

Problem 1 - Can not login to oracle admin console. It was the problem with not adding 127.0.0.1 in the IE intranet sites. Go to tools>internet options>security>local intranet sites>advanced> add http://127.0.0.1:8080/apex in the list.

It works fine after this. But if I go back to the same place again and see the sites, I cant find the url I added sometimes back... Dont know why that is happening. May be some company security is messing up. Anyways the admin console is now coming up.

Problem 2 - Cannot connect using SQL Developer. After I did the fix for problem 1, this is also magically working. I still don't know how security settings in IE affects SQL Developer? Any comments on this?

Answer 3

I had a similar problem, I was able to connect to SQLPLUS using terminal but on access in browser as it was showing error as you have described. So, I went back to terminal and mounted my database using

startup

and it resolved my problem. This might be the case.

Answer 4

Try this ( I'm assuming Windows system )

using

netstat 

without anyother parameter would tell you if port 8080 is already open.

Also you can try this:

telnet localhost 8080

If the server answers ( the screen goes blank [or black] ) then the server is up and running.

Try using your hostname instead of localhost.

See if you're using a proxy and not skipping the local addresses.

Also you can see what's the executable that starts the home page and see if it could start successfully.

Answer 5

hey guys one important fact if u r using IE7 (explorer7) then u wd face certain problem in using 10g, such as not displaying home page.

Answer 6

For Windows 8 simply click on Get Started With OracleXE.... When internet explorer opens up, select the View on the desktop option in the Page View icon (icon with a wrench).

You should now be able to view your page.