Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2002
    Posts
    17

    Unhappy Unanswered: SID given in connect descriptor could not be resolved

    Hi,

    I created a new instance of Oracle 7.3.4.4. The server already has many other instances. I used an existing init.ora, edited it for the new SID and the instance got created successfully. All the post installation scripts were executed successfully too. I am able to login to my instance from within the UNIX box but when I try to connect through my NT client, I get the following error:

    SID given in connect descriptor could not be resolved

    I have tried all possible combinations in my local TNSNAMES.ORA but nothing helps. Am I supposed to do something else at the server side?

    Your help will be highly appreciated.

    Thanks,
    Sridhar
    Last edited by abujji; 05-24-04 at 13:29.
    Bujji

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Did you add the new SID to the Oracle listener.ora file & bounce the Oracle listener? If not, then you won't be able to connect to it via SQL*net.
    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.

  3. #3
    Join Date
    Apr 2002
    Posts
    17
    Thanks for your suggestion. By bouncing the Oracle Listener, are you referring to stopping and starting the newly created Oracle Instance?
    Bujji

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    lsnrctl status
    # add to listener.ora file new SID entry
    lsnrctl stop
    lsnrctl start
    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.

  5. #5
    Join Date
    Apr 2002
    Posts
    17
    It worked !! Thanks a million !!
    Bujji

  6. #6
    Join Date
    Apr 2009
    Posts
    6
    i do not understand how to bounce the listener..
    lsnrctl status
    # add to listener.ora file new SID entry
    lsnrctl stop
    lsnrctl start

    this does not make sense to me how do i do that

Posting Permissions

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