Lovely intermittent Oracle XE problem


I’m working on AR-JDBC support for Oracle. The easiest way to do this for me is to run Oracle XE inside Windows XP in Parallels. That works fine. Except for this dreaded message that started showing up and killing all my efforts: “ORA-12519, TNS:no appropriate service handler found”. I love Oracle error messages. They are so incredibly helpful!

At least in this case I found a solution to the problem on da Internet. I’m writing this blog post to make the information more obvious to Google.

It seems there is a bug in Oracle XE in the monitoring of processes that manifests this way. Nice. But you can fix it! Just open up your SQL console, write “connect system”, submit your password and then write “ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;”. After that, remember to restart the listener. And everything should be joy again.


3 Comments, Comment or Ping

  1. Anonymous

    I wonder if you could get AR to shout that at the database if that error shows up?
    Otherwise something like AutoIT might be useful.

    September 26th, 2007

  2. watt

    If you do search by “ORA-12519” you will get plenty of help. Crap as their messages may be, including the unique message id in the message is a saver.

    September 26th, 2007

  3. Christian Seiler

    a bit offtopic: you mentioned Parallels, so I assume you’re on OS-X. I’m thinking about finally leaving Windows and would like to switch to OS-X, but the availability of the Java JDK on OS-X pretty much discourages me to do so.

    Just wondering about your optionion on that since you’re pretty muchenvolved in Java

    September 26th, 2007

Reply to “Lovely intermittent Oracle XE problem”