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, tools, and much more.