OAM 11.1.2.2.0 upgrade to 11.1.2.3.0, running Patch Set Assistant Failed With UPGAST-00224 (Doc ID 2164737.1)

Last updated on MARCH 08, 2017

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.

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)
http://docs.oracle.com/cd/E52734_01/core/IAMUP/common_tasks.htm#IAMUP4123

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: 0000LO3ZRRhA_MJwAkYROx1NZZYu000002,0] 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: 0000LO3ZRRhA_MJwAkYROx1NZZYu000002,0] 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms