Documentation forServer & Application Monitor

Configure SAM to monitor Oracle database servers

The following SAM templates include an Oracle User Experience Monitor that is specifically designed to assess the status and performance of Oracle databases:

Unlike most SAM component monitors, the Oracle User Experience Monitor requires that you install an additional driver on systems where SAM is running, including the Orion server and Additional Polling Engines (APEs) in your environment.

You can use either of the following .NET data providers to monitor Oracle databases with SAM:

  • Oracle Data Provider for .NET (ODP.NET)
    • Download from Oracle (© 2020 Oracle, available at oracle.com, obtained on September 12, 2020).
    • Registration is required, but free.
    • Install all components, or at least the Oracle Data Provider for .NET and the Oracle Instant Client.
    • Remove any existing versions of the Oracle Client first.
    • Install on the Orion server and APEs.
  • Oracle Instant Client, provided by SolarWinds, as described next.

After installing a .NET data provider on the Orion server and any APEs:

Install the Oracle Client on Orion servers and APEs

SolarWinds provides updated Oracle database client connectivity libraries in a OracleClientInstaller.zip file that replaces the legacy Basic Lite Client posted in the Customer Portal.

  1. Log into the Orion server.
  2. Check for a legacy Oracle Client and remove it, if necessary.
  3. Download the latest Oracle Client Installer and extract compressed files.
  4. In File Explorer, run OracleClientInstaller.exe.
  5. When installation is complete, verify that files were added to the following default folder:
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  6. Repeat these steps to install the Oracle Client on APEs, if necessary.
  7. Configure accounts and permissions, as described next.

Configure accounts and permissions

Requirements for monitoring Oracle database servers with SAM include:

  • The account running Orion services has Full Control privileges for files in this default folder:
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  • Oracle server credentials have Read access to the following Oracle views:
    • dba_free_space
    • v$sysstat
    • v$rowcache
    • v$librarycache
    • v$sgastat
    • v$session

Individual SAM templates may have additional account prerequisites.

Do not use Oracle credentials with limited permissions to run SQL statements defined in the Oracle User Experience Monitor. This will return errors such as: Table or view doesn't exist.

Remove the legacy Basic Lite Client from the Orion server and APEs

SolarWinds recommends using the updated Oracle Client available here, instead of the legacy Basic Lite Client from the SolarWinds Customer Portal, which included a Oracle Data Provider for .NET that supported old libraries. Before downloading and installing the latest Oracle Client, remove legacy Orion Clients from the Orion server and any APEs in your environment.

To delete an existing Orion Client installation:

  1. Log into the Orion server.
  2. In File Explorer, navigate to the default installation folder,
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  3. Stop Orion services.
  4. Delete Orion Client files.
  5. Repeat these steps to remove any Oracle Clients from APEs, as necessary.