Re: Updatable snapshots: HELP!

Did you setup the master site properly, i.e. create master group, create SYS surrogate user (e.g. REPSYS) and
create private DB links for this surrogate user (from snapshot site to master)? If YES is your master site running normally (i.e. not quiesched) and master group valid.

And did you setup your global replication administrator (e.g. REPADMIN), also having private DB links?

Your error message sounds like the master group is missing or priviliges/paths to access master objects are missing... BTW: Replication error messages often gives very bad hint to where the actual reason for the error lies.

Hope you get on with it!

Regards
Lars Bo

Gerco Schot wrote in message <363D9A8C.5A200485_at_lucent.com>...
>Hi all,
>
>I am working on a project that requires an updatable snapshot mechanism.
>I already received some documentation from Oracle, but did not succeed
>in setting things up.
>
>This is my situation:
>
>I have 2 machines (SCO Unixware 2.1.2) running Oracle 7.3.2.3.0 server.
>I have the distributed and replicated options installed. I ran the
>installation of catrep.sql and catrepad.sql. I have created db links
>between the 2 machines and verified them.
>
>All goes fine until I call the dbms_repcat.create_snapshot_repgroup at
>the snapshot site. There, I get the error:
>
>*
>ERROR at line 1:
>ORA-23313: object group GROUP1 is not mastered at REP1.WORLD
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92
>ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 541
>ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 178
>ORA-06512: at "SYS.DBMS_REPCAT", line 424
>ORA-06512: at line 1
>
>However, as I said, db links are working and I created the GROUP1
>repgroup at the master site.
>
>What can be wrong here? What options do I need to install? What settings
>in init.ora am I missing?
>
>Thank y'all in advance...
>
>Regards,
>Gerco Schot
>Gerco_at_lucent.com
Received on Mon Nov 02 1998 - 07:21:18 CST