6.7

Table Of Contents

You must first create a tablespace and user for vCenter Server. Then you grant permissions to the

database user. You must also enable database monitoring for the user before you install vCenter Server.

See Database Permission Requirements for vCenter Server.

To perform the following procedure, you can either use the graphical user interface or run scripts. The

vCenter Server installer package contains example scripts in the vCenter-

Server\dbschema\DB_and_schema_creation_scripts_PostgreSQL.txt file.

Prerequisites

Procedure

1 Create a tablespace for vCenter Server.

For example, to create the tablespace VPX, you can run the following script:

CREATE SMALLFILE TABLESPACE "VPX" DATAFILE 'C:\database_path\vpx01.dbf'

SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT

SPACE MANAGEMENT AUTO;

2 Create a database user with the correct permissions for vCenter Server.

For example, to create the VPXADMIN user, you can run the following script:

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_lock to VPXADMIN;

grant select on dba_tablespaces to VPXADMIN;

vCenter Server Installation and Setup

VMware, Inc. 102