My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.