Oracle October 2015 Critical Patch Update issues

After applying the October 2015 Critical Patchset Update to our databases (12.1.0.2 on IBM AIX) , we discovered a number of invalid objects within the XDB and GSMADMIN_INTERNAL schemas:


select owner, object_name, status, object_type from dba_objects where status = 'INVALID' order by 1;

OWNER                OBJECT_NAME                    STATUS  OBJECT_TYPE
-------------------- ------------------------------ ------- -----------------------
GSMADMIN_INTERNAL    DBMS_GSM_DBADMIN               INVALID PACKAGE BODY
GSMADMIN_INTERNAL    DBMS_GSM_CLOUDADMIN            INVALID PACKAGE BODY
XDB                  DBMS_XSLPROCESSOR              INVALID PACKAGE BODY
XDB                  DBMS_XMLPARSER                 INVALID PACKAGE BODY
XDB                  DBMS_XDB_ADMIN                 INVALID PACKAGE BODY
XDB                  DBMS_CLOBUTIL                  INVALID PACKAGE
XDB                  DBMS_CLOBUTIL                  INVALID PACKAGE BODY

The issue can be resolved by granting the missing permissions needed for successful compilation listed below:


grant execute on DBMS_SQL to xdb;
grant execute on DBMS_LOB to xdb;
grant execute on UTL_FILE to xdb;
grant execute on utl_inaddr to GSMADMIN_INTERNAL;

Finally, recompile the invalid objects by using the $ORACLE_HOME/rdbms/admin/utlrp.sql script included in your installation.

Thanks! You've already liked this