Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsping displays TNS-12541: TNS:no listener

Greg CarsonDec 29 2016 — edited Dec 29 2016

Our Oracle DBA is on vacation, so please help a noob.

Users cannot connect to an Oracle instance.  Oracle DB is Version is 11.2.0.4.0

I am on the Oracle server(Server 2012R2) and cannot tnsping the DB.  I receive tns-12541: TNS:no listener

I have tried to connect using sqlplus; "sqlplus sys/xxxxx@ODOTTEST as sysdba" (on the oracle server) and get ORA-12541:TNS:no listener.

I have restarted the TNS Listener services and  I have rebooted the server (with NO success-I receive the same errors)

lsnrctl status is attached and so is the listener.ora file

What else can I look at?

This post has been answered by AndrewSayer on Dec 29 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2017
Added on Dec 29 2016
27 comments
9,018 views