Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieving the location of tnsnames.ora file used by database links

RobKSep 8 2011 — edited Sep 9 2011
Hello

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2011
Added on Sep 8 2011
25 comments
16,547 views