My Oracle Support Banner

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

Last updated on AUGUST 11, 2020

Applies to:

Oracle WebCenter Portal - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

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

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


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