To configure an Oracle ODBC DSN, you must have a net service name for your database. On the machine on which your Oracle database is running, you must create a net service name for the vCenter Server tablespace.

1

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

2

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

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