Re: Database link creation problem

Your USING clause seems to reference something other than an entry in your TNSNAMES.ORA file.( That is, the tnsnames.ora file on the SERVER - that is what a db link uses...)..

I don't understand the D: reference at all...

"Kevin" <kcheung_at_poboxes.com> wrote:

>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