Thursday, September 29, 2011

Oracle XE ORA-12519

Started getting this error.  Googling found the answer in
http://www.atpeaz.com/index.php/2010/fixing-the-ora-12519-tnsno-appropriate-service-handler-found-error/

Summary:
Increase the number of processes by
1. login as sys as sysdba to a sqlsession.  You might need to close any existing connections
2. alter system set processes=150 scope=spfile;
3. restart your database.

Hope you found this useful.


No comments: