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:

After installing Oracle drivers on the Orion server and any APEs:

  1. Configure accounts and permissions.
  2. Adjust Oracle User Experience Monitor settings to match Oracle database settings on target servers.
  3. Review prerequisites for SAM templates:

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.