I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out.
There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 times yesterday and so far twice this morning. I'm developing a .NET app, and sometimes when I start the app, refresh the page, or do whatever, I get an exception that a connection could not be made to the database. I then try to connect with sqlplus I just get:
C:\>sqlplus user/password@localhost SQL*Plus: Release 22.214.171.124.0 Beta on Wed May 1 11:08:53 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved.
It then just sits there forever. No timeout, no error, no nothing. I can't connect with any other database program either, the whole server is just unresponsive.
If I go into the Services manager, I see that the services are indeed running so nothing has crashed:
I've tried restarting
OracleXETNSListener. Both will shut down and restart, however I still cannot make a connection to the server.
The only thing that fixes this problem is a complete Windows reboot. However, this of course takes 5-10 minutes and is really starting to get old.
There does not appear to be anything related to Oracle around this time in the Windows Event Viewer. I'm happy to add any other information that would help debug. Any ideas?
I did notice a few strange errors in
listener.log. These errors start the exact same time the crashes started happening:
30-APR-2013 08:50:42 * 12531 TNS-12531: TNS:cannot allocate memory Tue Apr 30 08:52:28 2013 30-APR-2013 08:52:28 * 12531 TNS-12531: TNS:cannot allocate memory Tue Apr 30 08:52:58 2013 30-APR-2013 08:52:58 * 12531 TNS-12531: TNS:cannot allocate memory
Last 1,000 lines of alert_XE.log are here.