Re: A db_link question from O8 to O7

I found this one after upgrading my 7.3 to 8. You need to set the GLOBAL_NAMES parameter in the init file to FALSE, otherwise it enforces dblinks with the same names as the SIDs.

Violin wrote:

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

--
Jonathan Keller
jhkeller_at_ucdavis.edu
Web Developer - DaFIS Decision Support Received on Tue Oct 27 1998 - 12:43:40 CST