Retrieving the location of tnsnames.ora file used by database links
RobKSep 8 2011 — edited Sep 9 2011Hello
I have a running (10.2) database instance to which I can connect as dba. It's on Windows.
I created I dblink which is supposed to use tnsnames.ora config file:
create database link rlink connect to x identified by x using 'HUBX';
I don't know from which directory the oracle service was started. I don't know the OS global variable settings. I can't read the registry.
Hence I can only guess the location of tnsnames.ora file being used by the database.
Is there any way to avoid the guesswork and retrieve the path of the tnsnames.ora being used from the database?
Thanks in advance.
Rob