35.1 Configuring an Oracle Database

This section provides configuration options for using an Oracle database for the User Application. For information about supported versions of Oracle, see System Requirements for the Identity Applications.

35.1.1 Checking Compatibility Level of Databases

Databases from different releases of Oracle are compatible if they support the same features and those features perform the same way. If they are not compatible, certain features or operations might not work as expected. For example, creation of schema fails that does not allow you to deploy the identity applications.

To check the compatibility level of your database, perform the following steps:

  1. Connect to the Database Engine.

  2. After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name.

  3. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.

  4. Right-click the database, and then click Properties.

    The Database Properties dialog box opens.

  5. In the Select a page pane, click Options.

    The current compatibility level is displayed in the Compatibility level list box.

  6. To check the Compatibility Level, enter the following in the query window and click Execute.

    SQL> SELECT name, value FROM v$parameter

    WHERE name = 'compatible';

The expected output is: 12.1.0.2

35.1.2 Configuring the Character Set

Your User Application database must use a Unicode-encoded character set. When creating the database, use AL32UTF8 to specify this character set.

To confirm that an Oracle 12c database is set for UTF-8, issue the following command: 

select * from nls_database_parameters;

If the database is not configured for UTF-8, the system responds with the following information:

NLS_CHARACTERSET
WE8MSWIN1252

Otherwise, the system responds with the following information that confirms the database is configured for UTF-8:

NLS_CHARACTERSET
AL32UTF8

NOTE:It is recommended to use JDBC JAR version ojdbc6.jar.

For more information about configuring a character set, see “Choosing an Oracle Database Character Set”.

35.1.3 Configuring the Admin User Account

The User Application requires that the Oracle database user account have specific privileges. In the SQL Plus utility, enter the following commands: 

CREATE USER idmuser IDENTIFIED BY password;
GRANT CREATE SESSION TO idmuser;
GRANT CREATE CLUSTER TO idmuser;
GRANT CREATE PROCEDURE TO idmuser;
GRANT CREATE SEQUENCE TO idmuser;
GRANT CREATE TABLE TO idmuser;
GRANT CREATE TRIGGER TO idmuser;
ALTER USER idmuser quota 100M on USERS;

where idmuser represents the user account.