Message-Id: <10644.118783@fatcity.com> From: Chuck Hamilton Date: Mon, 9 Oct 2000 06:14:52 -0700 (PDT) Subject: Re: Query on database link --0-1927150952-971097292=:59999 Content-Type: text/plain; charset=us-ascii You must have global_names turned on. That requires the db link name to match the database name that you're connecting to. Either turn off global_names, or modify the link name and global name of the remote database to be the same. magesh wrote: 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@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 Bye Magesh --------------------------------- Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! --0-1927150952-971097292=:59999 Content-Type: text/html; charset=us-ascii


You must have global_names turned on. That requires the db link name to match the database name that you're connecting to. Either turn off global_names, or modify the link name and global name of the remote database to be the same.

  magesh <magesh@garoo.ne.jp> wrote:





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@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

 

Bye

Magesh

 

 

 

 

 

 

 

 


Do You Yahoo!?