RCU Fails with ORA-28104, ORA-06512 Errors when 12.2.x Database is Used

APPLIES TO:

Oracle Fusion Middleware – Version 12.2.1.0.0 and later
Information in this document applies to any platform.

ERROR:

Running RCU fails with ORA-28104, ORA-06512 Errors when 12.2.x database is used and below errors found in rcu.log file :

2017-10-23 16:04:27.671 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-28104: input value for statement_types is not valid
ORA-06512: at “SYS.DBMS_RLS_INT”, line 23
ORA-06512: at “SYS.DBMS_RLS”, line 54
ORA-06512: at line 115
File:<dir>/rcu/rcuHome/rcu/integration/mds/sql/cremdsvpd.sql
Statement:DECLARE

GUI ERROR:

CAUSE:

As part of a security fix beginning with Oracle Database 12.2, for the DBMS_RLS.ADD_POLICY procedure, statement types of INSERT and UPDATE_CHECK with a value of FALSE (the default value) are no longer allowed. The security fix results in an ORA-28104 error while registering Virtual Private Database policies.

This error is returned to avoid giving the impression that Virtual Private Database policies are enforced for INSERT statements, which is not the case.

SOLUTION

1) Configure the system with "_allow_inserts_with_UPDATE_CHECK" set to True, by executing the following SQL command:

SQL> ALTER SYSTEM SET "_allow_insert_with_update_check"=TRUE scope=spfile;

2) Restart Database
3) Re-run RCU

Kishore Kumar Ravichandran