Re: Why domain name appended to database link name?

Check sqlnet.ora and tnsnames.ora used by the databases. Maybe the answer is there.
(When a database link is used, the database is the "client" and reads the sqlnet configuration to resolve the alias given in the database link).

Dino Hsu-徐開明 <dino1.nospam_at_ms1.hinet.net> schreef in berichtnieuws b66hhq$6o1_at_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

|

|