当前位置:Gxlcms > mysql > 配置高级复制报ORA-23375解决办法

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

时间:2021-07-01 10:21:17 帮助过:27人阅读

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性能调优” 博客,请务必保留此出处

人气教程排行