Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Sybase ASE Guide Oracle Solaris Cluster |
1. Installing and Configuring Solaris Cluster HA for Sybase ASE
Solaris Cluster HA for Sybase ASE Overview
Overview of Installing and Configuring Solaris Cluster HA for Sybase ASE
Preparing to Install Solaris Cluster HA for Sybase ASE
Installing the Sybase ASE Software
How to Prepare the Nodes for the Installation of the Sybase ASE Software
How to Install the Sybase ASE Software
How to Verify the Sybase ASE Installation
Configuring Sybase ASE Database Access and Creating the Sybase ASE Database Environment
How to Configure Sybase ASE Database Access With Solaris Volume Manager
How to Configure Sybase ASE Database Access With Veritas Volume Manager
How to Create the Sybase ASE Database Environment
Installing the Solaris Cluster HA for Sybase ASE Packages
How to Install the Solaris Cluster HA for Sybase ASE Packages
Registering and Configuring Solaris Cluster HA for Sybase ASE
Setting Solaris Cluster HA for Sybase ASE Extension Properties
How to Register and Configure Solaris Cluster HA for Sybase ASE
Verifying the Solaris Cluster HA for Sybase ASE Installation and Configuration
How to Verify the Solaris Cluster HA for Sybase ASE Installation and Configuration
Location of Solaris Cluster HA for Sybase ASE Log Files
Solaris Cluster HA for Sybase ASE Logging and Security Issues
Solaris Cluster HA for Sybase ASE Logging Issues
Solaris Cluster HA for Sybase ASE Security Issues
Customizing the Solaris Cluster HA for Sybase ASE Fault Monitor
Defining Custom Behavior for Errors
Changing the Response to a DBMS Error
Responding to an Error Whose Effects Are Major
Ignoring an Error Whose Effects Are Minor
Changing the Response to Logged Alerts
Changing the Maximum Number of Consecutive Timed-Out Probes
Propagating a Custom Action File to All Nodes in a Cluster
Specifying the Custom Action File That a Server Fault Monitor Should Use
How to Specify the Custom Action File That a Server Fault Monitor Should Use
A. Solaris Cluster HA for Sybase ASE Extension Properties
B. Preset Actions for DBMS Errors and Sybase ASE Logged Alerts
The Solaris Cluster HA for Sybase ASE fault monitor queries the Sybase ASE server to determine server health.
Note - The Solaris Cluster HA for Sybase ASE fault monitor monitors only the Adaptive server. The fault monitor does not monitor auxiliary servers.
The Solaris Cluster HA for Sybase ASE fault monitor is contained in the resource that represents Sybase ASE. You create this resource when you register and configure Solaris Cluster HA for Sybase ASE. For more information, see Registering and Configuring Solaris Cluster HA for Sybase ASE.
System properties and extension properties of this resource control the behavior of the fault monitor. The default values of these properties determine the preset behavior of the fault monitor. The preset behavior should be suitable for most Oracle Solaris Cluster installations. Therefore, you should tune the Solaris Cluster HA for Sybase ASE fault monitor only if you need to modify this preset behavior.
Tuning the Solaris Cluster HA for Sybase ASE fault monitor involves the following tasks:
Setting the interval between fault monitor probes
Setting the timeout for fault monitor probes
Defining the criteria for persistent faults
Specifying the failover behavior of a resource
Perform these tasks when you register and configure Solaris Cluster HA for Sybase ASE. For more information, see the following sections:
The Solaris Cluster HA for Sybase ASE fault monitor consists of the following processes.
Main fault-monitor process
Database-client fault probe
The fault monitor process diagnoses errors and checks statistics. The monitor labels an operation successful if the following conditions occur.
The database is online.
The activity check returns no errors.
The test transaction returns no errors.
If an operation fails, the main process checks the action table for an action to perform and then performs the predetermined action. If an operation fails, the main process can perform the following actions.
Restarting the resource on the current node
Restarting the resource group on the current node
Failing over the resource group to the next node on the resource group's node list
These actions execute external programs as separate processes in the background.
The server fault monitor also scans the Adaptive_Server_Log file and corrects any errors that the scan identifies.
The database-client fault probe performs activity checks and test transactions. The extension property Connect_string specifies an account that performs all of the database operations. The extension property Probe_timeout sets the time-out value that the probe uses to determine the time that has elapsed in a successful database probe.
To facilitate troubleshooting of unexplained DBMS timeouts, you can enable the fault monitor to create a core file when a probe timeout occurs. The contents of the core file relate to the fault monitor process. The fault monitor creates the core file in the / directory. To enable the fault monitor to create a core file, use the coreadm command to enable set-id core dumps. For more information, see the coreadm(1M) man page.