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.
The RCU installation consists of 2 main processes:
Prepare the server environment
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 18.104.22.168 suite of products.
Make sure the Database and the DB listener are up and running.
Run the lsnrctl DB command to check the health of the database listener.
lsnrctl status lsnrctl start lsnrctl stop
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
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.
Select Oracle Internet Directory schema checkbox, and click Next.
Enter the schema password, and click Next.
Keep the default table space name, and click Next.
Review the schema summary page before the installation, and click Next to proceed.
Review the schema summary page after the installation is complete.
Check the RCU log file for installation details.