OIM Upgrade Assistant Failed With Error -UNEXPEXTED TABLESPACE" privilege while running upgrade assistance (Doc ID 2793895.1)

Last updated on DECEMBER 22, 2023

Applies to:

Symptoms

Following the  doc https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/iamup/upgrading-oracle-identity-manager-single-node-environments-one-hop.html#GUID-85BB1FFE-598C-4859-A80E-711DC434583B

upgrade Oracle Identity Manager from 11g Release 2 (11.1.2.3.0) to Oracle Identity Manager 12c (12.2.1.4.0) directly, using the one-hop upgrade process

 While running Upgrade Assistant during 12cPS4 One-hop upgrade >>>  UNEXPEXTED TABLESPACE" privilege while running upgrade

INFO Oracle Platform Security Services schema OIM_OPSS has unexpected CREATE ANY INDEX system privilege.
This maybe caused by a known issue, anyway, this unexpected system privilege will be revoked starting from FMW release 12.2.1.0.0.
So this issue will be fixed in upgrades starting from release 12.2.1.0.0.
[OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN]  INFO Oracle Platform Security Services schema OIM_OPSS has unexpected UNLIMITED TABLESPACE system privilege.
This maybe caused by a known issue, anyway, this unexpected system privilege will be revoked starting from FMW release 12.2.1.0.0.So this issue will be fixed in upgrades starting from release 12.2.1.0.0.
 [OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN]  Completed schema test: PRIVILEGES_TEST --> Test that the Oracle Platform Security Services schema has appropriate system privileges +++ FAIL

Cause

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