FMW 11g IDM Configuration Assistant: " Load Oracle Internet Directory Schema - Failed "

(Doc ID 1377147.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Oracle Fusion Middleware - Version: 11.1.1.2.0 and later    [Release: Oracle11g and later]
Information in this document applies to any platform.

Symptoms

The objective is to configure an Oracle Internet Directory 11g AS Instance. The configuration assistant fails at the step:

"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
*************************

Session altered.

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

Changes

The problem only occurs given the following setup and choice of configuration options:
  • 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

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