Introduction

Many of the Oracle Fusion Middleware components require the existence of schemas in a database prior to installation. These schemas are created and loaded in your database using the Repository Creation Utility (RCU).

In this tutorial, we will demonstrate how to install the schema required for OID.

RCU Installation

The RCU installation consists of 2 main processes:

  1. Prepare the server environment

  2. Install the product

Prepare the Server Environment

The RCU build has to match the OIM build number. In our integration work, they all belong to the 11.1.1.9 suite of products.

Make sure the Database and the DB listener are up and running.

  1. Run the lsnrctl DB command to check the health of the database listener.

    lsnrctl status
    lsnrctl start
    lsnrctl stop
    
  2. Before we install the RCU on the database, we need to perform the following SQL statement to set certain limits in the database.

    sqlplus /as sysdba
    SQL> alter system set open_cursors=800 scope=both;
    SQL> alter system set processes=500 scope=spfile;
    SQL> grant execute on sys.dbms_job to PUBLIC;
    SQL> grant execute on dbms_reputil to PUBLIC;
    

Install the Product

  1. To install the Oracle Database, navigate to the product installation directory (such as /home/software-download/Oracle-RCU/rcuHome/bin/rcu), and run the installer.

    ./rcu
    
  2. Click Next.

    Oracle RCU Installation

  3. Select Oracle Internet Directory schema checkbox, and click Next.

    Oracle RCU Installation

  4. Enter the schema password, and click Next.

    Oracle RCU Installation

  5. Keep the default table space name, and click Next.

    Oracle RCU Installation

  6. Review the schema summary page before the installation, and click Next to proceed.

    Oracle RCU Installation

  7. Review the schema summary page after the installation is complete.

    Oracle RCU Installation

  8. Check the RCU log file for installation details.

    cat /home/software-download/Oracle-RCU/rcuHome/rcu/log/logdir/2017–02–16_12–37/rcu.log