RE: TNS_ADMIN on Windows again

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 28 Jun 2000 08:31:29 -0300
Message-Id: <10542.110632@fatcity.com>

Leng,

Why do you want to point to only one set of database instances at a = time?

When you connect you specify the instance anyway, why try to separate tnsnames.ora and sqlnet.ora?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Leng Kaing [SMTP:leng.kaing_at_hancorp.com.au]
	Sent:	Wednesday, June 28, 2000 1:54 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	NT: TNS_ADMIN on Windwos again

	Hello everyone,

	I'm sorry but I have to ask this question again. I realise that this
thread
	was raised a while back but I can't seem to get it going.

	So the question is, if I've got multiple versions of Oracle
installed on my
	Windows 95 and WinNT, how do I go about pointing to just the one
single set
	of TNSNAMES.ORA and SQL*NET.ORA? I've tried setting a string
variable
	(TNS_ADMIN and TNSADMIN) in various parts of the registry to no
avail.
	Places I've tried, starting from and including HKEY_LOCAL_MACHINE |
SOFTWARE
	| ORACLE:

	1. misc_reg_entries
	2. ORACLE_HOMES
	3. ALL_HOMES

	Second question is: will all other tools like ODBC, TOAD, etc pick
up this
	new variable? Or will they still look for them in=20
	%ORACLE_HOME%/network/admin? or %ORACLE_HOME%/net80/admin

	TIA,




	> Leng.

	> -----------------

	> Leng Kaing

	> Tel: +61-3-9843-8440

	> Email: leng.kaing_at_hancorp.com.au

	>=20

=09

---

	This email and any files transmitted with it are confidential and
	intended solely for the use of the individual or entity to whom they
	are addressed. If you have received this email in error please
notify
	the system manager.

	This footnote also confirms that this email message has been swept
by
	MIMEsweeper for the presence of computer viruses.

	www.mimesweeper.com

=09

---

	--=20
	Author: Leng Kaing
	  INET: leng.kaing_at_hancorp.com.au

	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

Received on Wed Jun 28 2000 - 06:31:29 CDT