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

Solution Unverified - Updated -

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.

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