Cluster Server 7.3.1 Agent for Oracle Installation and Configuration Guide - Solaris
- Introducing the Cluster Server agent for Oracle
- About the Cluster Server agent for Oracle
- How the agent makes Oracle highly available
- About Cluster Server agent functions for Oracle
- Oracle agent functions
- How the Oracle agent supports health check monitoring
- ASMInst agent functions
- Oracle agent functions
- Installing and configuring Oracle
- About VCS requirements for installing Oracle
- About Oracle installation tasks for VCS
- Installing ASM binaries for Oracle 11gR2 or 12c in a VCS environment
- Configuring Oracle ASM on the first node of the cluster
- Installing Oracle binaries on the first node of the cluster
- Installing and removing the agent for Oracle
- Configuring VCS service groups for Oracle
- Configuring Oracle instances in VCS
- Before you configure the VCS service group for Oracle
- Configuring the VCS service group for Oracle
- Setting up detail monitoring for VCS agents for Oracle
- Enabling and disabling intelligent resource monitoring for agents manually
- Administering VCS service groups for Oracle
- Pluggable database (PDB) migration
- Troubleshooting Cluster Server agent for Oracle
- Verifying the Oracle health check binaries and intentional offline for an instance of Oracle
- Appendix A. Resource type definitions
- Appendix B. Sample configurations
- Sample single Oracle instance configuration
- Sample multiple Oracle instances (single listener) configuration
- Sample multiple instance (multiple listeners) configuration
- Sample Oracle configuration with shared server support
- Sample configuration for Oracle instances in Solaris zones
- Sample Oracle ASM configurations
- Appendix C. Best practices
- Appendix D. Using the SPFILE in a VCS cluster for Oracle
- Appendix E. OHASD in a single instance database environment
Configuring VCS to support Oracle Restart function
To ensure that VCS supports the Oracle Restart feature, the user needs to tune the VCS parameters so that it does not attempt a failover action when the Oracle grid infrastructure attempts to restart the resources on the same node. For VCS to take correct decision, the ToleranceLimit resource attribute needs to be tuned accordingly.
Oracle Restart feature uses the CHECK_INTERVAL and RESTART_ATTEMPTS attributes to determine the monitoring interval and restart attempts if the resources are unavailable.
For example, when ASM instance becomes unavailable on a node, the grid infrastructure tries to restart the ASM resource, however VCS detects that the application is unavailable and reports the resource as faulted and tries to failover the service group to another cluster node. To avoid such scenarios, we need to ensure that the VCS policies do not take effect until Oracle completes performing its functions.
You need to modify the VCS resource ToleranceLimit attribute such that ToleranceLimit * MonitorInterval is greater than (CHECK_INTERVAL *RESTART_ATTEMPTS) + MonitorInterval .
If Oracle's attribute values for ASM resource is CHECK_INTERVAL = 1 (in seconds) and RESTART_ATTEMPTS = 5 (no of restart attempts), and the VCS configuration values for the ASMInst resource has MonitorInterval set to 60, then set the ToleranceLimit to 2 based on the below calculations,
2 (ToleranceLimit) * 60 (MonitorInterval) = 120 1 (CHECK_INTERVAL) * 5 (RESTART_ATTEMPTS) + 60 (MonitorInterval) = 65
The following commands can be used to set the Attribute ToleranceLimit :
# hares -override <resource name> ToleranceLimit
# hares - modify <resource name> ToleranceLimit 2
Note:
Tune the ToleranceLimit value for Oracle applications such as ASM, ASM Diskgroup, Oracle Database, and Oracle netlistner, that are configured with both Oracle Restart feature and VCS.