Why domain name appended to database link name?

From: Dino Hsu-®}¶}©ú <dino1.nospam_at_ms1.hinet.net>
Date: Sun, 30 Mar 2003 18:37:59 +0800
Message-ID: <b66hhq$6o1@netnews.hinet.net>

Dear all,

This seems a simple question, but I am sorry I cannot find the answer from document or news posts, yet. If you know where I can find it, please point me to, thanks a lot.

I want to create mutual database links for two related databases, say: db1: SID=orc1, host=svr, connect string=ecdb_orc1 db2: SID=orc2, host=svr, connect string=ecdb_orc2

These two databases are connected with SID instead of service_name, but I think this doesn't matter.

sqlplusw userid/passwd_at_ecdb_orc1

SQL> show parameter global_name

NAME                                 TYPE    VALUE


------------------------------------ ------- ------------------------------

global_names                         boolean FALSE

SQL> create database link ecdb_orc2 connect to userid identified by passwd using 'ecdb_orc2';

Database link created.

SQL> select object_name from user_objects where object_type='DATABASE LINK';

OBJECT_NAME

ECDB_ORC2 SQL> desc dict_at_ecdb_orc2

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------


----

 TABLE_NAME                                         VARCHAR2(30)
 COMMENTS                                           VARCHAR2(4000)

exit

sqlplusw userid/passwd_at_ecdb_orc2

SQL> show parameter global_name

NAME                                 TYPE    VALUE


------------------------------------ ------- ------------------------------

global_names                         boolean FALSE

SQL> create database link ecdb_orc1 connect to speed identified by speed using 'ecdb_orc1';

Database link created.

SQL> select object_name from user_objects where object_type='DATABASE LINK';

OBJECT_NAME

ECDB_ORC1.SVR.DOMAIN SQL> desc dict_at_ecdb_orc1
ERROR:
ORA-02019: connection description for remote database not found

SQL> desc dict_at_orc1
ERROR:
ORA-02019: connection description for remote database not found

SQL> desc dict_at_ecdb_orc1.svr.domain
ERROR:
ORA-02019: connection description for remote database not found

SQL> desc dict_at_orc1.svr.domain
ERROR:
ORA-02019: connection description for remote database not found

exit

I have used svr, domain, userid, passwd in place of the real names in the above example, but I think that doesn't matter, either. The wierd thing is in db2, where I created a database link called 'ecdb_orc1', but I got one called 'ecdb_orc1.svr.domain', and I cannot really use it.

Regards,
Dino Received on Sun Mar 30 2003 - 04:37:59 CST