Let’s have look on some listener issues in the database.

Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.

Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.

Example:

Solution:

If you are using TNS files then you can check your TNS by the following way:

Fix the TNS information in tnsnames.ora file and check it.

Now it should Work.

Note: If you are using client and tnping is not working then check your client have installed that features or not. Usually, you will get the tnsping.exe file under bin folder if this features installed.

Today’s thought

“You have to act and act now.” – Larry Ellison

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.