Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: differences between Solaris and Windows in sqlplus connection specifiers?
Oracle software just follows the UNIX convention that a personal config
file stored at the user's $HOME begins with ".". Other than that,
there's really no explanation I can or need to make. If you truss
-topen tnsping yourSID, you'll see something like
open("/home/huany1/.tnsnames.ora", O_RDONLY) = 3 open("/var/opt/oracle/tnsnames.ora", O_RDONLY) = 3 So it checks the personal .tnsnames.ora file first.
Yong Huang Received on Mon Jan 03 2005 - 15:32:05 CST