Installation guide

grant create materialized view to <user>
grant execute on dbms_job to <user>
grant execute on dbms_lock to <user>
grant unlimited tablespace to <user> # To ensure sufficient space
After the upgrade is complete, you can optionally remove the following permissions from the user profile:
create any sequence and create any table.
By default, the RESOURCE role has the CREATE PROCEDURE, CREATE TABLE, and CREATE
SEQUENCE privileges assigned. If the RESOURCE role lacks these privileges, grant them to the vCenter
Server database user.
Prerequisite for IBM DB2 Databases
To use a newly supported IBM DB2 database, you must use vCenter Server 4.0 Update 1 or higher. Previous
releases of VirtualCenter or vCenter Server do not support DB2 databases.
vCenter Server Database Patch and Configuration Requirements
After you choose a database type, make sure you understand the configuration and patch requirements for
the database.
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.
If your VirtualCenter 2.5 Update 6 database is not supported for upgrade to vCenter Server 5, first upgrade
your database and then upgrade to vCenter Server. You also can import your database into a database that is
supported for upgrade to vCenter Server.
If your database is not listed in Table 4-2, see “Supported Database Upgrades,” on page 34.
For information about specific database versions and service pack configurations supported with vCenter
Server, see the VMware Product Interoperability Matrixes.
Table 4-2. Configuration Notes for Databases Supported with vCenter Server
Database Type Configuration Notes
IBM DB2 If the database is not local to the vCenter Server system, install the IBM Data Server Runtime
Client.
Install the IBM DB2 native client according to the IBM instructions for your DB2 version.
Ensure that the DB2 binaries directory (typically C:\Program Files\IBM\SQLLIB\BIN) is in
the system path. DB2 might be installed at a different location.
You might need to restart the Microsoft Windows machine for the service to recognize the
change in the environment variable.
Ensure that the machine has a valid ODBC data source name (DSN) entry.
NOTE This database is not supported for the vCenter Server Appliance.
Microsoft SQL Server 2008
R2 Express
Bundled database that you can use for small deployments of up to 5 hosts and 50 virtual
machines.
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 2005 Ensure that the machine has a valid ODBC DSN entry.
NOTE This database is not supported for the vCenter Server Appliance.
Chapter 4 Upgrading to vCenter Server 5.0
VMware, Inc. 33