My Oracle Support Banner

Oracle Access Manager 11g R2PS2 (OAM 11.1.2.2) Upgrade to (OAM 11.1.2.3), Running Patch Set Assistant Failed With UPGAST-00224 (Doc ID 2164737.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Access Manager - Version 11.1.2.2.0 to 11.1.2.3.0 [Release 11g]
Information in this document applies to any platform.
Oracle is not responsible for instructions/information from 3rd party sites that may be contained in this KM note.

Symptoms

Trying to upgrade OAM from 11.1.2.2.0 to 11.1.2.3.0 following

23.1.6 Updating Oracle Identity and Access Management Binaries to 11g Release 2 (11.1.2.3.0)

Run Oracle Fusion Middleware Patch Set Assistant, at Steps 4 of 10

IAU Schema
Specify the database containing the IAU Schema that you want to upgrade and enter the Database Administrator account name and password for the Database Administrator account name and password for that database. Then click connect, and choose the schema to be upgraded. 

After connect to database successfully, select the Schema "IAU schema" provide schema password and click Next  

Received error 'UPGAST-00224: The specified database does not contain any schemas for Oracle Audit Services or the database user lacks privilege to view the schemas."

Psa.log
--------
[2016-07-19T09:54:11.149-05:00] [Framework] [ERROR] [UPGAST-00224] [upgrade.Framework] [tid: 14] [ecid: <ECID>] The specified database does not contain any schemas for Oracle Audit Services or the database user lacks privilege to view the schemas.
[2016-07-19T09:54:11.149-05:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 14] [ecid: <ECID>] 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.

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
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.