Re: Database link creation problem

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/07/19
Message-ID: <8l57an$hfv$1@spiney.sierra.com>#1/1

TNSNAMES: Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = Production1)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = SID1)
    )
  )

"DDL" for link:

create database link sid1.world
connect to my_username identified by my_password using 'example1'
/

Note that the link name MUST BE sid.world (e.g., SID1.WORLD)
Using 'example1' is the (first part of) tnsnames entry

Usage:

select user_tables_at_SID1.world
/

"Kevin" <kcheung_at_poboxes.com> wrote in message news:3975c8cd$1_at_newsgate.hknet.com...
> I cannot create a database link for an instance that is in another unix box

> We're running 7.3.3 on AIX, no oracle names is used.
>
> unix box A: production instance - prd
> unix box B: 3 instances for various purposes
>
> I cannot only create db link for instances in box B to the production
> instance in box A. And the tnsnames.ora in box B already contains the
> service entry for the production instance.
>
> Does anyone know the reason?
>
>
>
>

Received on Wed Jul 19 2000 - 00:00:00 CDT