SAPDatabase resource in pacemaker does not perform status on 'ora-xxx' processes when there are multiple databases running on same server

Solution Verified - Updated -

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 in SAPDatabase resource script /usr/lib/ocf/lib/heartbeat/sapdb.sh only checks for processes of the form ora_[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 in sapdatabase_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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content