Re: Database Link

From: Greg Vitetzaks <gvitetz_at_cam.org>
Date: 1998/03/13
Message-ID: <01bc3019$6986f860$0b2c54c7@parallax>#1/1

It seems there's a bug when creating a Database link with NT when using NapePipes as your
protocol. (regardless if both databases are on the same server or if its two seperate machines)

make sure you have the TCP protocol defined in you tnsnames and listener and use that
as your protocol.

Hope this helps

Greg Vitetzakis
DBA rljustice_at_techsoft.com wrote in article
<6e9ija$vt8$1_at_nnrp1.dejanews.com>...
> I am tring to create a database link between
two instances on the same NT
> machine.

The Database Link is Created, but
I get an ORA error
(ORA-02085).
>

Thanks in advance for any help..

SQL> create database link TESTLINK
2
> using 'KOITEST'

3 /

Database link created.

SQL> select * from
> user_tables_at_testlink;

select * from user_tables_at_testlink
*
ERROR at
line 1:
> ORA-02085: database link TESTLINK.WORLD connects to ORACLE.WORLD
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Fri Mar 13 1998 - 00:00:00 CST