Table 1. Support for Oracle Database
Supported Family/Models Collectors Prerequisites Ports
Oracle 10 and later SQL-Collector

The appropriate JDBC driver jar file needs to be in the …/APG/Databases/JDBC-Drivers/Default/lib folder.

ORACLE database user credentials are required.

1521 TCP

Notes

  • Work with your DBA to determine the appropriate JDBC driver based on the installed version of Oracle. Download the JDBC driver from: www.oracle.com/technetwork/database/features/jdbc.
  • The SolutionPack for Oracle Database was tested with ojdbc5.jar and ojdbc7.jar on Oracle 12g versions.

Main reports

  • Entire Oracle database infrastructure summary
  • Detailed database size
  • Oracle RAC view
  • Instances availability
  • Cross-server KPIs