Re: Why db_link gets its db_domain extension from global_name?

Have you looked at $ORACLE_HOME/network/admin/sqlnet.ora?

Regards,
jh

rabouk_at_mcimail.com (Reza Abouk) wrote:

>Hi,
> Here is the scenario:
>
>db_domain is default ==> WORLD
>
>SQL> select * from v$parameter where name = 'db_domain';
>
>NUM NAME TYPE VALUE ISDEFAULT
>--------- --------- --------- ------ ---------
> 147 db_domain 2 WORLD TRUE
>
>SQL> select * from global_name;
>
>GLOBAL_NAME
>--------------------------------------------------------------------------------
>PRODV2.RCH.MCI.COM
>
>global_name is ==> PRODV2.RCH.MCI.COM
>
>Where did the global_name got the db_domain extension???
>
>When I create a db_link the db_domain extension is
>attached to the db_link name; and apparently
>it is comming from global_name not from v$parameter
>
>SQL> create public database link test
> 2 connect to username identified by password
> 3 using 'connect string';
>
>Database link created.
>
>SQL> select db_link from dba_db_links where db_link like ('TEST%');
>
>DB_LINK
>--------------------------------------------------------------------------------
>TEST.RCH.MCI.COM
>
>SQL> drop public database link test;
>
>Database link dropped.
>
>SQL> update global_name set global_name ='PRODV2.WORLD';
>
>1 row updated.
>
>SQL> select * from global_name;
>
>GLOBAL_NAME
>--------------------------------------------------------------------------------
>PRODV2.WORLD
>
>SQL> create public database link test
> 2 connect to username identified by password
> 3 using 'connect string';
>
>Database link created.
>
>SQL> select db_link from dba_db_links where db_link like ('TEST%');
>
>DB_LINK
>--------------------------------------------------------------------------------
>TEST.WORLD
>
>1 row selected.
>
>SQL> drop public database link test;
>
>Database link dropped.
>
>
>Regards,
>
>Reza Abouk
>Reza.Abouk_at_MCI.com
>

Jared Hecker, CODBA       | Oracle  and Sybase Architect and DBA
jared_at_planet.net          | - consulting in the 
76276.740_at_compuserve.com  |   NYC/NJ region