Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Lightbulb Unanswered: Connection failed

    Hi ,

    I am trying to connect to Oracle database which has an instance named "test1.orcl" . I am able to connect through TOAD , but not from my Java Program . The following error is thrown

    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    Is the issue due to the presence of dot(.) in instance name..
    Please suggest

  2. #2
    Join Date
    Jun 2009
    Posts
    7
    Wait a moment and try to connect a second time.


    Check which instances are currently known by the listener by executing: lsnrctl services <listener name>

    Check that the SID parameter in the connect descriptor specifies an instance known by the listener.

    Check for an event in the listener.log file.

  3. #3
    Join Date
    Aug 2007
    Posts
    64
    I tried waiting for 10 mins, the same error . I am able to connect from TOAD.

    I executed the command 'lsnrctl services', the instance specified is ready for connections

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"
    // *Cause:  The listener received a request to establish a connection to a
    // database or other service. The connect descriptor received by the listener
    // specified a SID for an instance (usually a database instance) that either
    // has not yet dynamically registered with the listener or has not been
    // statically configured for the listener. This may be a temporary condition
    // such as after the listener has started, but before the database instance
    // has registered with the listener.
    // *Action: 
    //  - Wait a moment and try to connect a second time.
    //  - Check which instances are currently known by the listener by executing:
    //    lsnrctl services <listener name>
    //  - Check that the SID parameter in the connect descriptor specifies
    //    an instance known by the listener.
    //  - Check for an event in the listener.log file.
    post results from following commands

    lsnrctl status
    lsnrctl service
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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