Solution : https://service.sap.com/sap/support/notes/1139623 (SAP Service marketplace login required)
Summary :
Starting from SAP Basis Release 7.00 SP15, transaction RZ20 supports monitoring of remote Oracle databases. Users must ensure remote Oracle databases are registered in the DBA cockpit with "Active" status, necessitating at least a secondary data connection. ABAP systems version 4.6C or newer, as well as non-ABAP systems, are compatible, provided the Oracle database is at minimum version 9. Required installations include BR*Tools patches depending on the Oracle client version used. Specific SQL synonym commands are needed for older setups. Further, system configurations and prerequisite fulfillment as instructed should align with SAP Note 1028624 for successful monitoring. Corrective actions from subsequent notes must be implemented to rectify identified issues in monitoring functions within RZ20 across various support packages, optimizing transaction executions and database inspections.
Key words :
sqlplus sap<schema_id>/<pwd> sql> @dbcheckora9or sql> @dbcheckora10_oltpor sql> @dbcheckora11_oltpstep 3, choosing sap ccms monitor templates -> remote databases -> oracle, sqlplus sap<schema_id>/<pwd> sql> @rz20_nonabap, sap ccms monitor templates -> database -> oracle, enqueuelatchrow cachelibrary cachelog file switchcursor 2, choosing 'alerts' -> 'alert monitor', profile parameter alert/moni_segm_size, default auto-reaction method, create public synonym sap_dbstatc, create public synonym sap_dbcheckora
Related Notes :
| 892294 | Enhanced support for non-ABAP database in BRCONNECT 7.00 |
| 134592 | Importing the SAPDBA role (sapdba_role.sql) |