Configure the init.ora file

After installing an Oracle database server, we must configure the init.ora file for the ISIM database.

We need to have the Oracle database server installed.

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 the 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 ISIM 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.

Set the environment variables.

Parent topic: Tasks for creating the database Previous topic: Installation of the Oracle database server Next topic: Environment variable settings for the Oracle database