FMW 11g IDM Configuration Assistant: " Load Oracle Internet Directory Schema - Failed "
Last updated on FEBRUARY 15, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124
Oracle Fusion Middleware - Version: 126.96.36.199.0 and later [Release: Oracle11g and later]
Information in this document applies to any platform.
"Load Oracle Internet Directory Schema".
The Configuration Assistant shows the generic error
RCU OID Schema Creation Failed
Figure 1: Screenshot of the error as seen in the Configuration Assistant
The $ORACLE_HOME/rcu/log/oid.log reveals the underlying error
Done running oidpurge.sql
grant execute on dbms_job to ods
ERROR at line 1:
ORA-01031: insufficient privileges
2011-11-13 07:06:29.150 rcu:Executing SQL statement: drop tablespace OLTS_DEFAULT including contents and datafiles
2011-11-13 07:06:33.667 rcu:Executing SQL statement: drop tablespace OLTS_ATTRSTORE including contents and datafiles
2011-11-13 07:06:37.812 rcu:Executing SQL statement: drop tablespace OLTS_BATTRSTORE including contents and datafiles
2011-11-13 07:06:42.065 rcu:Executing SQL statement: drop tablespace OLTS_CT_STORE including contents and datafiles
- The target database for the Metadata schemas is Oracle Server 11.2.0.x
- The Metadata schemas have not been created already using Repository Creation Utility (RCU). Instead the option "Create Schema" has been chosen.
- The Database user specified was NOT "SYS". Rather as per the System Requirements Guide a user with SYSDBA privileges assigned, such as "system", was specified
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