Configure an Oracle Database to Work Remotely

You can configure your Oracle database to work with Update Manager remotely.

Prerequisites

Verify that the ODBC data source that you use is a 64-bit system DSN. See Create a 64-Bit DSN.
Set up a database as described in Configure an Oracle Database.

Install the Oracle client on the Update Manager server machine.
Use the Net Configuration Assistant tool to add the entry to connect to the managed host.
```
VUM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=host_address)(PORT=1521))
)
(CONNECT_DATA =(SERVICE_NAME = VUM)
)
)
```
In this example, host_address is the managed host to which the client needs to connect.
(Optional) Edit the tnsnames.ora file located in ORACLE_HOME\network\admin\, as appropriate.
Here, ORACLE_HOME is located under C:\ORACLE_BASE, and it contains subdirectories for Oracle software executable and network files.
Create an ODBC connection to the database.
These are example settings.
```
Data Source Name: VUM
TNS Service Name: VUM
User Id: vumAdmin
```