dblink create error

[jennifer2007]

Hi Friends,

I run a script creating a database link which was an output of the replication
deployment template, meaning the OEM utils created the script itself. But
I got the following error:
=========================================================
SQL> CREATE PUBLIC DATABASE LINK "ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM" USING '(DESCRIPTION=(ADDRESS
=(PROTOCOL=TCP)(HOST=172.15.0.14)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))'
2 ;
CREATE PUBLIC DATABASE LINK "ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM" USING '(DESCRIPTION=(ADDRESS=(PRO
*
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier
=========================================================

The '*' here is pointing to the word "USING". What qualifier could it possibly
looking for? What do u mean by loopback dblink?

Thanks a lot

[PAVB]

ddzpy031/ddzpy031-3 [3]: oerr ORA 2082
02082, 00000, "a loopback database link must have a connection qualifier"
// *Cause: attempt to create a database link with the same name as the
// current database.
// *Action: a loopback database link needs a trailing qualifier, e.g.
// MYDB.DEV.US.ORACLE.COM@INST1 - the '@INST1' is the qualifier
//

[jennifer2007]

thanks dear

[PAVB]

Glad to help.

By the way, very bad practice to fully qualify target instance in DBLink statement, you might want to point to a TNSNAMES entry.

[jennifer2007]

Thanks honey,

I am setting-up/configuring a materialized view replication using OEM.
I'm not the one creating the scripts but OEM, and I intend
to run it at the materialized view site (172.16.1.21) while the master site
is (172.15.0.14) , I dont understand while the OEM is running it at the master
site hence, this error.

By the way, my two replication database have the same db name "ORCL" :(
Could this be the cause of the error? I dont thinks so bacause they reside
on SEPARATE servers of course.

How do I rename my other database to "ORCL2"