Site icon Narayana Tutorial

ORA-12519: TNS:no appropriate service handler found

How To fix this issue

This issue will occur due to lack of number process configured so that to fix this issue we need to update the Number of Process in this table V$RESOURCE_LIMIT.

First of all check the configured number of process using the following query.

SELECT * FROM V$RESOURCE_LIMIT WHERE RESOURCE_NAME='process';

Output

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------- ------------------- --------------- -----------
processes           148           150               150   

If CURRENT_UTILIZATION is almost equivalent to MAX_UTILIZATION then we need to increase the number of process using the following query.

How to increase the number of process

First up open the command prompt and type the following the queries

cmd>sqlplus / as sysdba
sqlplus>alter system set processes=300 scope=spfile;
sqlplus>shut immediate;
sqlplus>startup

And then check the number of process by using the select query. and then try to access the data base and you many not get this error.