Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Lightbulb Unanswered: Missing TNSNAMES.ora entry

    Okay I'm turing to the guru's for this one. After much research and hair pulling. I have been trying to find a way to locate Oracle instances within our enterprise, where the tnsnames information as been lost. Example the rman catalog is used for backups, but after looking through every document and logging on to most if the servers. I can not find the rman DB.

    The Question: is there a way to find Oracle instances that you do not have a refrence for?


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    There is NOT a 100% all the time reliable method.
    Locating & dissecting listener.ora will likely prove better than some/many/most methods.

    HTH & YMMV
    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