Home » RDBMS Server » Networking and Gateways » Configure Tnsnames.ora with a script
Configure Tnsnames.ora with a script [message #66234] Tue, 12 February 2002 00:17 Go to next message
Osman Bor
Messages: 1
Registered: February 2002
Junior Member
Hello,

Can somebody tell me how to configure the tnsnames.ora file with a script.
We are deploying several applications with SMS and they also need een the oracle client. I have managed to install the Oracle 8.1.6 client silent but now i wont to configure the tnsnames.ora file when i install a application with a script.
Our Oracle specialist does not now how to do this and he want's not Oracle Name Server.

Thanks
Re: Configure Tnsnames.ora with a script [message #66265 is a reply to message #66234] Mon, 25 February 2002 01:17 Go to previous message
MOE
Messages: 14
Registered: February 2002
Junior Member
Hi,
which OS is your client running?
If you install Oracle Client you can simply copy a pre-defined tnsnames.ora file to the directory $ORACLE_HOME/network/admin (%ORACLE_HOME%networkadmin on Windows).

If you have a pre-installed Client you must look for the TNS_ADMIN directory (if TNS_ADMIN is defined), otherwise it's the same directory as mentioned above. In this case you have to append the pre-defined tnsnames.ora file to the existing one: cat xxx/tnsnames.ora >> $TNS_ADMIN/tnsnames.ora (ren tnsnames.ora tnsnames.sav & copy tnsnames.sav + xxxtnsnames.ora tnsnames.ora on Windows)
helpfully?

MOe
Previous Topic: Re: Aplicacion Cliente sin Net8
Next Topic: Re: SQL STATE error
Goto Forum:
  


Current Time: Thu Mar 28 15:51:18 CDT 2024