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

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.

1

Specify the following settings when creating an Oracle database.

a

Select the General Purpose/Transaction Processing Database configuration option.

b

Click Use Unicode > UTF8.

c

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.

a

Increase the process connections using the alter command.

alter system set processes=600 scope=spfile
b

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";