Re: Default location for tnsnames.ora

--0__=ipKXhYxLfcMcc3sz1oexm0xWxnsUeO1oSW98NR2GyDBPdmoeVCXcIDcV
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

The default locations' of the tnsnames.ora (listener.ora, sqlnet.ora, etc) a.ka. SQLNET configuration files is documented in the operating system specific 'Installation and Configuration Guide'. The normal behavior for searching these files is:

1. TNS_ADMIN
2. $ORACLE_HOME/network/admin
3. /etc (HPUX, LINUX) or /var/opt/oracle (SOLARIS)
4. current working directory

Cheers

Renato Huliganga
Senior Database Administrator
Database Services, IBM Global Services A/NZ

"Walter K." <alden14004_at_yahoo.com> on 02/05/2000 09:04:44

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Renato Huliganga/Australia/IBM) Subject: Default location for tnsnames.ora

On a system I used to work on (HP-UX 11.0), the tnsnames.ora file was stored in /etc. My question is, where is it specified that this path is the location to use for reading this file?

No link existed for $ORACLE_HOME/network/admin/tnsnames.ora to redirect it to /etc. No TNS_ADMIN variable is being used.

Thanks.
-w

--0__=ipKXhYxLfcMcc3sz1oexm0xWxnsUeO1oSW98NR2GyDBPdmoeVCXcIDcV
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjkyMC4wIiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT48L1NUWUxFPg0KPC9IRUFEPg0K PEJPRFkgYmdDb2xvcj0jZmZmZmZmPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5PbiBh IHN5c3RlbSBJIHVzZWQgdG8gd29yayBvbiAoSFAtVVggMTEuMCksIHRoZSANCnRuc25hbWVzLm9y YSBmaWxlIHdhcyBzdG9yZWQgaW4gL2V0Yy4gTXkgcXVlc3Rpb24gaXMsIHdoZXJlIGlzIGl0IHNw ZWNpZmllZCB0aGF0IA0KdGhpcyBwYXRoIGlzIHRoZSBsb2NhdGlvbiB0byB1c2UgZm9yIHJlYWRp bmcgdGhpcyBmaWxlPyA8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0y PjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+Tm8gbGlu ayBleGlzdGVkIGZvciANCiRPUkFDTEVfSE9NRS9uZXR3b3JrL2FkbWluL3Ruc25hbWVzLm9yYSB0 byByZWRpcmVjdCZuYnNwO2l0IHRvIC9ldGMuIE5vIA0KVE5TX0FETUlOIHZhcmlhYmxlIGlzIGJl aW5nIHVzZWQuPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFj ZT1BcmlhbCBzaXplPTI+VGhhbmtzLjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1Bcmlh bCBzaXplPTI+LXc8L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg==

--0__=ipKXhYxLfcMcc3sz1oexm0xWxnsUeO1oSW98NR2GyDBPdmoeVCXcIDcV--
Received on Mon May 01 2000 - 17:44:28 CDT