OraFAQ Forum: Networking and Gateways » Error: ORA-12541: TNS:no listener while loging in to DB

Home » RDBMS Server » Networking and Gateways » Error: ORA-12541: TNS:no listener while loging in to DB (Oracle 11.1.0, OS- Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error: ORA-12541: TNS:no listener while loging in to DB [message #422814]

Sat, 19 September 2009 13:33

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

I installed Oracle 11g on my windows 7 desktop yesterday. It was working fine. Today when I was trying to connect through toad or plsql developer it is giving the error: ORA-12541: TNS:no listener

Database is up and running.

PS C:\Users\Ridhi Sundar> sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Sep 19 23:55:21 2009

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

Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

when i am trying to connect with service name it is giving error.

PS C:\Users\Ridhi Sundar> sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Sep 19 23:57:26 2009

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

Enter user-name: system/password@ORCL
ERROR:
ORA-12541: TNS:no listener


Enter user-name:

Listener status gives below error:

PS C:\Users\Ridhi Sundar> lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 19-SEP-2009 23:59:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
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
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.105)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error
PS C:\Users\Ridhi Sundar> lsnrctl status ORCL

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 19-SEP-2009 23:59:23

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.105)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error
PS C:\Users\Ridhi Sundar> lsnrctl start ORCL

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 19-SEP-2009 23:59:37

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error

PS C:\Users\Ridhi Sundar>

Please help to troubleshoot this error.

Thanks
Ridhi

Report message to a moderator

Re: Error: ORA-12541: TNS:no listener while loging in to DB [message #422820 is a reply to message #422814]

Sat, 19 September 2009 19:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

First make sure ORCL is your tns service name.
Check listener.ora or in your window services panel.
Start it from windows services
or manually

lsnrctl start Listener_name

Report message to a moderator

Re: Error: ORA-12541: TNS:no listener while loging in to DB [message #422824 is a reply to message #422820]

Sat, 19 September 2009 22:35

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

Thanks Mahesh

Yesterday night I struggled a lot to fix it. But could not fix. I just shut my system. To day morning when I opened the system it's working.....

Yesterday the oracle DB console and listener in the services were down when i tried to start them from services those were failing. But these are started automatically when I started my system today morning.

Does any one have any idea what wud be the reason for this?

Thanks
Ridhi

Report message to a moderator

Re: Error: ORA-12541: TNS:no listener while loging in to DB [message #422825 is a reply to message #422824]

Sat, 19 September 2009 23:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Does any one have any idea what wud be the reason for this?
Classic Windoze (mi)behavior or gremlins; which is redundant.

Report message to a moderator

Re: Error: ORA-12541: TNS:no listener while loging in to DB [message #422850 is a reply to message #422824]

Sun, 20 September 2009 19:00

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

ridhi_sundar wrote on Sun, 20 September 2009 05:35

Thanks Mahesh

Yesterday night I struggled a lot to fix it. But could not fix. I just shut my system. To day morning when I opened the system it's working.....

Yesterday the oracle DB console and listener in the services were down when i tried to start them from services those were failing. But these are started automatically when I started my system today morning.

Does any one have any idea what wud be the reason for this?

Thanks
Ridhi

Hi,
I have seen this behaviour. The Windows platform does not start the instance...automagically. Strange.

There are some theories that it has to do with some privilegies somewhere, but Oracle Support did not give me any clues.

I will reinitiate the support issue to them. Now, that I know other people have the same questions.

Best Regards,
Lars Sjöström
PS I just start the instance every time this happens. The error message is ... well...erroneous.

Report message to a moderator

Previous Topic:	Oracle ssh remote tunnel - Access database objects via TOAD
Next Topic:	ora-12203

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:02:29 CDT 2024