ORA-12519: TNS:no appropriate service handler found

The number of database processes that can run in Oracle DB is set to 150 as default which can be viewed from v$resource_limit.

select * from v$resource_limit where resource_name = 'processes';


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

We face this issue – ORA-12519 ,  randomly when the number of DB processes utilized by our application is more that 150. So we need to increase the number of DB processes inorder to avoid the issue. Use below steps to incresae the limit.

[code language=”sql”]

sqlplus / as sysdba
sqlplus>alter system set processes=500 scope=spfile;
sqlplus>shutdown immediate;
sqlplus>startup

[/code]

Now query the view to see the new limits in effect.

select * from v$resource_limit where resource_name = 'processes';


RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------- ------------------- --------------- ------------------ -----------
processes      279                  285             500                500

 

 

Leave a Reply