6.7

Table 3‑7. Oracle Database Permissions for vCenter Server (Continued)
Permission Description
GRANT CREATE SEQUENCE TO VPXADMIN Necessary for creating a sequence.
GRANT CREATE TABLE TO VPXADMIN Necessary for creating a table.
GRANT CREATE MATERIALIZED VIEW TO VPXADMIN Necessary for creating a materialized view.
GRANT EXECUTE ON dbms_lock TO VPXADMIN Necessary for guaranteeing that the vCenter Server database is
used by a single vCenter Server instance.
GRANT EXECUTE ON dbms_job TO VPXADMIN Necessary during installation or upgrade for scheduling and
managing the SQL jobs.
This permission is not required after deployment.
GRANT SELECT ON dba_lock TO VPXADMIN Necessary for determining existing locks on the vCenter Server
database.
GRANT SELECT ON dba_tablespaces TO VPXADMIN Necessary during upgrade for determining the required disk
space.
This permission is not required after deployment.
GRANT SELECT ON dba_temp_files TO VPXADMIN Necessary during upgrade for determining the required disk
space.
This permission is not required after deployment.
GRANT SELECT ON dba_data_files TO VPXADMIN Necessary for monitoring the free space while vCenter Server is
working.
GRANT SELECT ON v_$session TO VPXADMIN View used to determine existing locks on the vCenter Server
database.
GRANT UNLIMITED TABLESPACE TO VPXADMIN Necessary for granting unlimited tablespace permissions to the
vCenter Server database user.
GRANT SELECT ON v_$system_event TO VPXADMIN Necessary for checking log file switches.
GRANT SELECT ON v_$sysmetric_history TO VPXADMIN Necessary for checking the CPU utilization.
GRANT SELECT ON v_$sysstat TO VPXADMIN Necessary for determining the Buffer Cache Hit Ratio.
GRANT SELECT ON dba_data_files TO VPXADMIN Necessary for determining the tablespace utilization.
GRANT SELECT ON v_$loghist TO VPXADMIN Necessary for checking the checkpoint frequency.
The privileges on the master database are used to monitor the vCenter Server database. so that, for
example, if a certain threshold is reached, you can see an alert.
Verify That vCenter Server Can Communicate with the Local Database
If your database is on the same machine on which vCenter Server is to be installed, and you changed the
machine name, verify the configuration. Make sure that the vCenter Server DSN is configured to
communicate with the new name of the machine.
Changing the vCenter Server computer name impacts database communication if the database server is
on the same computer with vCenter Server. If you changed the machine name, you can verify that
communication remains intact.
vCenter Server Installation and Setup
VMware, Inc. 108