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!

Command to determine path used to find tnsnames.ora

547375May 3 2007 — edited May 3 2007
How can know (with command or similar) the path that uses Oracle client to find tnsnames.ora file?

We need a command because not always we have administrator permissions on a workstation to make a regedit or to see environment variables, but we have to determine causes of problem connections.

If I’m working with client on UNIX, ‘tnsping name’ command shows a path of sqlnet.ora, usually the same that tnsnames.ora is allocated. Under windows doesn’t display information about this.

For example:

On UNIX:

tnsping ####

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.4.0 - Production on 03-MAY-2007 13:55:58

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/software/oracle/product/9.2.0/network/admin/sqlnet.ora

On WINDOWS:

C:\>tnsping ####

TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 03-MAY-20
07 13:58:51

(c) Copyright 1997 Oracle Corporation. All rights reserved.

TNS-03505: Message 3505 not found; No message file for product=NETWORK, facility
=TNS

Exists any command to do it or any command that shows this information?

Thank you very much!!!

Marc.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2007
Added on May 3 2007
8 comments
6,836 views