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.

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:

Check process parameter in the database

Increase process:

processes=x

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.