SAPDatabase fails monitor checks with error "invalid parameter" with an Oracle 12c Database running under username "oracle" in a RHEL 7 High Availability cluster

Solution Verified - Updated -

Issue

  • When I run pcs resource cleanup on my SAPDatabase, it fails
  • My SAPDatabase resource always fails as soon as it starts, giving an "invalid parameter" error
  • pcs status shows "invalid parameter" errors for my Oracle SAP Database reporting the "Database not found"
cmd_ora_PLE_monitor_120000 on node1-HA 'invalid parameter' (2): call=531, status=complete, exitreason='none', last-rc-change='Wed Nov 30 10:09:56 2016', queued=0ms, exec=0ms
Nov 29 10:01:58 [1764] node1       lrmd:   notice: operation_finished:  cmd_ora_PLE_monitor_120000:14066:stderr [ Error: Database not found ]
Nov 29 10:01:58 [1768] node1       crmd:     info: process_lrm_event:   Result of monitor operation for cmd_ora_PLE on node1-HA: 2 (invalid parameter) | call=296 key=cmd_ora_PLE_monitor_120000 confirmed=false cib-update=163
Nov 29 10:01:58 [1768] node1       crmd:   notice: process_lrm_event:   node1-HA-cmd_ora_PLE_monitor_120000:296 [ Error: Database not found\n ]
  • If my SAP Oracle Database is running when a node first joins the cluster (such as if it started on bootup), then the cluster does not detect it and starts that database elsewhere, causing corruption.

Environment

  • Red Hat Enterprise Linux (RHEL) 7 for SAP with the High Availability Add On
  • One or more SAPDatabase resources managed by the cluster
    • Managing an Oracle 12c Database serving SAP
      • Oracle Database is configured to run as a user named anything other than "ora" + the SID (in lowercase). If the SID were DB1, then the expected user is "oradb1". Anything else can trigger this issue

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.