ORA-12541: TNS:no listener ( ERROR coming when one node of RAC database is off

[agrawaltanu1]

In the server node(the node which is running,other node is shut down), if i use command lsnrctl status, the following error comes.


C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-JAN-2007 16:21:45

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

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

Unable to find the reason for this.

Plzz help !

Regards.

[davey23uk]

becuase the listener isnt running

[agrawaltanu1]

But i checked services, the listener services is running.

I thought since the listener services are running, implies that listener is running.

I dunno whether i'm right or wrong.

[davey23uk]

its telling you right there, the listener isnt running

[agrawaltanu1]

Yup, I know something is wrong with the listener... either it's not running or some other problem with it... I just dunno the exact reason and how to fix it.

I've already posted all my tnsnames.ora and listener.ora file....just confused what next to do. feeling frustrated

More help'll be highly appreciated


Regards

[davey23uk]

lsnrctl start

[agrawaltanu1]

Used the coomand and got the following error emssage.


C:\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-JAN-2007 19:14:04

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

Starting tnslsnr: please wait...

Failed to open service , error 1060.
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNSrotocol adapter error
TNS-00512: Address already in use
32-bit Windows Error: 48: Unknown error

Listener failed to start. See the error message(s) above...


Regards

[agrawaltanu1]

Help me plzz guyz...I'm so frustrated and depressed

OR Is it that you are not getting my problem properly?

[Bore]

Well, sorry to say that, but what about reading a bit the documentation and some articles and books instead of just waiting someone to solve your problem? Obviously you are completely unable to diagnose any networking issue, due to absolute lack of knowledge how the Oracle networking operates. The neworking is relatively simple part and I belive that within 2 days one could learn it from scrach.
The forum could give you a hint, could even solve your problem IF you are able to provide adequate information, but don't expect someone, sitting thousands miles away from your environment to take his christal ball and tell you what exactly is wrong with your system

[Thomasps]

Your listener name is

LISTENER_TGVIRTUALTWO
LISTENER_TGVIRTUALONE

So, to know the status, type

lsnrctl status LISTENER_TGVIRTUALONE
lsnrctl status LISTENER_TGVIRTUALTWO