5.5

Table Of Contents
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:
n
CONNECT
n
RESOURCE
n
CREATE TRIGGER
n
CREATE TYPE
n
CREATE VIEW
n
CREATE MATERIALIZED VIEW
n
CREATE PROCEDURE
n
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)
Configure a Microsoft SQL Server Database
SQL Server 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.
vCloud Director database performance is an important factor in overall vCloud Director performance and
scalability. vCloud Director uses the SQL Server tmpdb file when storing large result sets, sorting data, and
managing data that is being concurrently read and modified. This file can grow significantly when
vCloud Director is experiencing heavy concurrent load. It is a good practice to create the tmpdb file on a
dedicated volume that has fast read and write performance. For more information about the tmpdb file and
SQL Server performance, see http://msdn.microsoft.com/en-us/library/ms175527.aspx.
Prerequisites
n
You must be familiar with Microsoft SQL Server commands, scripting, and operation.
n
To configure Microsoft SQL Server, log on to the SQL Server host computer using administrator
credentials. You can configure SQL server to run with the LOCAL_SYSTEM identity, or any identity
with the privilege to run a Windows service.
Chapter 1 Overview of vCloud Director Installation, Configuration, and Upgrade
VMware, Inc. 15