06-10-10, 11:02 #1Registered User
- 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.
06-10-10, 12:14 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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.