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.

Review the software requirements for vCenter Server with Oracle.


Log in to a SQL*Plus session with the system account.


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.

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.


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>'

(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;

You now have an Oracle database user that you can reference in the vCenter Server installer.

Create the Oracle database, including all necessary table spaces and privileges.