Configure Advanced Replication reports ORA-23375 Solution

SQLexecutedbms_repcat.add_master_database (gnamerep, masterTEST, use_existing_objectstrue, copy_rowsfalse, propagation_modesynchronous); BEGINdbms_repc

SQLexecutedbms_repcat.add_master_database (gname = rep, master = TEST, use_existing_objects = true, copy_rows = false, propagation_mode = synchronous); BEGINdbms_repc

SQL> execute dbms_repcat.add_master_database (gname => 'rep ', master => 'test', use_existing_objects => true, copy_rows => false, propagation_mode => 'synchronous ');

BEGIN dbms_repcat.add_master_database (gname => 'rep ', master => 'test', use_existing_objects => true, copy_rows => false, propagation_mode => 'synchronous'); END;

*

ERROR at line 1:

ORA-23375: feature is incompatible with database version at TEST

ORA-06512: at "SYS. DBMS_SYS_ERROR", line 86

ORA-06512: at "SYS. DBMS_REPCAT_MAS", line 2161

ORA-06512: at "SYS. DBMS_REPCAT", line 146

ORA-06512: at line 1

The above error occurs during Advanced Replication configuration because my global_names parameter is not changed to true.

-- Solution

1) Confirm that the synchronization account has the correct permissions

Create user repadmin identified by repadmin default tablespace users temporary tablespace temp;

Execute dbms_defer_sys.register_propagator ('repadmin ');

Grant execute any procedure to repadmin;

Execute dbms_repcat_admin.grant_admin_any_repgroup ('repadmin ');

Execute dbms_repcat_admin.grant_admin_any_schema (username => '"REPADMIN "');

Grant comment any table to repadmin;

Grant lock any table to repadmin;

Grant select any dictionary to repadmin;

2) Check whether db_link is the object of the synchronization account.

SQL> select object_name, object_type from user_objects where object_type = 'database link ';

OBJECT_NAME OBJECT_TYPE

----------------------------------

PREMIUMI DATABASE LINK

SQL> show user;

USER is "REPADMIN"

3) check whether the global_names parameter is set to true.

SQL> show parameter global_names;

NAME TYPE VALUE

-----------------------------------------------------------------------------

Global_names boolean TRUE

This article is from the "Focus on Oracle performance tuning" blog. Please keep this source

,