Applying PSU results ORA-22308: operation not allowed on evolved type

While applying Oracle PSU patches on 12cR1 database and checking the view dba_registry_sqlpatch the STATUS was “WITH ERRORS”.

 

In order to fix this you need to check the log file for patch (you can find the location for the log file  from dba_registry_sqlpatch OR using DBMS_QOPATCH package) , in my case the error was referring to database vault type:

 

create or replace type dvsys.ku$_dv_realm_member_t as object
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type

 

to fix this:

 

SQL> drop type dvsys.ku$_dv_realm_member_t validate;

 

Then,

 

cd $ORACLE_HOME/OPatch

 

./datapatch -verbose