ORA-23375: feature is incompatible with database version

From: bob <bshahali_at_bevertec.com>
Date: 24 Nov 2005 14:05:56 -0800
Message-ID: <1132869956.081785.47530@g49g2000cwa.googlegroups.com>

Hello everyone,
I have this problem when I am trying to run my replication scripts to replicate data between 2 machines. I delete and recreated my instances and run the scripts from the beginning.

I have no idea how to fix this problem.
please let me know what to do.
here are my scripts:

scripts number one:
"rep1.sql" 77 lines, 2782 characters
rem

rem Filename: Rep1.sql
rem Purpose: Setup users, DB Links and schedules for Oracle Advanced

rem             replication. Run this script on all replication sites.
rem             In this example replication is between sites
yak.bevertec.com  and beaver.bevertec.com
rem Date:       12-May-2005

rem

set pages 50000
spool replication

drop user repadmin cascade;

connect repadmin/repadmin

@?/rdbms/admin/catrep.sql

REM Check if INIT.ORA parameters are OK for replication select name, value from sys.v_$parameter where name in ('job_queue_processes', 'job_queue_interval',
'global_name');

REM Assign global name to the DB name + domain alter database rename global_name to ESPDB.YAK.BEVERTEC.COM;

REM Check if DB_NAME, DB_DOMAIN & GLOBAL_NAME parameters are OK for replication
select name , value from v$parameter where name = 'db_name'; select name , value from v$parameter where name = 'db_domain'; select * from global_name;

REM Create public db link to the other master databses -- Bobby's change
drop public database link TESTDB.BEAVER.BEVERTEC.COM;

create public database link TESTDB.BEAVER.BEVERTEC.COM using
'TESTDB.BEAVER.BEVERTEC.COM';
REM Create replication administrator / propagator / receiver create user repadmin identified by repadmin default tablespace ESP_DATA
temporary tablespace ESP_TEMP
quota unlimited on ESP_DATA;

REM Grant privs to the propagator, to propagate changes to remote sites execute dbms_defer_sys.register_propagator(username=>'REPADMIN');

REM Grant privs to the receiver to apply deferred transactions grant execute any procedure to repadmin;

REM Authorise the administrator to administer replication groups execute dbms_repcat_admin.grant_admin_any_repgroup('REPADMIN');

REM Authorise the administrator to lock and comment tables grant lock any table to repadmin;
grant comment any table to repadmin;

connect repadmin/repadmin

REM Create private db links for repadmin create database link TESTDB.BEAVER.BEVERTEC.COM connect to repadmin identified by repadmin;

REM Schedule job to push transactions to master sites

execute dbms_defer_sys.schedule_push(        -
destination   => 'TESTDB.BEAVER.BERVERTEC.COM',        -
interval      => 'sysdate+1/24/60',  -
next_date     => sysdate+1/24/60,    -
stop_on_error => FALSE,              -
delay_seconds => 0,                  -

parallelism => 1);

REM Schedule job to delete successfully replciated transactions

execute dbms_defer_sys.schedule_purge(       -
next_date     => sysdate+1/24,       -
interval      => 'sysdate+1/24');

REM Test database link
select global_name from global_name_at_testdb.beaver.bevertec.com;

script number 2

"rep1.sql" 77 lines, 2782 characters
rem

rem Filename: Rep1.sql
rem Purpose: Setup users, DB Links and schedules for Oracle Advanced

rem             replication. Run this script on all replication sites.
rem             In this example replication is between sites
yak.bevertec.com  and beaver.bevertec.com
rem Date:       12-May-2005

rem

set pages 50000
spool replication

drop user repadmin cascade;

connect repadmin/repadmin

@?/rdbms/admin/catrep.sql

REM Check if INIT.ORA parameters are OK for replication select name, value from sys.v_$parameter where name in ('job_queue_processes', 'job_queue_interval',
'global_name');

REM Assign global name to the DB name + domain alter database rename global_name to ESPDB.YAK.BEVERTEC.COM;

REM Create public db link to the other master databses -- Bobby's change
drop public database link TESTDB.BEAVER.BEVERTEC.COM;

REM Grant privs to the propagator, to propagate changes to remote sites execute dbms_defer_sys.register_propagator(username=>'REPADMIN');

REM Grant privs to the receiver to apply deferred transactions grant execute any procedure to repadmin;

REM Authorise the administrator to administer replication groups execute dbms_repcat_admin.grant_admin_any_repgroup('REPADMIN');

REM Authorise the administrator to lock and comment tables grant lock any table to repadmin;
grant comment any table to repadmin;

connect repadmin/repadmin

REM Create private db links for repadmin create database link TESTDB.BEAVER.BEVERTEC.COM connect to repadmin identified by repadmin;

REM Schedule job to push transactions to master sites

execute dbms_defer_sys.schedule_push(        -
destination   => 'TESTDB.BEAVER.BERVERTEC.COM',        -
interval      => 'sysdate+1/24/60',  -
next_date     => sysdate+1/24/60,    -
stop_on_error => FALSE,              -
delay_seconds => 0,                  -

parallelism => 1);

REM Schedule job to delete successfully replciated transactions

execute dbms_defer_sys.schedule_purge(       -
next_date     => sysdate+1/24,       -
interval      => 'sysdate+1/24');

REM Test database link
select global_name from global_name_at_testdb.beaver.bevertec.com;

thanks again for your time
regards
bobby Received on Thu Nov 24 2005 - 16:05:56 CST