Advanced copy adds a main site to encounter an ORA-23375 error solution

zhaozj2021-02-12  144

Sometimes we encounter ORA-23375 errors when we do the following commands to add a main site.

SQL> EXECUTE DBMS_REPCAT.ADD_MASTER_DATABASE (...)

Error is located in Chapter 1: ORA-23375: Features and Database Version is not compatible ORA-06512: in "sys.dbms_sys_error", line 86ora-06512: in "sys.dbms_repcat_mas", line 2151ora-06512: in "SYS" .Dbms_repcat, Line 146AA-06512: In line 1

The above error typically, it is usually that we lack a few-step authorization when you create a repadmin user, and follow the steps to correctly create a RepAdmin user.

Create User Repadmin Identified by RepAdmin Default TableSpace Uses Temporary TableSpace Temp;

Execute dbms_defer_sys.register_propagator ('repadmin');

Grant Execute Any Procedure To Repadmin;

EXECUTE DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANAY_REPGROUP ('repadmin');

Execute dbms_repcat_admin.grant_admin_Andmin_schema (username => '"repadmin");

Grant Comment Any Table To Repadmin;

Grant Lock Any Table To Repadmin;

Grant Select Any Dictionary to repadmin;

Some other documents on the Internet are often missing below:

Grant Lock Any Table To Repadmin;

Grant Select Any Dictionary to repadmin;

转载请注明原文地址:https://www.9cbs.com/read-7649.html

New Post(0)