Re: Database link creation problem

From: Kevin <kcheung_at_poboxes.com>
Date: 2000/07/24
Message-ID: <8lhkeb$i9$1@du04.oli.hk>#1/1

Here's the error I encountered:

SQL> create public database link trn.world connect to apps identified by apps using 'D:trn';

Database link created.

SQL> select * from v$session_at_trn.world;
select * from v$session_at_trn.world

                        *

ERROR at line 1:
ORA-06401: NETCMN: invalid driver designator

Regards,
Kevin

"Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote in message news:8l57an$hfv$1_at_spiney.sierra.com...
> 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'
> /
>
> 1. Note that the link name MUST BE sid.world (e.g., SID1.WORLD)
> 2. 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 Mon Jul 24 2000 - 00:00:00 CDT