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
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;