Re: database link

Hi Michael
The global name of the remote database is oracle.world you are using global_names = true in your init.ora In this case the name of the database link MUST equal the name of the database.
If you set global_names to false (which in your case seems the way to go) Oracle doesn't check. Probably the global name of both your databases is oracle.world and then using global_names=true they will never connect until you change the global name of one of them.

Hth,

Sybrand Bakker, Oracle DBA

michael_georg_at_my-deja.com wrote in message <7itv06$ck8$1_at_nnrp1.deja.com>...
>I hope someone will help me to solve my problem:
>
>IŽd like to create a database link between two personal 8 databases on
>two different NT servers.
>
>I have registered them as test_1.world and test_2.world name_services in
>Net8 easy config.
>
>user scott created a database link as follow:
>
>create database link test_2.world connect to scott identified by tiger
>using 'test_2.world';
>Database link created.
>
>When scott tries to query table emp_at_test_2.world I always get following
>error message:
>
>ERROR:
>ORA-02085: database link TEST_2.WORLD connects to ORACLE.WORLD
>
>
>I know this problem has something to do with the default domain in
>global_name but I dont know what to do.
>
>Please give me some hints!
>
>Thank you, Michael
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon May 31 1999 - 12:09:15 CDT