VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Setup Manual, Page: 43 / 276

7 (Optional) Configure an Oracle Database User to Enable Database Monitoring on page 48
vCenter Server Database Monitoring captures metrics that enable the administrator to assess the status
and health of the database server. Enabling Database Monitoring helps the administrator prevent
vCenter downtime because of a lack of resources for the database server.
Configure an Oracle Database User
To use an Oracle database when you install vCenter Server, you must configure the database user.
You can configure an Oracle database for vCenter Server either locally on the same Microsoft Windows
machine as vCenter Server or remotely on a network-connected Linux, UNIX or Microsoft Windows host.
Prerequisites
Review the software requirements for vCenter Server with Oracle.
Procedure
1 Log in to a SQL*Plus session with the system account.
2 Run the following SQL command to create a vCenter Server database user with the correct permissions.
The script is located in the vCenter Server installation package
/installation directory/vCenter-
Server/dbschema/DB_and_schema_creation_scripts_oracle.txt
file.
In this example, the user name is VPXADMIN.
CREATE USER "VPXADMIN" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE
"VPX" ACCOUNT UNLOCK;
grant connect to VPXADMIN;
grant resource to VPXADMIN;
grant create view to VPXADMIN;
grant create sequence to VPXADMIN;
grant create table to VPXADMIN;
grant create materialized view to VPXADMIN;
grant execute on dbms_lock to VPXADMIN;
grant execute on dbms_job to VPXADMIN;
grant select on dba_tablespaces to VPXADMIN;
grant select on dba_temp_files to VPXADMIN;
grant select on dba_data_files 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.
N
OTE
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>'
3 (Optional) After you have successfully installed vCenter Server with the Oracle database, you can
revoke the following privileges.
revoke select on dba_tablespaces from VPXADMIN;
revoke select on dba_temp_files from VPXADMIN;
revoke select on dba_data_files from VPXADMIN;
Chapter 3 Before You Install vCenter Server
VMware, Inc. 43