Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 11.2.0.2.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:

enter image description here

I've tried restarting OracleServiceXE and 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?

Update:

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.

share|improve this question
    
How odd. Is there anything in the database alert.log? –  Phil May 1 '13 at 18:31
    
@Phil - I don't have any file in c:\oraclexe called alert.log, but there is some interesting stuff in listener.log - I've added it to the question. –  Mike Christensen May 1 '13 at 18:35
    
"SQL*Plus: Release 11.2.0.2.0 Beta" Now that's odd. (The Linux XE 11g doesn't come with a beta sqlplus.) Look for a file called "alert_XE.log" in [oracle home]/diag/rdbms/xe/XE/trace –  Mat May 1 '13 at 18:38
1  
Your edit points to this ss64.com/nt/syntax-desktopheap.html - that may fix it. Is it also possible your app is leaking handles or something? –  Phil May 1 '13 at 18:38
    
@Phil - Both the server and sqlplus are being run on Windows 7. –  Mike Christensen May 1 '13 at 19:03

1 Answer 1

up vote 1 down vote accepted

You are encountering these problems because you are running a 32-bit version of Oracle XE on 64-bit Windows. This is not a supported configuration, and is known to have many documented problems.

Due to there not being a 64-bit version of XE, you can instead install the Standard Edition (free for development) from here. If you're also using APEX, you can get it here.

share|improve this answer
    
Excellent! Looks like installing 64bit Standard edition is the answer. Which is great, because XE is actually missing a few system functions that I had to write custom hacky versions of. –  Mike Christensen May 1 '13 at 19:44
    
No worries. Ask more questions on the site if you need any more help. We're here to help :) –  Phil May 1 '13 at 19:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.