SAPDatabase resource in pacemaker does not perform status on 'ora-xxx' processes when there are multiple databases running on same server
Issue
-
SAPDatabase resource in pacemaker does not perform status on 'ora-xxx' processes when there are multiple databases running on same server
The
sapdatabse_status
function inSAPDatabase
resource script/usr/lib/ocf/lib/heartbeat/sapdb.sh
only checks for processes of the formora_[a-z][a-z][a-z][a-z]
, this does not cater for systems where there are multiple databases running. To cater for Oracle 12c and multiple databases on one server, following changes were required to be done insapdatabase_status
function of above resource script:< ORA) SEARCH="ora_[a-z][a-z][a-z][a-z]_" --- > ORA) SEARCH="ora_[a-z][a-z][a-z][a-z]_$SID"
Environment
- Red Hat Enterprise Linux 6.7 with High Availability Add-Ons
- Red Hat Enterprise Linux 7 with High Availability Add-Ons
- Pacemaker
- SAP
- Oracle 12c
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.