配置進階複製報ORA-23375解決辦法

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效能調優” 部落格，請務必保留此出處http://5073392.blog.51cto.com/5063392/1337780