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 before you install vCloud Director.

Procedure

  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 server groups.

  2. Create the database instance.

    Use a command of the following form to create a single CLOUD_DATA tablespace:

    Create Tablespace CLOUD_DATA datafile '$ORACLE_HOME/oradata/cloud_data01.dbf' size 1500M 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/tnsnames.ora on the database server and look for an entry of the following form:

    (SERVICE_NAME = orcl.example.com)