During the Oracle database installation, you must specify certain Oracle configurations for optimum performance with VMware Identity Manager.

Prerequisites

The Oracle database you create is going to be called saas. VMware Identity Manager requires Oracle quoted identifiers for the username and schema. Therefore, you must use double quotes when you create the Oracle saas username and schema.

Procedure

  1. Specify the following settings when creating an Oracle database.
    1. Select the General Purpose/Transaction Processing Database configuration option.
    2. Click Use Unicode > UTF8.
    3. Use National Character Set.
  2. Connect to the Oracle database after the installation is finished.
  3. Log in to the Oracle database as the sys user.
  4. Increase the process connections. Each additional service virtual machine requires a minimum of 300 process connections to function with VMware Identity Manager. For example, if your environment has two service virtual machines, run the alter command as sys or system user.
    1. Increase the process connections using the alter command.
      alter system set processes=600 scope=spfile
    2. Restart the database.
  5. Create a database trigger that all users can use.

    Sample SQL to Create a Database Trigger

    CREATE OR REPLACE

    TRIGGER CASE_INSENSITIVE_ONLOGON

    AFTER LOGON ON DATABASE

    DECLARE

    username VARCHAR2(30);

    BEGIN

    username:=SYS_CONTEXT('USERENV','SESSION_USER');

    IF username = 'saas' THEN

    execute immediate 'alter session set NLS_SORT=BINARY_CI';

    execute immediate 'alter session set NLS_COMP=LINGUISTIC';

    END IF;

    EXCEPTION

    WHEN OTHERS THEN

    NULL;

    END;

  6. Run the Oracle commands to create a new user schema.

    Sample SQL to Create a New User

    CREATE USER "saas"

    IDENTIFIED BY <password>

    DEFAULT TABLESPACE USERS

    TEMPORARY TABLESPACE TEMP

    PROFILE DEFAULT

    ACCOUNT UNLOCK;

    GRANT RESOURCE TO "saas" ;

    GRANT CONNECT TO "saas" ;

    ALTER USER "saas" DEFAULT ROLE ALL;

    GRANT UNLIMITED TABLESPACE TO "saas";