Home » RDBMS Server » Server Administration » Replication 10g release problem [Multi-Master Replication, Advance Replication]
Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250047] Sat, 07 July 2007 05:36 Go to next message
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
Re: Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250059 is a reply to message #250047] Sat, 07 July 2007 09:10 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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
Re: Replication 10g release problem [Multi-Master Replication, Advance Replication] [message #250095 is a reply to message #250059] Sat, 07 July 2007 18:50 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
replication guide
Previous Topic: fragmentation
Next Topic: Best way to duplicate a database / schema ? NOT urgent, never was, never will be.
Goto Forum:
  


Current Time: Mon Dec 05 10:47:18 CST 2016

Total time taken to generate the page: 0.11233 seconds