Database Home Page Stopped Working After Norton Upgrade
Good Evening,
I performed a successful installation of Oracle Database XE on Windows XP Home Edition (yes, I know it's not supported). The installation went smoothly and I was able to launch the Database Home Page successfully and log in. I was also able to use command line SQL fine. At the time of the install, I had Norton AntiVirus 2003.
I recently upgraded to NAV 2006. Since then, I have not been able to launch the Database Home Page (http://127.0.0.1:8080/apex). I get a 'page cannot be displayed' error. I've read through all the various posts regarding Database Home Page problems and have tried several of the suggestions (changed the port number, disabled NAV internet security, created a rule to allow port 8080, etc.). No matter what I do, I can't get the Home Page to launch. I haven't tried re-installing XE since I'm afraid it may make matters worse (at least now I still have a working database, just no Home Page).
I can ping 127.0.0.1 fine. I can ping localhost fine. I can tnsping XE fine.
The output of lsnrctl status shows that I don't have any services for XE (only services listed are for CLRExtProc and PLSExtProc) or any entry for (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=8080))(Presentation=HTTP)(Session=RAW)).
The listener.log initially showed entries like:
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Since the problem started, the above port 8080 references no longer appear. I now see the following message instead:
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument
Short of re-installing XE and possibly losing the functionality I currently have, does anyone have any suggestions about how I may get the Home Page to work? If the cause of my problem is NAV 2006, what set-up changes do I need to make?
Thanks for any helpful suggestions.
Natasha