oracledb resource takes a long time to stop and reports a timeout waiting for processes in RHEL 5 or 6 High Availability clusters with Oracle 11g
Issue
- The resource agent
oracledb.sh
is not working properly. Every operation that involves the offline of this resource incurs in a timeout - When I stop an
oracledb
resource, it always reports a timeout waiting for processes to stop:
Jun 11 12:50:37 node1 rgmanager[13447]: Stopping service service:myOracleService
Jun 11 12:50:38 node1 root[13722]: Validating configuration for orcl
Jun 11 12:50:38 node1 root[13730]: Validation checks for orcl succeeded
Jun 11 12:50:38 node1 root[13731]: Stopping service orcl
Jun 11 12:50:38 node1 root[13732]: Stopping Oracle DB orcl immediate
Jun 11 12:50:44 node1 root[13742]: [orcl] sent stop command set heading off;\nshutdown immediate;\nquit;\n
Jun 11 12:50:44 node1 root[13743]: [orcl] got Database closed.#012Database dismounted.#012ORACLE instance shut down.
Jun 11 12:50:44 node1 root[13744]: Stopped Oracle DB orcl successfully
Jun 11 12:50:44 node1 root[13745]: Stopping listener ORCLLISTENER for orcl
Jun 11 12:50:45 node1 root[13749]: Waiting for Oracle processes for orcl to terminate...
Jun 11 12:52:16 node1 root[14362]: Timed out while waiting for Oracle processes for orcl to terminate
Jun 11 12:52:16 node1 root[14369]: Not all Oracle processes for orcl exited cleanly, killing
Jun 11 12:52:16 node1 root[14371]: Stopping service orcl succeeded
Jun 11 12:52:16 node1 rgmanager[14407]: [ip] Removing IPv4 address 192.168.143.100/24 from eth1
Jun 11 12:52:16 node1 rgmanager[14463]: [fs] unmounting /ora1
Jun 11 12:52:18 node1 rgmanager[14532]: [lvm] Stripping tag, ha6ora11g-1-clust.example.com
Jun 11 12:52:18 node1 rgmanager[13447]: Service service:myOracleService is stopped
Environment
- Red Hat Enterprise Linux (RHEL) 5 or 6 with the High Availability Add On
rgmanager
- One or more
<oracledb>
resources in/etc/cluster/cluster.conf
managing an Oracle Database 11g instance
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.