Re: Problem in Replication

Rama Shankar wrote:
> Hi,
> To grant privileges I have executed the following on dbsoumen
> dbms_repcat_admin.grant_admin_any_repschema ('REPADMIN');
>
> By querying v$parameter in both servers I got same value for compatible
> parameter which is
>
> compatible 10.1.0.2.0
>
> Advanced replication parameter is TRUE in both servers
>
> But when I tried :-
>
> begin
> dbms_repcat.add_master_database(
> gname => '"MYREPGRP"',
> master => 'DBSOUMEN.WORKGROUP',
> use_existing_objects => TRUE,
> copy_rows => FALSE,
> propagation_mode => 'ASYNCHRONOUS');
> end;
>
> i got the errors-
>
> ORA-23375: feature is incompatible with database version at
> DBSOUMEN.WORKGROUP
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
> ORA-06512: at "SYS.DBMS_REPCAT_MAS ", line 2159
> ORA-06512: at "SYS.DBMS_REPCAT", line 146
> ORA-06512: at line 2

• Did you grant the privs on both databases?
• Are both databases Enterprise versions?
• is global_names initSID.ora parameter .. true?
• Make sure the global_names of both databases do not contain a reserved word. i.e. in a global_name X.Y .. X and Y should not be reserved words.
• Did you create db links as specified in the manual? and made sure they work?
• Lastly: Did you try doing a 10046 trace. Google for it in case you don't know how to do this. And post the snippet of trace (and last sql call) where this error is thrown.

Anurag Received on Wed Jan 11 2006 - 10:01:48 CST