HP Serviceguard Toolkit for Oracle Data Guard This uniquely identifies an ASE instance, Running

Models: Serviceguard Toolkit for Oracle Data Guard

1 140
Download 140 pages 15.58 Kb
Page 63
Image 63

Table 7 Sybase ASE attributes (continued)

Sybase ASE Attributes

Description

ASE_SERVER

Name of the Sybase ASE instance set during installation or configuration of the ASE.

 

This uniquely identifies an ASE instance

ALERT_MAIL ID

Sends an e-mail message to the specified e-mail address when packages fail. This e-mail

 

is generated only when packages fail, and not when a package is halted by the operator.

 

To send this e-mail message to multiple recipients, a group e-mail ID must be created

 

and specified for this parameter. When an e-mail ID is not specified for this parameter,

 

the script does not send out this e-mail

SALOGIN

ASE Login with system administrator capability

SAPASSWD

ASE Password for Login with system administrator capability.

 

NOTE: Along with other package attributes, the ASE password is also stored in the

 

Cluster Database. If users are not restricted access based on their roles, this password

 

can be viewed by unauthorized users using the cmviewcl command. It is highly

 

recommended to grant access to users based only on their roles in managing the cluster

 

and packages. See “Configuring Access Roles” (page 67) in this chapter for more

 

details on configuring Role Based Access (RBA).

ASE_RUNSCRIPT

Path of the script to start ASE instance.

USER_SHUTDOWN_MODE

This parameter is used to specify the instance shutdown mode only when a shutdown

 

is initiated by the user and not due to a failure of a service. This parameter can take

 

values "wait" or "nowait". If "wait" is specified, the instance is shutdown using the wait

 

option, which will be a clean shutdown. If "nowait" is specified, the instance is shutdown

 

using the nowait option. The default value is "wait".

MONITOR_INTERVAL

The interval of time, in seconds, which this script should wait between checks to ensure

 

of the Sybase database running. Default value is 30 seconds.

TIME_OUT

The interval of time, in seconds, to wait for Sybase abort to complete before killing the

 

Sybase processes defined in MONITOR_PROCESSES. The TIME_OUT variable is used

 

to protect against a worst case scenario where a hung database prevents the halt script

 

from completing, therefore preventing the standby node from starting the database. The

 

value of TIME_OUT must be less than the time-out set in the package configuration file.

 

TIME_OUT variable has no effect on package failover times. Default value is 30 seconds.

RECOVERY_TIMEOUT

The maximum amount of time in seconds to wait for an ASE to complete recovery before

 

determining that the server has failed to start up. This value must be set to allow enough

 

time for all the databases to recover and come online.

MONITOR_PROCESSES

The names of all processes that must be executing to ensure this instance is up and

 

running.

MAINTENANCE_FLAG

Maintenance flag will enable or disable the maintenance mode for the Sybase package.

 

By default this is set to "yes". In order to disable this feature, MAINTENANCE_FLAG

 

should be set to "no". If the Sybase ASE instance needs to be maintained, a file

 

$TKIT_DIR/sybase.debug needs to be touched. During this maintenance period

 

the Sybase ASE instance's monitoring is paused. Even if the ASE instance is brought

 

down, the package will not be failed over to the standby node. To continue monitoring

 

and come back from the maintenance mode, the sybase.debug file should be removed.

 

It is the user's responsibility to ensure that the ASE instance is running properly after the

 

maintenance phase.

Module Script (tkit_module.sh)

This script contains a list of internally used variables and functions that support the starting and stopping of an Sybase ASE database instance. This script is called by the Master Control Script to perform the following:

Setting up the Toolkit 63

Page 63
Image 63
HP Serviceguard Toolkit for Oracle Data Guard manual This uniquely identifies an ASE instance, Running, Maintenance phase