Re: Why domain name appended to database link name?

Dino Hsu-®}¶}©ú wrote:
> 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
>
>

"DESC"@<DB_LINK> can be unreliable especially if inter-operating between dissimilar versions of Oracle.

A better test of the connectivity is to do SELECT COUNT(*) FROM USER_OBJECTS_at_OTHER_DB; Received on Sun Mar 30 2003 - 08:46:34 CST