Oracle Database
This page explains how to prepare a Oracle database for the connectivity to SAP Focused Run.
Currently the following monitoring application are supported for Oracle databases:
This page explains how to prepare a Oracle database for the connectivity to SAP Focused Run.
Currently the following monitoring application are supported for Oracle databases:
Task | Actions |
---|---|
Install Oracle Database | Optionally install the latest Oracle DB and latest Patches from support.sap.com/swdc -> Databases -> Oracle |
Create DB monitoring user and set connection credentials
| No specific tasks are to do be performed for Oracle database. The SAP Host Agent can manage the connection to an Oracle DB by itself without additional credential. In the case of connection problems, see SAP Host Agent Troubleshooting Guide (Oracle DB) page. |
Run Outside Discovery on the Host | As prerequisites, you shall install the SAP Host Agent and run Outside Discovery as described in Preparing Outside Discovery page. |
Support of BR*tools based metrics | Prerequisites: at least SAP Host Agent 7.22 PL57 and SAP Focused Run 3.0 monitoring content delivery version 17. |
Monitoring of Oracle RAC | Prerequisites:
Configuration steps:
Example of the configuration file for one DB running on two Oracle RAC nodes:
1 Oracle DB on host 2: DatabaseDiscoveryMethod : databasesystem
Remark: in case of multi DB installation, all relevant dbsystems must be maintained in this file! |
Monitoring of Oracle Data Guard | not supported |