Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> A db_link question from O8 to O7

A db_link question from O8 to O7

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Mon, 26 Oct 1998 08:54:24 GMT
Message-ID: <363634c2.758680@news.twsc.pouchen.com.tw>


Hello,
I have a O8 and a O7 on NT,
I want to create a db_link between them. The db_link from O7 to O8 is successful. But I create a db_link 'TEST' from O8 to O7, and select * from dba_users_at_test,occurs an error: ORA-02085 : database link TEST.world connects to oracle.world.

I drop 'TEST' db_link,and want to create db_link named 'oracle', but still an error:
ORA-02082 : a loopback database link must have a connect qualifier.

I thought maybe because the 2 databases are both db_name = oracle, and ORACLE_SID = ORCL.
So I change O8's db_name and ORACLE_SID to PROD (I'm sure the change is successful,cause I can startup,shutdown and connect OK.  And show parameter db_name in svrmgr is PROD)

And then create the db_link again,But still the same error: select * from dba_users_at_test,occurs an error: ORA-02085 : database link TEST.world connects to oracle.world.

create database link oracle connect to system identified by manager using 'xxx'; ORA-02082 : a loopback database link must have a connect qualifier.

I really need to create the db_link,
Could anyone give me any advice?
I'll appreciate for your help very much. Thank you in advance.
Please Cc to: violin.hsiao_at_mail.pouchen.com.tw

Violin. Received on Mon Oct 26 1998 - 02:54:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US