Oracle 10g express home page is not coming up

Question

Hello All:

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.

Answer 1

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)

Answer 2

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.