Configure Tnsnames.ora with a script [message #66234] |
Tue, 12 February 2002 00:17 |
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 |
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
|
|
|