Installing and configuring a vCloud Director 5.1 database (2034540)
vCloud Director 5.1 cells use a database to store shared information. This database must exist before you can complete installation and configuration of vCloud Director software. This article describes how to create these databases so you can complete your vCloud Director installation.
Note: Regardless of the database software you choose, you must create a separate, dedicated database schema for vCloud Director to use. vCloud Director cannot share a database schema with any other VMware product.
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.
Create the database instance. Use commands with this 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;
Create the vCloud Director database user account. This 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, and vcloudpass must be the password.
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
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 these system privileges to the account:
CREATE MATERIALIZED VIEW
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 with this form:
(SERVICE_NAME = orcl.example.com)
- 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.
- Specify Mixed Mode authentication during Microsoft SQL setup. Windows Authentication is not supported when using Microsoft SQL with vCloud Director.
- Create the database instance. This script creates the database and log files, specifying the proper collation sequence:
CREATE DATABASE [vcloud] ON PRIMARY
(NAME = N'vcloud', FILENAME = N'C:\vcloud.mdf', SIZE = 100MB, FILEGROWTH = 10% )
(NAME = N'vcdb_log', FILENAME = N'C:\vcloud.ldf', SIZE = 1MB, FILEGROWTH = 10%)
Note: The values shown for SIZE are suggestions. You might need to use larger values depending on the size of your environment.
- Set the transaction isolation level. This script sets the database isolation level to READ_COMMITTED_SNAPSHOT:
ALTER DATABASE [vcloud] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [vcloud] SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE [vcloud] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
ALTER DATABASE [vcloud] SET MULTI_USER;
For more information about transaction isolation, see the Microsoft article http://msdn.microsoft.com/en-us/library/ms173763.aspx.
Note: The preceding link was correct as of September 11, 2012. If you find the link is broken, provide feedback and a VMware employee will update the link.
- Create the vCloud Director database user account. This script creates database user name vcloud with password vcloudpass:
CREATE LOGIN [vcloud] WITH PASSWORD = 'vcloudpass', DEFAULT_DATABASE =[vcloud],
DEFAULT_LANGUAGE =[us_english], CHECK_POLICY=OFF
CREATE USER [vcloud] for LOGIN [vcloud]
Note: You must use the username vcloud and password vcloudpass.
- Assign permissions to the vCloud Director database user account. This script assigns the db_owner role to the database user created in Step 5:
sp_addrolemember [db_owner], [vcloud]