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

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: Mon, 20 Dec 1999 14:36:48 +0100
Message-ID: <83lboe$np7$1@fu-berlin.de>

Derek BOlf <Dbolf_at_magardi.com> schrieb:
> 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.

We have Oracle 7.3.4 on NT.

The easiest way is to use SQL*Easy Net Configuration.

If it is not possible, edit your \orant\network\admin\tnsnames.ora in the following way:

*ALIAS*.world =
 (DESCRIPTION =
  (ADDRESS_LIST =

    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = *TCP/IP-Adress*)
    (Port = 1521)

   )

   (ADDRESS =
   (COMMUNITY = tcp.world)
   (PROTOCOL = TCP)
   (Host = *TCP/IP-Adress*)
   (Port = 1526)

  )
 )
 (CONNECT_DATA = (SID = *Instance-Name*)  )
)

You have to change just the words inbetween the *. And you have to chose two different alias-names, the SID could be the same.

HTH, Kathinka Received on Mon Dec 20 1999 - 07:36:48 CST