- the home page go "page not found"
- "shared memory realm does not exist" errors in sqlplus
- port 8080 failed to come up in lsnrctl status/netstat -an find "TCP"
- inaccessible Oracle odbc dsns with "tns:no listener" errors
- Install the Microsoft Loopback Adapter
- Use a static IP address
- Disable all other networking
Instead open up a command prompt and enter the following:
sqlplus / as sysdba
startup;
And this gets rid of the various problems I experience. This is in no way comprehensive. Oracle seems to be happy to leave their customers to trawl google for laundry lists of symptoms and fixes compiled by various bloggers and tweakers.
This isn't a bad article (though not specific to XE).
http://www.dba-oracle.com/oracle9iAS_tips_windows_service.htm
Neither is this
http://psst0101.wordpress.com/2007/06/13/getting-oracle-10201-to-start-automatically/
1 comment:
Great, will try this.
Post a Comment