We are trying to resolve the issue related to error ORA-12520 TNS:listener could not find available handler for requested type of server.
Suddenly all the users are facing the issue and reported to DB team to resolve the issue. Lets start to check and resolve.
DBA checked the connection and facing same issue as below snap
Checking if the tnsping is working or not. But it’s working fine.
Now, DBA checking any resource limit is exceeding in database or not.
SQL> select resource_name,current_utilization,max_utilization,initial_allocation,limit_value from v$resource_limit;
At this stage, DBA Increasing the processes in database as below command
SQL> alter system set processes=1200 scope=spfile;
Note:- Restart the Database and check again the resource limit is exceeding in database
Now tried to connect/access the Database using service but again failing with same error
Now checking the listener status, but this also no issue.
Now fed-up with this error !.
Lets start once again, checking the listener parameter within the Database
Now DBA going to set the LOCAL_LISTERNER as below snap and let’s see.
Now, Restart the database and check this parameter again.
Now again, Let’s try to connect to database using service.
Now my all the users are able to connect to the database.………………Enjoy and stay connected
Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
A. Rawat
Email: 88arawat@gmail.com