My Oracle Support Banner

Error "UPGAST-00224" Occurs While Upgrading From OBIEE 12c To OAS 6.4 (Doc ID 2949023.1)

Last updated on MAY 20, 2023

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.


While upgrading Oracle Business Intelligence Enterprise Edition(OBIEE) 12c to Oracle Analytics Server(OAS) 6.4, the readiness check fails with the error below:

UPGAST-00224: The specified database does not contain any schemas for Oracle Audit Services or the database user lacks privilege to view the schemas.
Cause: The database you have specified does not contain any schemas registered as belonging to the component you are upgrading, or else the current database user lacks privilege to query the contents of the schema version registry.
Action: Verify that the database contains schema entries in schema version registry. If it does not, specify a different database. Verify that the user has DBA privilege. Connect to the database as DBA.

In Upgrade Assistant(UA), the components list is missing the IAU Schema name which is present in RCU database.


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

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