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性能调优” 博客,请务必保留此出处
,已抢187168个
抢已抢67534个
抢已抢353867个
抢已抢668703个
抢已抢124076个
抢已抢26406个
抢