Upgrade Assistant Readiness Check Fails With: "Failed to retrieve Oracle Audit data source" (Doc ID 2697675.1)

Last updated on JUNE 28, 2023

Applies to:

Symptoms

Oracle WebCenter Portal upgrade from 12.2.1.1 to 12.2.1.3.

Upgrade assistance readiness check fails with the below error message:

[<TIMESTAMP>] [IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: <TID>] Detected jdbc/AuditAppendDataSource as Oracle Audit datasource
[<TIMESTAMP>] [IAU] [WARNING] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: <TID>] Failed to retrieve Oracle Audit data source jdbc/AuditAppendDataSource from domain

or

ua -readiness -logLevel TRACE

=============================

[<TIMESTAMP>] [IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] EXCEPTION SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU
[<TIMESTAMP>] [IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid:<TID>] [ecid: <ECID>] INFO SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU_APPEND .This maybe caused by a known issue, anyway, this missing object privilege will be granted starting 12.2.1.0.0 upgrade. So this issue will be fixed in 12.2.1.0.0 and later releases.
[<TIMESTAMP>] [IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] INFO SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU_VIEWER .This maybe caused by a known issue, anyway, this missing object privilege will be granted starting 12.2.1.0.0 upgrade. So this issue will be fixed in 12.2.1.0.0 and later releases.[timestamp] [IAU] [NOTIFICATION] [] [upgrade.IAU.AUDIT_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] Completed schema test: PRIVILEGES_TEST --> Test that the audit schema has appropriate system and object privileges +++ FAIL
starting schema test: UPGRADE_SCRIPT_TEST Test that the middleware contains the required audit upgrade script
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
EXCEPTION SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU
INFO SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU_APPEND .
This maybe caused by a known issue, anyway, this missing object privilege will be granted starting 12.2.1.0.0 upgrade. So this issue will be fixed in 12.2.1.0.0 and later releases.
INFO SELECT object privilege with grantable NO for object SCHEMA_VERSION_REGISTRY is missing in Audit schema <PREFIX>_IAU_VIEWER .
This maybe caused by a known issue, anyway, this missing object privilege will be granted starting 12.2.1.0.0 upgrade. So this issue will be fixed in 12.2.1.0.0 and later releases.
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.

Changes

Cause

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