Re: Why domain name appended to database link name?

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Mon, 31 Mar 2003 00:47:50 +0800
Message-ID: <b6772b$773@netnews.hinet.net>

Dear Anton,

I did check sqlnet.ora and found nothing, I knew the good-old-day-Oracle-8 problem of appending ".world" to the connect string. Furhturmore, the two db's resides on the same server, the sqlnet.ora is shared since there is only one Oracle home, what makes one db work while the other don't?

By the way, as I forgot to mention, the Oracle is 8.1.7 Enterprise on Windows 2000 Advanced Server.

Regards,
Dino

• Original Message ----- From: "Anton Buijs" <aammbuijs_at_xs4all.nl> Newsgroups: comp.databases.oracle.server Sent: Sunday, March 30, 2003 6:58 PM Subject: 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
> |
> |
>
Received on Sun Mar 30 2003 - 10:47:50 CST