Before a vCenter Server system can connect to an Oracle database locally, you must set up the connection.

1

Create a new tablespace for a vCenter Server system using a SQL statement such as the following statement.

CREATE TABLESPACE "VPX" DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.dat' SIZE 1000M AUTOEXTEND ON NEXT 500K;
2

Create a user, such as vpxAdmin, for accessing the tablespace through ODBC.

CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
3

Grant permissions to the user, in one of the following ways.

Grant dba permission to the user.

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.

Optionally, you can enable Database Monitoring for Oracle database users. Otherwise, install vCenter Server.