ORA-23375: feature is incompatible with database version [message #210528] |
Thu, 21 December 2006 03:50 |
gsgill76
Messages: 12 Registered: November 2006
|
Junior Member |
|
|
Hi, Basically I want to setup Replication between two servers, 'ZEN2K7' & 'GVO' (Advanced master-to-master replication, Sync), using EM JAVA Console.
When executing
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE(
gname => '"MG_HA14"',
master => 'DL_HA14_TO_ZEN2K7',
use_existing_objects => TRUE,
copy_rows => TRUE,
propagation_mode => 'SYNCHRONOUS');
END;
throws error as:
BEGIN
*
ERROR at line 1:
ORA-23375: feature is incompatible with database version at DL_HA14_TO_ZEN2K7
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
select name, value from v$parameter where name='compatible'
show parameter compatible
on both of the server returns:
10.1.0.2.0
what other issue can be???
Kind Regards,
Thanks.
Gurpreet S. Gill.
|
|
|
|
Re: ORA-23375: feature is incompatible with database version [message #210888 is a reply to message #210566] |
Fri, 22 December 2006 23:49 |
gsgill76
Messages: 12 Registered: November 2006
|
Junior Member |
|
|
Quote: |
1) Make sure both the databases involved are in same VERSION.
login individually and query v$version.
|
I try "SELECT * FROM v$version" returns same on both servers
as
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
Quote: |
2) Make sure both the parties are the same edition (Enterprise edition)
|
YES its same on both servers( from the above banner, its clear)
Quote: |
3. And i believe you need to grant previlliges before adding the master site. Did you do that?
|
In the SYSTEM user i issue the command as (on the both servers)
execute dbms_repcat_admin.grant_admin_any_repgroup ('REPADMIN');
execute dbms_repcat_admin.grant_admin_any_repschema ('REPADMIN');
but same problem
Any other thing need to check?
OR
Any other grant, permission or privileges?
Kind Regards,
Thanks.
Gurpreet S. Gill
|
|
|
|
|
|
|
|