Results 1 to 2 of 2

Thread: Ora-12505

  1. #1
    Join Date
    Mar 2012

    Unanswered: Ora-12505


    I am getting 'ORA-12505, TNS:listener does not currently know of SID given in connect descriptor' twice in a week only when my system is under production load.

    Can anyone guide me towards the probable cause of the behavior.

    Please let me know if any further information is required.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    the listener log file should also contain status value of 12505
    & that record will contain hostname/IP# of client which initiated the connection request.
    the problem & fix must occur on that specific client.
    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