Home » RDBMS Server » Networking and Gateways » Error: ORA-12541: TNS:no listener while loging in to DB (Oracle 11.1.0, OS- Windows 7)
Error: ORA-12541: TNS:no listener while loging in to DB [message #422814] Sat, 19 September 2009 13:33 Go to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 22520
Registered: January 2009
Senior Member
>Does any one have any idea what wud be the reason for this?
Classic Windoze (mi)behavior or gremlins; which is redundant.

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 Go to previous message
linlasj
Messages: 87
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.
Previous Topic: Oracle ssh remote tunnel - Access database objects via TOAD
Next Topic: ora-12203
Goto Forum:
  


Current Time: Tue Jul 29 02:45:55 CDT 2014

Total time taken to generate the page: 0.13730 seconds