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