Re: Database Links

From: David Busby <dbusby3_at_slb.com>
Date: Thu, 24 May 2001 07:06:06 -0500
Message-ID: <3B0CF92E.A9791F87@slb.com>

Check your init.ora for the global_names = false and make sure this is not commented out. This may help you out and make sure that you create the link public, at least for the test.

Milan Smederevac wrote:

> I have been trying to connect via DataBase link, from one DB, I 'm
> going to call it A (local db), to anoter DB B (remote one).
> First thing to do was to create connection, I have added to
> tnsnames.ora next lines:
> test1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 172.16.100.201)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 172.16.100.201)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = TESTER)
> )
> )
> When I try to connect to TESTER db with sqlplus I was successful to
> connect to DB B ( like: connect useer/pwd_at_test1).
> But when I create DB link like:

>

> create public database link tester connect to usr identified by pwd
> using 'test1'; ( this goes through)
> I try to select * from user_tables_at_TESTER;
> I got this:
> ERROR at line 1:
> ORA-02085: database link TESTER.WORLD connects to TESTER

>

> When I create DB link with another name like tester.com oracle does
> not add 'world' but this is still not working (same error).
>
> Can anyone help me with this problem?
Received on Thu May 24 2001 - 07:06:06 CDT