ORA-12519, TNS:no appropriate service handler found

I often encountered this error after setting up a new machine with jboss/seam/oracle project installed.

To resolve this:
1.) Open command prompt, by typing cmd in Start
2.) Execute c:\windows\system\sqlplus system@YOUR_SID
3.) Execute "ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;"

Then restart the oracle database or your computer.
ORA-12519, TNS:no appropriate service handler found ORA-12519, TNS:no appropriate service handler found Reviewed by Edward Legaspi on Sunday, June 19, 2011 Rating: 5

No comments:

Powered by Blogger.