Configuring the init.ora file

After installing an Oracle database server, you must configure the init.ora file for the IBM® Security Identity Manager database.

Before you begin

You need to have the Oracle database server installed.

Procedure

  1. Copy the init.ora file.
    • Windows operating systems:
      1. Under the ORACLE_HOME\admin\ directory, create a directory named db_name\pfile. The value of db_name might be itimdb.
      2. Copy the sample initsmpl.ora file from the ORACLE_HOME\db_1\admin\sample\pfile\ directory to the ORACLE_HOME\admin\db_name\pfile directory.
      3. Rename the new init.ora file to a value of initdb_name.ora.
    • UNIX or Linux® operating systems:

      Copy the ORACLE_HOME/product/<version number>/dbhome_1/dbs/init.ora file to a new ORACLE_HOME/dbs/initdb_name.ora file.

  2. Based on your environment requirements, tune the value of the following parameters in the initdb_name.ora file: 
    db_name=itimdb
compatible=<version number>
processes=150
shared_pool_size=50000000

    Additionally, define three control files for the IBM Security Identity Manager database. This example statement defines the control files for the UNIX operating system:

    control_files=(ORACLE_HOME/oradata/db_name/control01.ctl,
ORACLE_HOME/oradata/db_name/control02.ctl,
ORACLE_HOME/oradata/db_name/control03.ctl)

    Use the IBM Security Identity Manager Performance Tuning Guide to tune Oracle database for all systems for both production and test environments.

  3. Manually create all the directories defined in the initdb_name.ora file.

What to do next

Set the environment variables.