Database Link question

Hello

I have two servers (same Network, Unix, each runs ORACLE V7, SQLNet V2) and want to set up a DB-link.

Server one is called OBELIX

part of tnsnames.ors:

V734MTS=(description=         
           (address=


              (community=tcpcom)


              (protocol=tcp)


              (host=obelix)


              (port=1521)


           )
           (connect_data=


              (sid=V734MTS)


           )
        )

Server two is called IDEFIX

part of tnsnames.ors:

V716MTS=(description=

           (address=


              (community=tcpcom)


              (protocol=tcp)


              (host=idefix)


              (port=1521)


           )
           (connect_data=


              (sid=V716MTS)


           )
        )

Each DB is running properly. Ich can do sqlplus scott/tiger_at_v716mts from obelix or sqlplus scott/tiger_at_v734mts from idefix.

But .....

I tried more than two hours to make a db link, but it does not work.

Can anybody please give me the CREATE PUBLIC DATABASE LINK command ? Any help is
really welcome.

Regards
josef

josef.buergi_at_ascom.ch Received on Fri May 07 1999 - 08:29:15 CDT