Narayana Tutorial

Online Java Tutorial Blog

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.

 

Narayanaswamy

Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in IT industry more than 7 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting and Website Development.

I am a self learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.

Leave a Reply

Narayana Tutorial © 2018 Frontier Theme
Show Button
Hide Button