Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP.NEED_to_now how Orlcle looks for TNSNAMES>ORA

Re: HELP.NEED_to_now how Orlcle looks for TNSNAMES>ORA

From: Vincent Ventrone <vav_at_mitre.org>
Date: Thu, 23 Dec 1999 09:48:29 -0500
Message-ID: <3862363D.B478B1F9@mitre.org>

Derek BOlf wrote:
>
> Hi if you could help me I would apprecieate it I am looking for the key
> or setting somewhere that will change the path of the tnsnames.ora so
> I can access a diffrent db. If you could email me dbolf_at_magardi.com it
> would be of major help, The reason I need to do it that way is because I
> have to dba instaces withthe same sqlnet name and I can't change it.
> derek

You don't need a separate tnsnames.ora to access a different database -- just add another TNS alias or service name into the same file. However if you do need to use a diff. file both UNIX & NT will use the pathname in environment variable TNS_ADMIN to override looking in the default locations.
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730
Received on Thu Dec 23 1999 - 08:48:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US