Oracle databases have specific configuration requirements when you use them with vCloud Director. Install and configure a database instance and create the vCloud Director database user account the before you install vCloud Director.

1

Configure the database server.

A database server configured with 16GB of memory, 100GB storage, and 4 CPUs should be adequate for most vCloud Director clusters.

2

Create the database instance.

Use commands of the following form to create separate data (CLOUD_DATA) and index (CLOUD_INDX) tablespaces:

Create Tablespace CLOUD_DATA datafile '$ORACLE_HOME/oradata/cloud_data01.dbf' size 1000M autoextend on;

Create Tablespace CLOUD_INDX datafile '$ORACLE_HOME/oradata/cloud_indx01.dbf' size 500M autoextend on;
3

Create the vCloud Director database user account.

The following command creates database user name vcloud with password vcloudpass.

Create user $vcloud identified by $vcloudpass default tablespace CLOUD_DATA;
Note

When you create the vCloud Director database user account, you must specify CLOUD_DATA as the default tablespace.

4

Configure database connection, process, and transaction parameters.

The database must be configured to allow at least 75 connections per vCloud Director cell plus about 50 for Oracle's own use. You can obtain values for other configuration parameters based on the number of connections, where C represents the number of cells in your vCloud Director cluster.

Oracle Configuration Parameter

Value for C Cells

CONNECTIONS

75*C+50

PROCESSES

= CONNECTIONS

SESSIONS

= PROCESSES*1.1+5

TRANSACTIONS

= SESSIONS*1.1

OPEN_CURSORS

= SESSIONS

5

Create the vCloud Director database user account.

Do not use the Oracle system account as the vCloud Director database user account. You must create a dedicated user account for this purpose. Grant the following system privileges to the account:

CONNECT

RESOURCE

CREATE TRIGGER

CREATE TYPE

CREATE VIEW

CREATE MATERIALIZED VIEW

CREATE PROCEDURE

CREATE SEQUENCE

6

Note the database service name so you can use it when you configure network and database connections.

To find the database service name, open the file $ORACLE_HOME/network/admin/tsnames.ora on the database server and look for an entry of the following form:

(SERVICE_NAME = orcl.example.com)