4 Installing and Configuring a Database for Oracle Identity Manager

Oracle Identity Manager requires a database. You must install and configure your database before you begin the Oracle Identity Manager installation. This chapter contains the following topics:

Using an Oracle Database for Oracle Identity Manager

Using an Oracle Database for Oracle Identity Manager

To use Oracle for your database, you must:

Install Oracle—see "Installing Oracle" for more information.
Create your Oracle database—see "Creating an Oracle Database" for more information.
Prepare the Oracle database—see "Preparing the Oracle Database" for more information.

Installing Oracle

Install the Oracle9i or 10g Release 2 database by referring to the documentation delivered with the Oracle database. See "Supported Databases" for the specific supported versions. Oracle recommends using the Basic installation.

Note:

If you choose the Custom installation, you must include the JVM option, which is required for XA transaction support.

Creating an Oracle Database

You need to create a new Oracle database instance for Oracle Identity Manager. When creating the database, make sure to configure the Oracle JVM feature and enable query rewrite.

You can use the Database Configuration Assistant (DBCA) tool to create the database. To configure the Oracle JVM feature, select the Oracle JVM feature on the Standard Database Features page of the DBCA.

To enable the database for query rewrite, set the init.ora parameters QUERY_REWRITE_ENABLED to TRUE and QUERY_REWRITE_INTEGRITY to TRUSTED in the All Initialization Parameters field of the DBCA.

Consult your Oracle database documentation for detailed instructions on creating a database instance.

Configuring the Database for Globalization Support

For globalization support for Oracle Identity Manager Release 9.0.2, Oracle recommends configuring the database for Unicode. To configure the database for Unicode, perform the following steps:

Set the database character to AL32UTF8, which supports the latest version of the Unicode standard, by selecting AL32UTF8 in the Character Sets tab of the DBCA.
Set the NLS_LENGTH_SEMANTICS init.ora parameter to CHAR in the All Initialization Parameters field of the DBCA.

See Also:
Oracle Identity Manager Globalization Guide

Preparing the Oracle Database

Once you have installed Oracle and created a database instance, you must prepare it for Oracle Identity Manager by completing the following tasks:

Verify that query rewrites is enabled
Enable XA transactions support

Note:
The Java JVM is required to enable XA transaction support. If you did not install the JVM during your Oracle installation, you must install it now. Consult Oracle documentation for specific instructions.
Create at least one tablespace for storing Oracle Identity Manager data
Create a database user account for Oracle Identity Manager

You can perform the preceding tasks to prepare your Oracle database for Oracle Identity Manager by running one of the following scripts:

prepare_xl_db.sh (for UNIX or Linux)
prepare_xl_db.bat (for Windows)

Both of these scripts ship with the Oracle Identity Manager installer and reside in the directory \installServer\Xellerate\db\oracle\.

You must observe the following prerequisites when using these scripts:

The script must be run by the user holding dba privilege (For example, the oracle user on UNIX or Linux typically holds these privileges).
The script must be run on the machine where the database resides.

To prepare your Oracle database for Oracle Identity Manager, complete the steps associated with the operating system on the machine hosting your Oracle database:

UNIX or Linux:

Copy the scripts prepare_xl_db.sh and xell_db_prepare.sql from the distribution CD to a directory on the machine hosting your database where you (as the account user performing this task) have write permission.
Run the following command to enable execute permission for the script:

chmod 755 prepare_xl_db.sh
Run the script prepare_xl_db.sh by entering the following command:

./prepare_xl_db.sh
Provide information appropriate for your database and host machine when the script prompts you for the following items:
1. The location of your Oracle home (ORACLE_HOME)
2. The name of your database (ORACLE_SID)
3. The name of the Oracle Identity Manager database user to be created
4. The password for the Oracle Identity Manager database user
5. The name of the tablespace to be created for storing Oracle Identity Manager data
6. The directory in which to store the data file for the Oracle Identity Manager tablespace
7. The name of the data file (you do not need to append the .dbf extension)
8. The name of the temporary tablespace.
Check the prepare_xell_db.lst log file located in the directory where you ran the xell_db_prepare script from to see execution status and additional information.

Windows:

Copy the scripts prepare_xl_db.bat and xell_db_prepare.sql from the distribution CD to a directory on the machine hosting your database where you (as the account user performing this task) have write permission.

Open a command window, navigate to the directory where you just copied the scripts, then run prepare_xl_db.bat with the following arguments:

prepare_xl_db.bat <ORACLE_SID> <ORACLE_HOME>
<XELL_USER> <XELL_USER_PWD> <TABLESPACE_NAME>
<DATAFILE_DIRECTORY> <DATAFILE_NAME>
<XELL_USER_TEMP_TABLESPACE> <SYS_USER_PASSWORD>

For example, the string you enter on the command line might look something like the following:

prepare_xl_db.bat XELL C:\oracle\ora92 xladm xladm
xeltbs C:\oracle\oradata xeltbs_01 TEMP manager

Table 4-1 lists the options used in the preceding example of prepare_xl_db.bat:

Table 4-1 Options for the prepare_xl_db.bat Script

Argument	Description
`XELL`	Name of the database
`C:\oracle\ora92`	Directory where the Oracle database is installed
`xladm`	Name of the Oracle Identity Manager user to be created
`xladm`	Password for the Oracle Identity Manager user
`xeltbs`	Name of the tablespace to be created
`C:\oracle\oradata`	Directory where the datafiles will be placed
`xeltbs_01`	Name of the datafile (you do not need to give .dbf extension)
`TEMP`	Name of the temporary tablespace that already exists in your database
`manager`	Password for the SYS user

Check the prepare_xell_db.lst log file located in the directory where you ran the xell_db_prepare script from to see execution status and additional information.

If the script returns a message indicating successful execution, you can continue to the next task, which is Oracle Identity Manager installation.

If the script does not succeed, you must manually fix all fatal errors so that the database is prepared successfully.

You can ignore non-fatal errors. For example, when the script tries to drop a non-existent view, it will return the error "ORA-00942: table or view does not exist". This can be ignored without adverse consequences.

Make sure to scan all the errors in the log file and ignore or resolve them on an individual basis. Remember that you must successfully prepare the database for Oracle Identity Manager before you can install Oracle Identity Manager.