配置高级复制报ORA-23375解决办法

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

在配置高级复制出现了上述错误，是因为我的global_names 参数没有改为true

-- 解决思路

1）确认同步账号权限是否正确

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）确认db_link 是否为同步账号的对象

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）确认global_names 参数是否设置为true

SQL> show parameter global_names;

NAME TYPE VALUE

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

global_names boolean TRUE

本文出自 “专注于Oracle性能调优” 博客，请务必保留此出处