My Oracle Support Banner

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

Last updated on JULY 23, 2021

Applies to:

Oracle Platform Security for Java - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

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

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
References


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