Documentation forServer & Application Monitor

Configure SAM to monitor Oracle database servers

The following SAM templates use the Oracle User Experience Monitor to assess the status and performance of Oracle databases:

The Oracle User Experience Monitor does not support polling via Orion Remote Collectors (ORCs).

To support the Oracle User Experience Monitor, install one of the following drivers on the Orion server and any Additional Polling Engines (APEs) in your environment:

Note the following details about these drivers:

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.

To learn more about monitoring Oracle servers with SAM, see:

Configure accounts and permissions

Account requirements to monitor Oracle database servers with SAM include:

  • The Orion account running Orion services has Full Control privileges for files in the following 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 requirements, as described in:

If messages such as: Table or view doesn't exist appear, check permissions for Oracle accounts used to run SQL statements, as defined in the Oracle User Experience Monitor.

Remove the legacy Basic Lite Client

If your environment includes existing installations of the legacy Basic Lite Client provided by SolarWinds for earlier versions of SAM (for example, SAM 6.3), follow these steps to remove them before installing the latest Oracle drivers.

  1. Log into the Orion server.
  2. Use the Orion Service Manager to stop Orion services.
  3. In File Explorer, navigate to the default installation folder:
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  4. Delete Orion Client files.
  5. Repeat these steps for each APE in your environment.