Database Links

From: Milan Smederevac <smeky_at_gmx.net>
Date: 24 May 2001 04:23:25 -0700
Message-ID: <5a637cba.0105240323.b8ca33c@posting.google.com>

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 - 06:23:25 CDT