SAPDatabase fails monitor checks with error "invalid parameter" with an Oracle 12c Database running under username "oracle" in a RHEL 7 High Availability cluster
Issue
- When I run
pcs resource cleanupon mySAPDatabase, it fails - My
SAPDatabaseresource always fails as soon as it starts, giving an "invalid parameter" error pcs statusshows "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
SAPDatabaseresources 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
- Managing an Oracle 12c Database serving SAP
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
