ORA-12541: TNS:no listener ( ERROR coming when one node of RAC database is off - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

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

  1. #11
    Join Date
    Jan 2007
    Posts
    12

    Red face

    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.

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    becuase the listener isnt running

  3. #13
    Join Date
    Jan 2007
    Posts
    12

    Red face

    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.

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    its telling you right there, the listener isnt running

  5. #15
    Join Date
    Jan 2007
    Posts
    12
    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

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    lsnrctl start

  7. #17
    Join Date
    Jan 2007
    Posts
    12
    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

  8. #18
    Join Date
    Jan 2007
    Posts
    12
    Help me plzz guyz...I'm so frustrated and depressed

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

  9. #19
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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

  10. #20
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Your listener name is

    LISTENER_TGVIRTUALTWO
    LISTENER_TGVIRTUALONE

    So, to know the status, type

    lsnrctl status LISTENER_TGVIRTUALONE
    lsnrctl status LISTENER_TGVIRTUALTWO
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width