A db_link question from O8 to O7

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:41 CST