OraFAQ Forum: Server Administration » Replication 10g release problem [Multi-Master Replication, Advance Replication]

Home » RDBMS Server » Server Administration » Replication 10g release problem [Multi-Master Replication, Advance Replication]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250047]

Sat, 07 July 2007 05:36

itroome
Messages: 34
Registered: June 2005
Location: DUBAI, UAE

Member

Hi,

Basically I want to setup Replication between two servers, 'ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM' [10.2.0.1.0][Source]
to
'ORCL.US.ORACLE.COM' [10.1.0.2.0][Destination]
(Advanced master-to-master replication, Sync), using Scripts.

When executing
REPADMIN :orcl >/
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE(
gname => '"GROUP1"', master => 'ORCL.US.ORACLE.COM');
END;

REPADMIN :orcl >/
BEGIN
*
ERROR at line 1:
ORA-23375: feature is incompatible with database version at ORCL.US.ORACLE.COM
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

let me make clear i had checked

REPADMIN :orcl >select name, value from v$parameter where name='compatible';

NAME VALUE
---------- ------------------
compatible 10.2.0.1.0

REPADMIN :center >select name, value from v$parameter where name='compatible';

NAME VALUE
---------- -------------------
compatible 10.1.0.2.0

Same on both Servers

REPADMIN :orcl >show parameter compatible

NAME TYPE VALUE
------------------------------------ -----------
compatible string 10.2.0.1.0

REPADMIN :center >show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- -----------
compatible string 10.1.0.2.0

REPADMIN :orcl >SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

REPADMIN :center >SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

5) grant privileges.

execute dbms_repcat_admin.grant_admin_any_schema( ’repadmin’); grant comment any table to repadmin;
grant lock any table to repadmin;

what other issue can be???

Kind Regards,
Thanks.

Muhammad Aurangzaib
DBA
itroome@yahoo.com
+923009737559

Attachment: Replication Problem.rtf
(Size: 3.23KB, Downloaded 1100 times)

Report message to a moderator

Re: Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250059 is a reply to message #250047]

Sat, 07 July 2007 09:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

try

Execute the following steps:

     SQL> connect system/manager@DESTINATION.WORLD
     SQL> execute dbms_repcat_admin.grant_any_repgroup('REPADMIN')

   or execute:

     SQL> execute dbms_repcat_admin.grant_admin_any_repschema ('REPADMIN')

HTH & YMMV

Report message to a moderator

Re: Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250095 is a reply to message #250059]

Sat, 07 July 2007 18:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

replication guide

Attachment: Oracle Replication Survival Guide.doc
(Size: 394.50KB, Downloaded 1526 times)

Report message to a moderator

Previous Topic:	fragmentation
Next Topic:	Best way to duplicate a database / schema ? NOT urgent, never was, never will be.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:55:46 CDT 2024