You can configure your Oracle database to work with Update Manager remotely.
- 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