Oracle XE occasionally doesn't start correctly
Hi,
I have the services OracleServiceXE and OracleXETNSListener set to start automatically and most of the time when I try to connect to the database in the morning after booting up it works fine. However, occasionally I get TNS-12514 or TNS-12505 errors.
I can tnsping the database and the services appear to be started. In Task Manager I can see oracle.exe running but it is only using ~300KB of memory, which seems low. If I leave it for 30mins the problem is still there, so I don't think it is anything to do with Oracle still loading or trying to sort itself out.
I've searched for all the log files in the OracleXE directory and alert_xe.log has not been updated at all today but there are logs with the listener and sqlnet errors.
The good news is that if I restart OracleServiceXE then everything works as normal.
So this is more of an annoyance than anything else, but if anyone has any ideas why it does this (I've also known it stop working halfway through a day) it would be appreciated.
Thanks,
John.
BTW. I'm running on Windows XP SP2 with Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product.