Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setup read-only replication
Yang, is correct, the global database names have to be unique, so change the
global database name on one of the databases, and redo the dblinks.
Jim
"Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message
news:72954535.0210171101.3ea86a13_at_posting.google.com...
> Hi all,
>
> I need to replicate to setup a read-only snapshot, with just one
> table. To do this, I have two databases with the same name, the same
> domain, and by default the same global_name parameter. To setup
> replication, I need to set global_names=true in init.ora, which
> implies that a public synonym must have the same name of the database
> it will connect to. Using Replication Manager, there´s a point in
> which it tries to create a public database link to access the remote
> site, and then I´m receiving the error :
>
> ORA-02082 a loopback database link must have a connection qualifier
>
> Well, this behaviour was expected because of this environment. I
> thought about two solutions to this :
>
> 1 - Rename database global name at one site
>
> 2 - Create the public database link using a connection qualifier (as
> it is in the Oracle Documentation).
>
> My question is : which of these are correct? Or both? Do I need to
> do anything else regarding database links or not? In the second
> solution, this connection qualifier can be anything, like '@xxx' or it
> must be configured somewhere? I´m using Oracle 8.1.7.
>
> Thanks in advanced,
> Carlos
Received on Mon Oct 21 2002 - 22:05:25 CDT