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.


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


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

Check process parameter in the database

Increase process:


session=(1.5 * PROCESSES) + 22

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.