My Oracle Support Banner

OBIEE 12c: 12.2.1.4 Upgrade Assistant(UA) Readiness Check Failed for IAU schema During Upgrade from 12.2.1.1.0 (Doc ID 2565901.1)

Last updated on JULY 29, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.0 version,

When trying to upgrade from 12.2.1.1.0 to 12.2.1.4.0, upgrade assistant (UA) Readiness Check failed and showing the below failures on the Privileges Test of IAU schema:

ERROR:
Oracle Audit Services
Starting readiness check of Oracle Audit Services.
VERSION Schema <schema prefix>_IAU is currently at version 12.2.1.0.0. Readiness checks will now be performed.
Completed schema test: UPGRADE_SCRIPT_TEST --> Test that the middleware contains the required audit upgrade script +++ PASS
Starting schema test: PRIVILEGES_TEST Test that the audit schema has appropriate system and object privileges
Completed schema test: PRIVILEGES_TEST --> Test that the audit schema has appropriate system and object privileges +++ FAIL
Starting schema test: SEQUENCE_TEST Test that the audit schema sequence and its properties are valid
Completed schema test: SEQUENCE_TEST --> Test that the audit schema sequence and its properties are valid +++ PASS
Starting schema test: SYNONYMS_TEST Test that the audit schema required synonyms are present
Completed schema test: SYNONYMS_TEST --> Test that the audit schema required synonyms are present +++ PASS
Finished readiness check of Oracle Audit Services with status: FAILURE.

 

Below are the exceptions observed for the same from the "ua.log":

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] Starting schema test: PRIVILEGES_TEST Test that the audit schema has appropriate system and object privileges

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on SERVICETABLE object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on COMPONENT_SCHEMA_INFO object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on WEBLOGIC_TIMERS object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on WLS_EVENTS object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on WLS_HVST object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on JOBINSTANCEDATA object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on EXECUTIONINSTANCEDATA object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on STEPEXECUTIONINSTANCEDATA object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on JOBSTATUS object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on STEPSTATUS object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on CHECKPOINTDATA object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEACSS_SCHEMA_VERSION object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEAPC object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEAPCM object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEAPRMP object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEARM object

[IAU] [NOTIFICATION][upgrade.IAU.AUDIT_SCHEMA_PLUGIN] EXCEPTION Audit schema <schema_prefix>_IAU has unexpected object privileges on BEASAML2_CACHE object

 

Changes

Upgrade from 12.2.1.1.0 to 12.2.1.4.0

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.