Please tell me does sqlplus uses TNS_ADMIN variable on UNIX and AIX? Can we able to locate sqlplus if this variable could not be located?
A:
On Linux the answer is "Yes":
export TNS_ADMIN=$ORACLE HOME/network/admin
demas
2009-11-30 06:18:45
What would happen if this variable is not found?
Sachin Chourasiya
2009-11-30 06:20:40
This variable points to TNSNAMES.ora, configuration file that defines databases addresses for establishing connections to them.
demas
2009-11-30 06:24:12
If tnsnames.ora could not be located , then the login string could not be built. Are there any chances that sqlplus could not be located?
Sachin Chourasiya
2009-11-30 06:31:45
+1
A:
Sqlplus is just an executable file after all. Unix searches the directories listed in $PATH for it. You can use which sqlplus to find out full path to sqlplus.
Sqlplus itself can use $TNS_ADMIN, but absense of this variable cannot prevent OS from locating sqlplus.
egorius
2009-11-30 07:02:09
Exactly, I am amazed why my sqlplus caould not be located if TNS_ADMIN is not there
Sachin Chourasiya
2009-11-30 09:10:12