2007年3月18日 星期日

ORA-12519, TNS:no appropriate service handler found

Scenario

My application will throw the ORA-12519, TNS:no appropriate service handler found error message, as the application is working for awhile. The complete exception message is as belows:

javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorizedSQLException for SQL [???]; SQL state [null]; error code [0]; Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE
; nested exception is java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE

Solution

Go to modify the init.ora this script file. Modify job_queue_processes this value.
###########################################
# Job Queues
###########################################
job_queue_processes=200

As you finish it, you HAVE to restart the oracle service.
You can use this sql statement to check if your configuration is in effect or not.
select value from v$parameter where name = 'processes';

沒有留言: