Using RHPhelper to Minimize Downtime During Planned Maintenance on Exadata
(Doc ID 2385790.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database Products > Exadata
Oracle Database - Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 18]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
The purpose of RHPhelper is to reduce application service blackouts and brownouts from minutes to a few seconds for applications that meet the prerequisites below. The reduction in application impact is because RHPhelper avoids Oracle sessions from waiting for instance recovery to complete when a node is rebooted or shutdown.
This note explains the benefits of RHPhelper, how to obtain, install, configure and use it.
This note is intended for architects and administrators.
RHPhelper is available only for Exadata systems. You must have the following prerequisites for RHPhelper to work:
- Exadata software version 12.1.x or higher
- GI version 18.3, or higher
- RAC with at least 2 nodes
- Database versions 12.1 or higher (versions below 12.1 will not be drained by RHPhelper)
To obtain the benefit of draining sessions with RHPhelper, you must be:
- using services to connect to the database
- the service should have at least one preferred and one available node (or another preferred node)
- an application using a connection pool that is able to receive FAN events from the cluster (such as Oracle UCP for JDBC)
- RHPhelper must be enabled (see section 2.2 below)
RHPhelper is installed with GI version 18.3 or higher, but is disabled by default; see section 2.2 below for how to enable it.
For an OVM environment, to have a domU automatically drain its sessions when a dom0 is rebooted (for example when applying an Exadata DB node patch), you must have the above GI version installed and RHPhelper enabled in the domU.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1.0 Purpose and Operation|
|2.0 Service Configuration|
|2.1 Choosing appropriate drain timeout intervals|
|2.2 RHPhelper Attributes|
|2.2.1 SET RHPhelper attributes|
|2.2.2 Query RHPhelper Attributes|