Your problem is that the global database name of the database to which you connect has to be the same as your database link. It means that you should drop your database link and create a new one with the name of:
orcl.world
good luck
Mahmoud Reza Zare
- "magesh" <magesh_at_garoo.ne.jp>
> wrote:
>
>
>
><DIV><FONT face=Arial size=2>Dear All</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2> 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</FONT></DIV>
><DIV><FONT face=Arial size=2>an error like this ...</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>sql> select * from <A
>href="mailto:emp_at_orcl.kaiji1">emp_at_orcl.kaiji1</A>;</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Error at line 1:</FONT></DIV>
><DIV><FONT face=Arial size=2> ora-02085 :database links orcl.kaiji1
>connects to orcl.world.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Why itz trying to connect to "orcl.world" instead
>of "orcl.kaiji1", How to resolve this problem ?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Details of 2 databases :-</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>first
>database(Source) ------------------------------------Second
>database(destination)</FONT></DIV>
><DIV><FONT face=Arial size=2>db_name :
>ora8------------------------------------------------orcl</FONT></DIV>
><DIV><FONT face=Arial
>size=2>global_name:true----------------------------------------------true</FONT></DIV>
><DIV><FONT face=Arial
>size=2>db_domain:none-----------------------------------------------kaiji1</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Listener.ora of ORCL</FONT></DIV>
><DIV><FONT face=Arial size=2>------------------------------</FONT></DIV>
><DIV><FONT face=Arial size=2>SID_LIST_LISTENER =<BR> (SID_LIST
>=<BR> (SID_DESC =<BR>
>(GLOBAL_DBNAME= ORCL.kaiji1)<BR> (ORACLE_HOME=
>/u01/app/oracle/product/8.0.5)<BR> (SID_NAME =
>ORCL)<BR> ) </FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>tnsnames.ora of ORCL</FONT></DIV>
><DIV><FONT face=Arial size=2>------------------------------------</FONT></DIV>
><DIV><FONT face=Arial size=2>ORCL.kaiji1 =<BR> (DESCRIPTION
>=<BR> (ADDRESS = (PROTOCOL= TCP)(Host= kaiji1)(Port=
>1521))<BR> (CONNECT_DATA = (SID = ORCL))<BR>
>) </FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>tnsnames.ora of ora8 </FONT></DIV>
><DIV><FONT face=Arial size=2>-----------------------------------</FONT></DIV>
><DIV><FONT face=Arial size=2>kaiji1=<BR> (DESCRIPTION
>=<BR> (ADDRESS = (PROTOCOL= TCP)(Host= 210.227.71.51)(Port=
>1521))<BR> (CONNECT_DATA = (SID = ORCL))<BR>
>) </FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>where 210.227.71.51 is Kaiji1 database</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>svrmgrl >connect system/manager (connected to
>source database (ORA8) )</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>sql > create public database link orcl.kaiji1
>connect to scott identified by tiger using 'kaiji1';</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Itz created with out any error ....</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Please ..any one suggest me ..what was the
>error ??</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Thanx In Advance </FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Bye</FONT></DIV>
><DIV><FONT face=Arial size=2>Magesh</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV>
Be someone_at_0racledba.com - get your free mail from Oriole Corporation
http://www.oriolecorp.com - Performance tools for Oracle DBAs
Received on Tue Oct 10 2000 - 09:53:43 CDT