TNS-12541 TNS:no listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TNS-12541 TNS:no listener

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    9

    Angry

    AT SQL+
    ========
    ERROR:
    ORA-12541: TNS:no listener
    ----------------------------

    Got the following details from the document

    TNS-12541 TNS:no listener

    Cause: The connection request could not be completed because the listener is not running.

    Action: Ensure that the supplied destination address matches one of the addresses used by the listener. Compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

    ------------------
    But Our TNSNAME.ORA address match with LISTENER.ORA.
    ------------------

    At Listener Control
    ===================

    LSNRCTL> test
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    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
    ------------------
    LSNRCTL> show current_listener
    Current Listener is LISTENER
    ------------------
    tnsping krishna
    TNS-12541 TNS:no listener
    ------------------
    We think Listener auto is also not woking in this case.
    ------------------
    The error that has been in Listener log file is
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 38: Filename too long

    Is it windows error.
    Our db file name is 8chr long.
    Is there any rules to have a db file name with in 4chr.



  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Is your Lisyener running ?
    Did you try --

    LSNRCTL> STATUS

    If it is not running the nSTART is bu --

    LSNRCTL> START LISTENER

    - Rajeev



  3. #3
    Join Date
    Nov 2000
    Posts
    9

    Unhappy

    Thanks for you reply
    I started the listener. But it is not started.
    I think this is OS problem.
    I uninstalled all oracle things and going to reinstall.

  4. #4
    Join Date
    Nov 2000
    Posts
    9

    Unhappy

    It shows adapter error.

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    could you post the exact error message ?

    - Rajeev

  6. #6
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I mean the error message when you run --

    LSNRCTL> START LISTENER

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