OAC-Classic: Patch Fails Due to Examine Failure Of The Oracle Audit Services schema (Doc ID 2403094.1)

Last updated on MAY 04, 2021

Applies to:

Symptoms

Patching an OAC service instance from 17.2.3 to 18.2.1 fails with:
        ERROR Error running patch process on Admin Node: Domain configuration upgrade steps failed.

The following is observed in the \bi\log\patch_analytics-patch-<timestamp>.log file:-

INFO Patching from version 17.2.3-787 to version 18.2.1-1473. Version at service creation was 17.2.3-787.
...
DEBUG Oracle Fusion Middleware Upgrade Assistant 12.2.1.3.0
...
DEBUG Oracle Audit Services schema examine is in progress
...
DEBUG Oracle Audit Services schema examine finished with status: failed
DEBUG UPGAST-00215: Upgrade is not being done due to examine failures.
DEBUG When using a response file, actual upgrades are not done if any plugin can not complete its EXAMINE phase.
DEBUG Correct the problem using information provided in the log file; then retry the operation.
DEBUG The command failed to complete successfully
INFO Result of running upgrade script: 255
ERROR Error running patch process on Admin Node: Domain configuration upgrade steps failed.

The following is observed in the \bi\data\logs\ua\ua<timestamp>.log file:-

[IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] ... Oracle Audit schema upgrade required
...
[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] ... [[
java.sql.SQLSyntaxErrorException: ORA-02002: error while writing to audit trail
ORA-55917: Table flush I/O failed for log ID: 2 bucket ID: 0
ORA-55917: Table flush I/O failed for log ID: 2 bucket ID: 0
ORA-01653: unable to extend table ORA-01653: unable to extend table AUDSYS.CLI_SWP$cc245e44$2$1 by 8192 in tablespace SYSAUX
. by in tablespace ...
Caused by: Error : 2002, Position : 0, Sql = REVOKE SELECT ANY DICTIONARY FROM DEVOAC1_IAU, OriginalSql = REVOKE SELECT ANY DICTIONARY FROM <Prefix>_IAU, Error Msg = ORA-02002: error while writing to audit trail
ORA-55917: Table flush I/O failed for log ID: 2 bucket ID: 0
ORA-55917: Table flush I/O failed for log ID: 2 bucket ID: 0
ORA-01653: unable to extend table ORA-01653: unable to extend table AUDSYS.CLI_SWP$cc245e44$2$1 by 8192 in tablespace SYSAUX
. by in tablespace ...]]
...
[IAU] [ERROR] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] ... Oracle Audit Services schema upgrade is invalid.
[Framework] [NOTIFICATION] [] [upgrade.Framework] ... Finished upgrading IAU.AUDIT_SCHEMA_PLUGIN with status: FAILURE.

Additionally, the following is observed in the \bi\data\logs\ua\ua<timestamp>.log file:-

[Framework] [NOTIFICATION] [] [upgrade.Framework] ... Finished examining BI-PLATFORMSCHEMA.SCHEMA with status: SUCCESS.
...
[Framework] [NOTIFICATION] [] [upgrade.Framework] ... Schema <Prefix>_BIPLATFORM will be upgraded from version 1.0.0.0.0 to 4.0.0.0.0
...
[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] ...java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges ...
Caused by: Error : 1031, Position : 21, Sql = GRANT EXECUTE ON SYS.DBMS_LOCK to <Prefix>_BIPLATFORM, OriginalSql = GRANT EXECUTE ON SYS.DBMS_LOCK to <Prefix>_BIPLATFORM, Error Msg = ORA-01031: insufficient privileges ... ]]
...
[BI-PLATFORMSCHEMA] [ERROR] [UPGCMP-06004] [upgrade.BI-PLATFORMSCHEMA.SCHEMA] ... The BIPLATFORM database schema updated is INVALID.
[BI-PLATFORMSCHEMA] [ERROR] [] [upgrade.BI-PLATFORMSCHEMA.SCHEMA] ... Cause: Specified BIPLATFORM database schema was updated but is invalid.
...
[Framework] [NOTIFICATION] [] [upgrade.Framework] ...Finished upgrading BI-PLATFORMSCHEMA.SCHEMA with status: FAILURE.

Note:
After resolving the "ORA-01653: unable to extend table" error, the patch continued to fail with the following observed in the \bi\data\logs\ua\ua<timestamp>.log file:-

[Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 1] [ecid: 2bc611e6-7f06-42e1-a8e7-8bad0d262ebe-00000002,0] Schema <Prefix>_IAU will be upgraded from version 12.2.1.0.0 to 12.2.1.2.0
...
[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] ... [[ java.sql.SQLSyntaxErrorException: ORA-01952: system privileges not granted to '<Prefix>_IAU'
...
Caused by: Error : 1952, Position : 0, Sql = REVOKE SELECT ANY DICTIONARY FROM <Prefix>_IAU, OriginalSql = REVOKE SELECT ANY DICTIONARY FROM <Prefix>_IAU, Error Msg = ORA-01952: system privileges not granted to '<Prefix>_IAU' ...
]]
...
[IAU] [ERROR] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: 28] [ecid: 2bc611e6-7f06-42e1-a8e7-8bad0d262ebe-00000002,0] Oracle Audit Services schema upgrade is invalid.
[Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 28] [ecid: 2bc611e6-7f06-42e1-a8e7-8bad0d262ebe-00000002,0] Finished upgrading IAU.AUDIT_SCHEMA_PLUGIN with status: FAILURE.

Cause

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