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

Before you begin

Procedure

  1. Install the Oracle client on the Update Manager server machine.
  2. 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.

  3. (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.

  4. Create an ODBC connection to the database.

    These are example settings.

    Data Source Name: VUM
    TNS Service Name: VUM
    User Id: vumAdmin