If GLOBAL_NAME is set to TRUE, your db link name must be the same than your
DB global_name.
> ----------
> From: magesh[SMTP:magesh_at_garoo.ne.jp]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, October 09, 2000 08:10
> To: Multiple recipients of list ORACLE-L
> Subject: Query on database link
>
> Dear All
>
>
> I created a database link between 2 database . When i am try to access
> the table "emp" of scott scheme from the second database , getting
> an error like this ...
>
> sql> select * from emp_at_orcl.kaiji1;
>
> Error at line 1:
> ora-02085 :database links orcl.kaiji1 connects to orcl.world.
>
> Why itz trying to connect to "orcl.world" instead of "orcl.kaiji1", How
> to resolve this problem ?
>
> Details of 2 databases :-
>
> first database(Source) ------------------------------------Second
> database(destination)
> db_name : ora8------------------------------------------------orcl
> global_name:true----------------------------------------------true
> db_domain:none-----------------------------------------------kaiji1
>
> Listener.ora of ORCL
> ------------------------------
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= ORCL.kaiji1)
> (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
> (SID_NAME = ORCL)
> )
>
> tnsnames.ora of ORCL
> ------------------------------------
> ORCL.kaiji1 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= kaiji1)(Port= 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> tnsnames.ora of ora8
> -----------------------------------
> kaiji1=
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 210.227.71.51)(Port= 1521))
> (CONNECT_DATA = (SID = ORCL))
> )
>
> where 210.227.71.51 is Kaiji1 database
>
> svrmgrl >connect system/manager (connected to source database (ORA8) )
>
> sql > create public database link orcl.kaiji1 connect to scott identified
> by tiger using 'kaiji1';
>
> Itz created with out any error ....
>
>
> Please ..any one suggest me ..what was the error ??
>
>
> Thanx In Advance
Received on Mon Oct 09 2000 - 06:15:06 CDT
