VMware VS4-ENT-PL-A Setup Guide - Page 43
Con an Oracle Database User - plus
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 43 highlights
Chapter 3 Before You Install vCenter Server 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/vCenterServer/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. 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 '' 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; VMware, Inc. 43