Command to determine path used to find tnsnames.ora
547375May 3 2007 — edited May 3 2007How 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.