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.
- 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.
- Add the following entry, where
HOSTis 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) ) )