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.

Procedure

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