A vCenter Server system can access the database remotely.

Review the required database patches specified in vCenter Server Database Patch and Configuration Requirements. If you do not prepare your database correctly, the vCenter Server installer displays error and warning messages.

1

Install the Oracle client on the vCenter Server system machine.

2

Download and install the ODBC driver.

3

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

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

CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
5

Either grant dba permission to the user, or 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 does not have these privileges, explicitly grant them to the vCenter Server database user.

6

Use a text editor or the Net8 Configuration Assistant to edit the tnsnames.ora file located in the directory C:\Oracle\Oraxx\NETWORK\ADMIN, where xx is either 10g or 11g.

Add the following entry, where HOST is the managed host to which the client must connect.

VPX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
   )
(CONNECT_DATA =
(SERVICE_NAME = VPX)
   )
   )
7

Configure the TNS Service Name option in the ODBC DSN.

The TNS Service Name is the net service name for the database to which you want to connect, in this case, VPX. You can find the net service name in the tnsnames.ora file.