Modify the resource type registration file for resource SY.ase. This file is located in $SYBASE/$SYBASE_ASE/SC-3_0/etc/. Find the line for resource type property, RT_BASEDIR, which specifies the location of the Adaptive Server HA agent. Change the value to point to the installation location of $SYBASE/$SYBASE_ASE/SC-3_0/bin.
You cannot use environment variables in SY.ase or
the runserver files.
For example:
RT_BASEDIR=/sybase/ase-12_5/SC-3_0/bin/
Use the full path for this value. Substitute the value for SYBASE and SYBASE_ASE in $SYBASE/$SYBASE_ASE/SC-3_0/bin.
Create or edit a file that contains Adaptive Server login information for sa and the user you added for monitor. The default file is $SYBASE/$SYBASE_ASE/SC-3_0/etc/ase_login_file. If you use another file at a different location, specify the full path of this file for the resource extension property, Dataserver_login_file when configuring the SY.ase resource instance.
Create or edit ase_login_file for the Adaptive Server on each node of the cluster,
The file consists of two lines. The first line is the login and password for sa, the second line is the monitor user login and password as created in the section “Adding user and login for monitoring”..
login type <tab>login string login type<tab>login string
The valid value for login type is normal. Values for login string are in the form login-name/password. The default $SYBASE/$SYBASE_ASE/SC-3_0/etc/ase_login_file is:
normal<tab>sa/sa-password normal<tab>probe-user/probe-password
In either case, change the ase_login_file to use the correct user login information.
For security reasons, ase_login_file should
be securely protected and read and write access permission should
be restricted to root:
chmod 400 ase_login_file chown root ase_login_file chgrp sys ase_login_file
Install the SY.ase resource type. As root, run the following command on any node in the two-node cluster:
scrgadm -a -t SY.ase -f full-path-of-SY.ase-file
For example:
scrgadm -a -t SY.ase -f /sybase/ASE-12_5/SC-3_0/etc/SY.ase
Install the SY.ase resource type
only once per cluster. An error message displays if the resource
type is already installed.
Create a resource group that contains an SY.ase resource and a SUNW.HAStorage resource for the primary companion server:
scrgadm -a -g resource_group -y Nodelist=primary-node,secondary-node
For example:
scrgadm -a -g ase_rg1 -y Nodelist=node1,node2
Add the SUNW.HAStorage resource to the resource group:
scrgadm -a -j hastorage_name -g resource_group -t SUNW.HAStorage -x ServicePaths=shared-disk-storage-path
For example:
scrgadm -a -j MONEY1_storage -g ase_rg1 -t SUNW.HAStorage -x ServicePaths=/global/node1_share
You may create a SUNW.HAStoragePlus resource
if Sun Cluster 3.0 Update 3 is installed. See Sun Cluster
3.0, U3 Release Note for more details.
Add the SUNW.Logical Hostname resource to the resource group:
scrgadm -a -L -j loghost_resource -g resource_group
For example:
scrgadm -a -L -j MONEY1_lhost -g ase_rg1 -l loghosthost-node1
Add the SY.ase resource. Table 11-1 contains the extension properties for resource SY.ase:
Property |
Default |
Description |
|---|---|---|
Sybase_home |
None, but required property |
Home directory of the Adaptive Server installation, and the same as the value for the environment variable Sybase in an Adaptive Server installation. |
Environment_file |
Sybase_home/SYBASE.sh |
Full path to environment file under the Adaptive Server installation home directory, specified by environment variable SYBASE. |
Dataserver_name |
None, but required property. |
Name of the Adaptive Server data server that is supplied at the time of configuration. |
Backup_server_name |
None |
Name of the Backup Server that is supplied at the time of configuration. |
Monitor_server_name |
None |
Name of the Monitor Server that is supplied at the time of configuration. |
Text_server_name |
None |
Name of the full-text search server which is supplied at the time of configuration. |
Secondary_companion_name |
None |
Name of secondary companion server that is set when you run the sp_companion configure command. |
Dataserver_login_file |
None, but required property |
Absolute path to a file containing login information for current data server. The file consists of two lines; the first line is the login and password for sa and the second line is the user login and password used for the probe used by ase_monitor program. |
Action_file |
Sybase_home/ASE-12_5/SC-3_0/etc/ASE_monitor_action |
Absolute path to a file that associates error codes with actions to be taken by fault monitor. |
RUN_server_file |
Sybase_home/ASE-12_5/install/RUN_<Dataserver_name> |
Absolute path to an alternative RUN_server file, which overwrites the default $SYBASE/$SYBASE_ASE/install/RUN_SERVER |
Thorough_probe_script |
Reserved for future use |
Absolute path to a file containing SQL scripts for fault monitoring program to the probe.
|
Monitor_log |
Sybase_home/ASE-12_5/SC-3_0/log/ase_monitor_<Dataserver_name>.log |
Absolute path to log file used by Adaptive Server fault monitor program. |
Callback_log |
Sybase_home/ASE-12_5/SC-3_0/log/ase_calback_<Dataserver_name>.log |
Absolute path to log file used by Adaptive Server HA agent callback methods. |
Callback_log_max_size |
5000000 |
Maximum size for the callback log file. The default is 5000000 |
Monitor_log_max_size |
Reserved for future use |
Maximum size for the fault monitor log file. The default is 5000000.
|
Probe_timeout |
30 |
Time, in seconds, after which the fault monitoring probe times out and registers an error. |
Restart_delay |
30 |
Time, in seconds, to delay the next probe after a restart. |
Debug_monitor |
FALSE |
If TRUE, the fault monitor for the Adaptive Server HA agent logs debugging messages to the file specified by property Monitor_log. |
Debug_callback |
FALSE |
If TRUE, the callback methods for the Adaptive Server HA agent logs debugging messages to the file specified by property Callback_log. |
Connect_cycle_count |
5 |
The number of thorough probe cycles that an existing connection to Adaptive Server reuses before the connection is dropped and a new one is established. |
Failback_strategy |
Reserved for future use. |
Specify any standard resource property values and extension property values for SY.ase. You must specify the following three extension property values otherwise, the command fails: Sybase_home, Dataserver_name, and Dataserver_login_file. You may let other extension properties use default values. You may configure the following standard resource properties which are used by the HA agent fault monitor: Cheap_probe_interval, Thorough_probe_interval, Retry_count, and Retry_interval. To specify these properties with the scrgadm utility, use:
scrgadm -a -j ase_resource_name -g resource_group \ -t SY.ase \ -x Sybase_home=sybase_home_value \ -x Environment_file=environment_file_path \ -x Dataserver_name=dataserver_name_value \ -x Dataserver_login_file=login_file_path \ -x RUN_server_file=run_server_file_path
For example:
scrgadm -a -j MONEY1 -g ase_rg1 \ -t SY.ase \ -x Sybase_home=/sybase \ -x Environment_file=/sybase/SYBASE.sh \ -x Dataserver_name=MONEY1 \ -x Dataserver_login_file=/sybase/ASE-12_5/SC-3_0/etc/ase_login_file \ -x RUN_server_file=/sybase/ASE-12_5/install/RUN_MONEY1
For more information about the standard resource property, see the Sun Cluster 3.0 documentation.
Establish resource dependency between SY.ase resource and SUNW.HAStorage resource so SY.ase always depends on SUNW.HAStorage resource. This means SY.ase is online only if the SUNW.HAStorage is online, and SY.ase is offline before SUNW.HAStorage is offline:
scrgadm -c -j ase-resource-name -y Resource_dependencies=hastorage-name
For example:
scrgadm -c -j MONEY1 -y Resource_dependencies=MONEY1_storage
Run the SCSwitch command to complete the following tasks:
Enable all resources and their monitor.
Move the resource group into a managed state.
Bring the resource group online on the default primary node:
scswitch -Z -g resource_group_name
For example:
scswitch -Z -g ase_rg1
