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
|
|
|
|
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
|
|
|
|
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:35Thanks 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.
|
|
|