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!

TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error

598948Apr 9 2009 — edited Apr 9 2009

My database listener is up, but when I am trying to connect to database it is giving error "No Listener"
Also when I am giving STATUS command on Listener prompt I am getting below error:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=NODE1)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
32-bit Windows Error: 54: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory

Can anybody help me out, what actually causing this issue???

Regards,
Sushil

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2009

Added on Apr 9 2009

#general-database-discussions

7 comments

8,209 views