Registering and Configuring Solaris Cluster HA for Sybase ASE

Register and configure Solaris Cluster HA for Sybase ASE as a failover data service.

Setting Solaris Cluster HA for Sybase ASE Extension Properties

The section that follows contains instructions for registering and configuring resources. These instructions explain how to set only extension properties that Solaris Cluster HA for Sybase ASE requires you to set. For information about all Solaris Cluster HA for Sybase ASE extension properties, see Appendix A, Solaris Cluster HA for Sybase ASE Extension Properties. You can update some extension properties dynamically. You can update other properties, however, only when you create or disable a resource. The Tunable entry indicates when you can update a property.

To set an extension property of a resource, include the following option in the clresource(1CL) command that creates or modifies the resource:

-p property=value 

-p property

Identifies the extension property that you are setting

value

Specifies the value to which you are setting the extension property

You can also use the procedures in Chapter 2, Administering Data Service Resources, in Oracle Solaris Cluster Data Services Planning and Administration Guide to configure resources after the resources are created.

How to Register and Configure Solaris Cluster HA for Sybase ASE

This procedure describes how to use the Oracle Solaris Cluster maintenance commands to register and configure Solaris Cluster HA for Sybase ASE.

This procedure includes creating the SUNW.HAStoragePlus resource type. This resource type synchronizes actions between HAStorage and Solaris Cluster HA for Sybase ASE and enables you to use a highly available local file system. Solaris Cluster HA for Sybase ASE is disk intensive, and therefore you should configure the SUNW.HAStoragePlus resource type.

For more information about the SUNW.HAStoragePlus resource type, see the following documentation:

• SUNW.HAStoragePlus(5) man page

• Relationship Between Resource Groups and Device Groups in Oracle Solaris Cluster Data Services Planning and Administration Guide

To perform this procedure, you must have the following information.

• The names of the cluster nodes or zones that master the data service.

• The network resource that clients use to access the data service. You typically configure the IP address when you install the cluster. For information about planning the Oracle Solaris Cluster environment and the installation of the Solaris software, see Chapter 1, Planning the Oracle Solaris Cluster Configuration, in Oracle Solaris Cluster Software Installation Guide.

• The path to the Sybase ASE application installation.

1. On a cluster node or zone, become superuser or assume a role that provides solaris.cluster.modify and solaris.cluster.admin RBAC authorizations.
2. Run the clresourcetype command to register resource types for Solaris Cluster HA for Sybase ASE.

   # clresourcetype register SUNW.sybase

3. Register the SUNW.HAStoragePlus resource type with the cluster.

   # clresourcetype register SUNW.HAStoragePlus

4. Create the resource sybase-hastp-rs of type SUNW.HAStoragePlus.

   # clresource create -g sybase-rg -t SUNW.HAStoragePlus \
   -p GlobalDevicePaths=sybase-device-group1,/dev/global/dsk/dl \
   -p FilesystemMountPoints=/global/sybase-inst \
   -p AffinityOn=TRUE sybase-hastp-rs

   The resource is created in the enabled state.

   ---

   Note - AffinityOn must be set to TRUE and the local file system must reside on global disk groups to be failover.

   ---

5. Run the clresourcegroup command to complete the following tasks and bring the resource group sybase-rg online on a cluster node or zone.

   • Moving the resource group into a managed state

   • Bringing the resource group online

   This node becomes the primary for device group sybase-set1 and raw device /dev/global/dsk/d1. Device groups that are associated with file systems such as /global/sybase-inst are also made primaries on this node.

   # clresourcegroup online -M sybase-rg

6. Create Sybase ASE application resources in the failover resource group.

   # clresource create -g resource-group \
   -t SUNW.sybase \
   -p Environment_File=environment-file-path \
   -p Adaptive_Server_Name=adaptive-server-name \
   -p Backup_Server_Name=backup-server-name \
   -p Text_Server_Name=text-server-name \
   -p Monitor_Server_Name=monitor-server-name \
   -p Adaptive_Server_Log_File=log-file-path \
   -p Stop_File=stop-file-path \
   -p Connect_string=user/passwd \
   -p resource_dependencies=storageplus-resource \
   -p Wait_for_Online=TRUE \
   -p DB_Wait_List=db1, db2, ... \
   -p Restart_type=RESOURCE_RESTART|RESOURCE_GROUP_RESTART \
   -p Custom_action_file=filepath resource

   -g resource-group

   Specifies the resource group name into which the RGM places the resources.

   -t SUNW.sybase

   Specifies the resource type to add.

   -p Environment_File=environment-file

   Sets the name of the environment file.

   -p Adaptive_Server_Name=adaptive-server-name

   Sets the name of the adaptive server.

   -p Backup_Server_Name=backup-server-name

   Sets the name of the backup server.

   -p Text_Server_Name=text-server-name

   Sets the name of the text server.

   -p Monitor_Server_Name=monitor-server-name

   Sets the name of the monitor server.

   -p Adaptive_Server_Log_File=log-file-path

   Sets the path to the log file for the adaptive server.

   -p Stop_File=stop-file-path

   Sets the path to the stop file.

   -p Connect_string=user/passwd

   Specifies the user name and password that the fault monitor uses to connect to the database.

   -p Wait_for_Online=TRUE

   Specifies whether the START method has to wait for the database to be brought online before exiting.

   -p DB_Wait_List=db1, db2, ...

   Specifies the list of databases that need to be online before the resource can be brought online. The valid values are either an empty list (“ ”), ALL, or a list of databases.

   -p Restart_type=RESOURCE_RESTART|RESOURCE_GROUP_RESTART

   Defines the restart behavior of the resource. If the Restart_type extension property is set to RESOURCE_RESTART, the server fault monitor restarts the database server resource. If the Restart_type extension property is set to RESOURCE_GROUP_RESTART, the server fault monitor restarts the database server resource group. This property was introduced in SUNW.sybase resource type version 5. Prior to and including SUNW.sybase resource type version 5, the server fault monitor restarted the database server resource group.

   -p Custom_action_file=filepath

   Sets the path to the custom action file that contains the custom fault monitor actions.

   resource

   Specifies the resource name to add.

   The resource is created in the enabled state.

   You do not have to specify extension properties that have default values. For more information, see Setting Solaris Cluster HA for Sybase ASE Extension Properties.

Next Steps

After you register and configure Solaris Cluster HA for Sybase ASE, go to Verifying the Solaris Cluster HA for Sybase ASE Installation and Configuration.