| vikhardba |
Posted: Sep 22, 2007 05:28:01 AM |
Total Post: 84
Joined: Apr, 2007
|
ORA - 12541 : TNS : no listener error
Hai all,
When i am using OEM console, i get above mentioned error. I tried to start listener "lsnrctl start <LISTENER-NAME>" still same error...
Also checked in listener.ora and tnsnames.ora , port and hostnames are correct. Also tried "lsnrctl start" to start default listener... getting following error
starting tnslsnr : please wait...
Failed to start service, error 3
TNS - 12536 : TNS : operation would block
TNS - 12560 : TNS : protocol adapter error.
Please help me out.. |
|
|
 mahendra |
| Posted: Sep 22, 2007 07:03:33 AM |  |
|
Total Post: 2
Joined: Jul, 2007
|
check it wheather listener name are not mention in TNS.ora file.
now say
c:\lsnrctl\
lsnrctl>stop listener
lsnrctl>set current_listener lsn1
lsnrctl>start lsn1
before configuring tnsname.ora check it wheather lsnrctl are running or not.
|
|
|
|
|
| vikhardba |
| Posted: Sep 23, 2007 04:29:13 AM | |
|
Total Post: 84
Joined: Apr, 2007
|
Thanks for the speedy response. Yes, i tried ur steps as well but no luck. After i stop the listener (L1) and start again.. get same error which i mentioned earlier i.e; 'no listener'
But when i perform the following steps, issue is temporarily getting resolved until i keep my system up.
i.e; delete and recreate the listener and tnsnames respectively by using netca wizard. But i dont have any problem running my SQL .. I am able to work on it...
So, can anybody find out the permanent solution.
Regards,
Vikhar.
|
|
|
|
|
| parthokonar |
| Posted: Sep 25, 2007 01:28:07 PM | |
|
Total Post: 27
Joined: Sep, 2007
|
You will not face any problem untill and unless you are been connected through net service name provided in the tnsnames.ora.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:01:51 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
For further details on listener basics and usage refer:
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
