| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tns_admin on nt problem
Hi Barry,
With NT I have had differing levels of succes depending upon the Oracle product and version.
eg OEM 204 I couldn't get to work with a tns_admin variable set.
The best success I have had is by setting a system environment variable (via the control panel) with a name of TNS_ADMIN and the relevant value.
It might be worth trying an environment variable in your case.
Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au
-----Original Message-----
From: barry botuck [mailto:botes_at_hq.idt.net]
Sent: Thursday, 21 September 2000 14:36
To: Multiple recipients of list ORACLE-L
Subject: tns_admin on nt problem
I wanted an NT client machine to use a remote tnsnames.ora file and not
the local tnsnames.ora found in the network\admin directory. The method
that usually works is to create a registry entry TNS_ADMIN which points to
the remote tnsnames.ora. In the past week I have had mixed results employing
this method on 2 different machines. On one client machine running a brio
application both the application and the tnsping utility were pointing to
the remote tnsnames file . However sqlplus was still looking at the local
tnsnames file. Does anybody know what could be causing this.
On a separate client machine the TNS_ADMIN worked for all oracle
applications like Quest SQL navigator etc) but the Microsoft Access program
could no longer attach to oracle tables (it still wanted to use the local
tnsnames.ora)
Does anybody know if there is another parameter besides TNS_ADMIN that
controls where sqlnet looks for the tnsnames,ora file,
Thanks,
Barry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: barry botuck
INET: botes_at_hq.idt.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 20 2000 - 21:45:40 CDT
 |
 |