Yup it is a string and not a key - thanks for pointing that out :)
-Original Message-
Sent: Wednesday, May 30, 2001 05:36
To: Multiple recipients of list ORACLE-L
versions of tnsnames.ora in NT/W2K]
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple
folders, like:
On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get
Oracle db to work off of the tns_admin key. Only forms would work off of
the tns_admin, and without that key forms would not connect to the dbs.
Just thought I would mention that.
Kev
-Original Message-
Sent:
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple
folders, like:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1
then you have to create TNS_ADMIN string value (not key) in each of those
folders pointing to your master tnsnames.ora file.
It is a good point that it's a string, I actually knew that, but it still
doesn't explain why i can't get it to work. Not that it's that big of a
deal. I'll try again, no harm in that.
Kev
-Original Message-
Sent: Wednesday, May 30, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
I've actually had better luck setting it as a (system) environment variable
rather than in the registry.
Depends what software you are using to (eg OEM 2.0.4 did not work with the
environment variable).
Regards,
Bruce
-Original Message-
Sent: Thursday, 31 May 2001 5:07
To: Multiple
I have a server NT4.0, SP5 that has two versions of Oracle installed. On
drive J is Oracle 8.0.5 which is used by a third party app and has been up
and running for about a year. This last week I installed on drive E Oracle
8i 8.1.7 and have not yet created a database. This Saturday on of the
Dave,
It seems to me that you are having a problem reading the proper TNSNAMES.ORA for
the different DBs. What I would do in your situation is to search for all
TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have
That is the case, I agree, then you should still be able to use both of you
sqlplus's, not that it really matters though.
Kev
-Original Message-
DeUrioste
Sent: Tuesday, May 29, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Dave,
It seems to me that you are having a problem
In Unix, one can create links to a master by $ ls -s some master
tnsnames.ora some other location/file.
(I know, I could, and probably should, use the TNS_ADMIN environmental
variable instead.)
There seems to be no equivalent of this in NT though. Creating a shortcut
doesn't seem to work.