I have a computer that do a connexion to a remote oracle database.
Where can i specify to it the emplacement of the tnsname on the server ?
Printable View
I have a computer that do a connexion to a remote oracle database.
Where can i specify to it the emplacement of the tnsname on the server ?
If you have sqlplus installed on your pc- it will look in the ORACLE_HOME/network/admin for a tnsnames.ora file. This file on your pc must have the information for the remote database that you want to connect to.
In addition the environment variable TNS_ADMIN can point to another location.
-clp