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
