2522613 - DBUA fails with ORA-00942

• You are upgrading Oracle to 12.1 and DBUA is failing with error:

• When checking the invalid objects, you find invalid DIAG objects. For example:

Note: The same behaviour can be observed in other objects with name *$DIAG_*.

• When you try to compile the invalid objects manually, it fails but no errors are reported:

• The parameter _diag_adr_enabled is already set to TRUE:

• SAP Systems based on SAP NetWeaver
• Oracle Database

v_$diag_ADR_CONTROL, x$diag_ADR_CONTROL, v_$diag_ADR_INVALIDATION, x$diag_ADR_INVALIDATION, v_$diag_INCIDENT, x$diag_INCIDENT, v_$diag_PROBLEM, x$diag_PROBLEM, v_$diag_INCCKEY, x$diag_INCCKEY, v_$diag_INCIDENT_FILE, x$diag_INCIDENT_FILE, v_$diag_SWEEPERR, x$diag_SWEEPERR, v_$diag_PICKLEERR, x$diag_PICKLEERR, v_$diag_VIEW, x$diag_VIEW, v_$diag_VIEWCOL, x$diag_VIEWCOL, v_$diag_HM_RUN, x$diag_HM_RUN, v_$diag_HM_FINDING, x$diag_HM_FINDING, v_$diag_HM_RECOMMENDATION, x$diag_HM_RECOMMENDATION, v_$diag_HM_FDG_SET, x$diag_HM_FDG_SET, v_$diag_HM_INFO, x$diag_HM_INFO, v_$diag_HM_MESSAGE, x$diag_HM_MESSAGE, v_$diag_DDE_USER_ACTION_DEF, x$diag_DDE_USER_ACTION_DEF, v_$diag_DDE_USR_ACT_PARAM_DEF, x$diag_DDE_USR_ACT_PARAM_DEF, v_$diag_DDE_USER_ACTION, x$diag_DDE_USER_ACTION, v_$diag_DDE_USR_ACT_PARAM, x$diag_DDE_USR_ACT_PARAM, v_$diag_DDE_USR_INC_TYPE, x$diag_DDE_USR_INC_TYPE, v_$diag_DDE_USR_INC_ACT_MAP, x$diag_DDE_USR_INC_ACT_MAP, v_$diag_IPS_PACKAGE, x$diag_IPS_PACKAGE, v_$diag_IPS_PACKAGE_INCIDENT, x$diag_IPS_PACKAGE_INCIDENT, v_$diag_IPS_PACKAGE_FILE, x$diag_IPS_PACKAGE_FILE, v_$diag_IPS_FILE_METADATA, x$diag_IPS_FILE_METADATA, v_$diag_IPS_FILE_COPY_LOG, x$diag_IPS_FILE_COPY_LOG, v_$diag_IPS_PACKAGE_HISTORY, x$diag_IPS_PACKAGE_HISTORY, v_$diag_IPS_PKG_UNPACK_HIST, x$diag_IPS_PKG_UNPACK_HIST, v_$diag_IPS_REMOTE_PACKAGE, x$diag_IPS_REMOTE_PACKAGE, v_$diag_IPS_CONFIGURATION, x$diag_IPS_CONFIGURATION, v_$diag_IPS_PROGRESS_LOG, x$diag_IPS_PROGRESS_LOG, v_$diag_INC_METER_SUMMARY, x$diag_INC_METER_SUMMARY, v_$diag_INC_METER_INFO, x$diag_INC_METER_INFO, v_$diag_INC_METER_CONFIG, x$diag_INC_METER_CONFIG, v_$diag_INC_METER_IMPT_DEF, x$diag_INC_METER_IMPT_DEF, v_$diag_INC_METER_PK_IMPTS, x$diag_INC_METER_PK_IMPTS, v_$diag_EM_USER_ACTIVITY, x$diag_EM_USER_ACTIVITY, v_$diag_EM_DIAG_JOB, x$diag_EM_DIAG_JOB, v_$diag_EM_TARGET_INFO, x$diag_EM_TARGET_INFO, v_$diag_AMS_XACTION, x$diag_AMS_XACTION, v_$diag_DFW_CONFIG_CAPTURE, x$diag_DFW_CONFIG_CAPTURE, v_$diag_DFW_CONFIG_ITEM, x$diag_DFW_CONFIG_ITEM, v_$diag_DFW_PATCH_CAPTURE, x$diag_DFW_PATCH_CAPTURE, v_$diag_DFW_PATCH_ITEM, x$diag_DFW_PATCH_ITEM, v_$diag_VSHOWINCB, x$diag_VSHOWINCB, v_$diag_VSHOWINCB_I, x$diag_VSHOWINCB_I, v_$diag_V_INCFCOUNT, x$diag_V_INCFCOUNT, v_$diag_V_NFCINC, x$diag_V_NFCINC, v_$diag_VINCIDENT, x$diag_VINCIDENT, v_$diag_VINC_METER_INFO, x$diag_VINC_METER_INFO, v_$diag_VIPS_FILE_METADATA, x$diag_VIPS_FILE_METADATA, v_$diag_VIPS_PKG_FILE, x$diag_VIPS_PKG_FILE, v_$diag_VIPS_PACKAGE_FILE, x$diag_VIPS_PACKAGE_FILE, v_$diag_VIPS_PACKAGE_HISTORY, x$diag_VIPS_PACKAGE_HISTORY, v_$diag_VIPS_FILE_COPY_LOG, x$diag_VIPS_FILE_COPY_LOG, v_$diag_VIPS_PACKAGE_SIZE, x$diag_VIPS_PACKAGE_SIZE, v_$diag_VIPS_PKG_INC_DTL1, x$diag_VIPS_PKG_INC_DTL1, v_$diag_VIPS_PKG_INC_DTL, x$diag_VIPS_PKG_INC_DTL, v_$diag_VINCIDENT_FILE, x$diag_VINCIDENT_FILE, v_$diag_V_INCCOUNT, x$diag_V_INCCOUNT, v_$diag_V_IPSPRBCNT1, x$diag_V_IPSPRBCNT1, v_$diag_V_IPSPRBCNT, x$diag_V_IPSPRBCNT, v_$diag_VPROBLEM_LASTINC, x$diag_VPROBLEM_LASTINC, v_$diag_VPROBLEM_INT, x$diag_VPROBLEM_INT, v_$diag_VEM_USER_ACTLOG, x$diag_VEM_USER_ACTLOG, v_$diag_VEM_USER_ACTLOG1, x$diag_VEM_USER_ACTLOG1, v_$diag_VPROBLEM1, x$diag_VPROBLEM1, v_$diag_VPROBLEM2, x$diag_VPROBLEM2, v_$diag_V_INC_METER_INFO_PROB, x$diag_V_INC_METER_INFO_PROB, v_$diag_VPROBLEM, x$diag_VPROBLEM, v_$diag_VPROBLEM_BUCKET1, x$diag_VPROBLEM_BUCKET1, v_$diag_VPROBLEM_BUCKET, x$diag_VPROBLEM_BUCKET, v_$diag_VPROBLEM_BUCKET_COUNT, x$diag_VPROBLEM_BUCKET_COUNT, v_$diag_VHM_RUN, x$diag_VHM_RUN, v_$diag_DIAGV_INCIDENT, x$diag_DIAGV_INCIDENT, v_$diag_VIPS_PACKAGE_MAIN_INT, x$diag_VIPS_PACKAGE_MAIN_INT, v_$diag_VIPS_PKG_MAIN_PROBLEM, x$diag_VIPS_PKG_MAIN_PROBLEM, v_$diag_V_ACTINC, x$diag_V_ACTINC, v_$diag_V_ACTPROB, x$diag_V_ACTPROB, v_$diag_V_SWPERRCOUNT, x$diag_V_SWPERRCOUNT, v_$diag_VIPS_PKG_INC_CAND, x$diag_VIPS_PKG_INC_CAND, v_$diag_VNOT_EXIST_INCIDENT, x$diag_VNOT_EXIST_INCIDENT, v_$diag_VTEST_EXISTS, x$diag_VTEST_EXISTS , KBA , BC-DB-ORA , Oracle , Problem