Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP.NEED_to_now how Orlcle looks for TNSNAMES>ORA
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 01730Received on Thu Dec 23 1999 - 08:48:29 CST
![]() |
![]() |