DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: No Listener error although Listener started

  1. #1
    Join Date
    Apr 2001
    Location
    San Diego
    Posts
    1

    Post

    Although the Listener is running, when I try to connect to it, I get error 12541 tns no listener. The connect descriptor appears to be in sync. with the listener.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    12541, 00000, "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.


    Check your listener and tnsnames.ora configurations again.

    Confirm it through

    lsnrctl status
    lsnrctl service

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2000
    Posts
    462
    If your listener is started it's a tnsnames.ora problem.

  4. #4
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    I have seen one additional factor, if the listener was started for a prior start of the database.

    ie

    start database
    start listener
    stop database
    start database

    On some platforms and/or when your tongue is in the wrong cheek, the listener looses contact with the database. Stopping and restarting the listener clears it up.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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