Skip to Main Content

Oracle Database Discussions

TNS-12541 TNS no listener

TheHades0210Feb 6 2012 — edited Oct 19 2012
Aloha!

I have an Oracle 11g R2 running on Windows 2003. Currently i have this error every time i try to start the LISTENER on cmd prompt.

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 12:46
:02

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

C:\>lsnrctl service

Status are:

On service LISTENER is started, but when i connect to an instance i get this error:

C:\>sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 6 12:59:35 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

Can someone please help me. Our prod env is currently stopped. :(

Hades,
This post has been answered by Nikolay Ivankin on Feb 6 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2012
Added on Feb 6 2012
30 comments
44,717 views