Oracle Access Manager (OAM) Upgrade Fails on Patch Set Assistant (PSA) for Audit User (Doc ID 2189757.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.
Oracle Access Manager 11gr2ps3 (OAM 11.1.2.3.0)

Symptoms

Upgrading Identity Access Management (IAM) stack from 11.1.2.1.9 to 11.1.2.3.

New Oracle Access Management Social and Mobile (OMSM) schema has been created and now running the PSA to upgrade the existing schema's.
After the OAM schema is selected (which then selects a few others), it fails when upgrading the IAU schema.

It seems that the IAU schema is already upgraded, the tables and columns that it is trying to create already exist. However PSA does not simply write it off as "already upgraded" but failed.

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