Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    Unanswered: how to flush the buffered old tnsnames.ora in a live process?

    I have a OCI daemon program which load Oracle client libraries to communicate with Oracle server.
    The daemon program is running, I add a new node entry in tnsnames.ora. But the new node can not be pickup immediately by the live daemon. The a error reports:
    "node is not found in the node directory".

    I have to restart my daemon program to read the new added node entry.

    It seems oracle client buffered old tnsnames.ora somewhere.

    The question is , is there anyway to flush the old tnsnames.ora and fresh the new one without restart the daemon?

    Thanks a lot for any comments!
    Last edited by bang91; 06-10-10 at 11:26.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    tnsnames.ora is simply a regular OS text file; much like /etc/hosts

    >It seems oracle client buffered old tnsnames.ora somewhere.
    & Which oracle client would that be?

    Perhaps your code should open & read the whole tnsnames.ora every time it accesses it.
    This way it would always get the latest & correct information.
    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