After you choose a supported database type, make sure you understand any special configuration requirements.

1 is not a complete list of databases supported with vCenter Server. For information about specific database versions and service pack configurations supported with vCenter Server, see the VMware Product Interoperability Matrixes. This topic is intended only to provide special database configuration notes not listed in the Product Interoperability Matrixes.

Note:

vCenter Update Manager also requires a database. VMware recommends that you use separate databases for vCenter Server and vCenter Update Manager.

vCenter Server databases require a UTF code set.

See also Supported Database Upgrades.

Table 1. Configuration Notes for Databases Supported with vCenter Server

Database Type

Configuration Notes

Microsoft SQL Server 2008 R2 Express

Bundled database that you can use for small deployments of up to 5 hosts and 50 virtual machines.

SQL Server Collation Model: SQL_Latin1_General_CP1_CI_AS.

ODBC System DSN minimum version: SQL Native Client 10.0 (version 2009.100.4000.00), which you can obtain as a free download from the microsoft.com Download Center.

You cannot install the bundled database during an upgrade to vCenter Server. To use the bundled database, Microsoft SQL Server 2008 R2 Express must be already installed or you must perform a clean installation of vCenter Server.

Note:

This database is not supported for the vCenter Server Appliance.

Microsoft SQL Server 2008

Ensure that the machine has a valid ODBC DSN entry.

SQL Server Collation Model: SQL_Latin1_General_CP1_CI_AS.

ODBC System DSN minimum version: SQL Native Client 10.0 (version 2009.100.4000.00), which you can obtain as a free download from the microsoft.com Download Center.

Note:

This database is not supported for the vCenter Server Appliance.

Microsoft SQL Server 2012 SP1

Ensure that the machine has a valid ODBC DSN entry.

Oracle 11g and 12c

Ensure that the machine has a valid ODBC DSN entry.

After you complete the vCenter Server installation, take the following steps:

  • Apply the latest patch to the Oracle client and server.

  • Copy the Oracle JDBC driver (ojdbc14.jar or ojdbc5.jar) to the vCenter Server installation directory, in the tomcat\lib subdirectory: vCenter install location\Infrastructure\tomcat\lib.

  • In the Services section of the Windows Administrative Tools control panel, restart the VMware VirtualCenter Management Webservices service.

The vCenter Server installer attempts to copy the Oracle JDBC driver from the Oracle client location to the vCenter Server installation directory. If the Oracle JDBC driver is not found in the Oracle client location, the vCenter Server installer prompts you to copy the file manually. You can download the file from the oracle.com Web site.