6.7

grant select on dba_temp_files to VPXADMIN;
grant select on dba_data_files to VPXADMIN;
grant select on v_$session to VPXADMIN;
grant unlimited tablespace to VPXADMIN;
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.
Note Instead of granting unlimited tablespace, you can set a specific tablespace quota. The
recommended quota is unlimited with a minimum of at least 500MB. To set an unlimited quota, use
the following command.
alter user "VPXADMIN" quota unlimited on "VPX";
If you set a limited quota, monitor the remaining available tablespace to avoid the following error.
ORA-01536: space quota exceeded for tablespace 'tablespace'
You now have an Oracle database user for vCenter Server.
3 Enable database monitoring for the vCenter Server database user.
For example, to grant database disk size monitoring permissions to the VPXADMIN user, you can run
the following script:
grant select on v_$system_event to VPXADMIN;
grant select on v_$sysmetric_history to VPXADMIN;
grant select on v_$sysstat to VPXADMIN;
grant select on dba_data_files to VPXADMIN;
grant select on v_$loghist to VPXADMIN;
(Optional) Use a Script to Create the Oracle Database Schema
The vCenter Server installer creates the schema during installation. For experienced database
administrators who need more control over schema creation because of environmental constraints, you
can optionally use a script to create your database schema.
Procedure
1 Open a SQL*Plus window with a user that has schema owner rights on the vCenter Server database.
2 Locate the dbschema scripts in the vCenter Server installation package /installation
directory/vCenter-Server/dbschema directory.
3 In SQL*Plus, run the scripts in a sequence on the database.
a
VCDB_oracle.SQL
b
VCDB_views_oracle.SQL
c
insert_stats_proc_oracle.sql
vCenter Server Installation and Setup
VMware, Inc. 103