Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues.

TNS-12516 TNS: listener could not find an instance with the matching protocol stack
ORA-12516 TNS: listener could not find available handler with the matching protocol stack
TNS-12519 TNS: no appropriate service handler found
ORA-12519 TNS: no appropriate service handler found
ORA-12520 TNS: listener could not find available handler for requested type of server

Cause:

None of the known and available service handlers for the given SERVICE_NAME support the client’s protocol stack: transport, session, and presentation protocols.

Solution:

check if the number of current connections by using the following command in Unix:

ps -ef | grep oracleSID | grep -v grep | wc –l

Check process parameter in the database

SQL> select * from v$version;

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

PL/SQL Release 11.2.0.3.0 – Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 – Production

NLSRTL Version 11.2.0.3.0 – Production
SQL> show parameter processes

NAME      TYPE    VALUE
——————--- ———–--- --——-
processes integer 200

SQL> select count(*) from v$process;

COUNT(*)

———-

199

Increase process:

processes=x

session=(1.5 * PROCESSES) + 22

SQL> alter system set processes=300 scope=spfile;

Processes is not a dynamic parameter, so you need to restart the database to take the effect.

Thought of the Day!

No matter what people tell you, words and ideas can change the world. — Robin Williams

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.