VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Setup Manual

Page: 48 / 276

3 Grant permissions to the user, in one of the following ways.
n
Grant dba permission to the user.
n
Grant the following permissions to the user.
grant connect to user
grant resource to user
grant create view to user
grant create sequence to user
grant create table to user
grant create materialized view to user
grant execute on dbms_lock to user
grant execute on dbms_job to user
grant unlimited tablespace to user # To ensure space is sufficient
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.
4 Create an ODBC connection to the database.
The following code shows example settings.
Data Source Name: VMware vCenter Server TNS Service Name: VPX User Id: vpxAdmin
You now have a database that you can connect to locally.
What to do next
Optionally, you can enable Database Monitoring for Oracle database users. Otherwise, install vCenter
Server.
(Optional) Configure an Oracle Database User to Enable Database Monitoring
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.
Database Monitoring for vCenter Server enables administrators to monitor the database server CPU,
memory, I/O, data storage, and other environment factors for stress conditions. Statistics are stored in the
vCenter Server Profile Logs.
Enable Database Monitoring for a user before or after you install vCenter Server. You can perform this
procedure while vCenter Server is running.
Procedure
1 Log in to a SQL*Plus session with the system account.
2 Run the following SQL commands to grant additional permissions to the vCenter Server database user:
grant select on v_$system_event to user;
grant select on v_$sysmetric_history to user;
grant select on v_$sysstat to user;
grant select on dba_data_files to user;
grant select on v_$loghist to user;
vCenter Database Monitoring is enabled.
vSphere Installation and Setup
48 VMware, Inc.