You might encounter an error when connecting the vRealize Operations for Horizon broker agent to an Oracle event database.

Problem

During broker agent configuration, testing event database credentials fails with the following error: 

Event DB username and password cannot be validated. System.Data.OracleClient requires Oracle client
software version 8.1.7 or greater. An Error has Occurred. Operation Validate DB Credentials has Failed.

Cause

To use an Oracle event database, you must install a recent version of ODAC and the Oracle Instant Client on the host where the broker agent is installed.

Solution

  1. Go to the 64-bit Oracle Data Access Components (ODAC) for Windows download page and download the latest Xcopy for Windows x64 ODAC release.
  2. Follow the procedure given in the readme.html file included in the installation package.
  3. Go to the Instant Client for Microsoft Windows (x64) 64-bit download page and download the latest version of Oracle Instant Client.
    You can choose the Basic or Basic Light edition.
  4. Unzip the Instant Client package to a directory and add the directory to the PATH environment variable.
    If you have multiple versions installed, ensure that the new version occurs first in the path.