Oracle® Solaris Cluster Data Service for Sybase ASE Guide

Exit Print View

 
Updated: July 2014, E39577–01
 
 

HA for Sybase ASE Extension Properties

For details about system-defined properties, see the r_properties (5) man page and the rg_properties (5) man page.

The SUNW.sybase resource type represents the Sybase ASE application in a Oracle Solaris Cluster configuration. The extension properties of this resource type are as follows:

Adaptive_Server_Log_ File

The absolute path to the log file for the adaptive server. HA for Sybase ASE continually reads this property for error monitoring.

Default: None

Range: Minimum=1

Tunable: When disabled

Adaptive_Server_Name

The name of the data server. HA for Sybase ASE uses this property to locate the runserver file for Adaptive Server. The file is named RUN_Adaptive-Server-name and is located in the $SYBASE/$SYBASE_ASE/install directory.

Default: None

Range: Minimum=1

Tunable: When disabled

Backup_Server_Name

The name of the backup server. HA for Sybase ASE uses this property to locate the runserver file for the backup server. The file is named RUN_backup-server-name and is located in the $SYBASE/$SYBASE_ASE/install directory. If you do not set this property, HA for Sybase ASE will not manage the server.

Default: Null

Range: None

Tunable: When disabled

Connect_cycle

Number of fault-monitor probe cycles before HA for Sybase ASE establishes a new connection.

Default: 5

Range: 1 – 100

Tunable: Any time

Connect_string

String of format userid/password, which specifies the database user's user ID and password. HA for Sybase ASE uses this property for database probes. When you set up the HA for Sybase ASE data service, define the database user ID and password before you enable the server resource and the server resource's fault monitor. Do not use the sa account for the database user. You must set this property, even if you do not set the Monitor_Server_Name property.

Default: None

Range: Minimum=1

Tunable: Any time

DB_Wait_List

List of databases that need to be online before the resource can be brought online.

Default: Null

Range: None

Tunable: Any time

Debug_level

Debug level for writing to the HA for Sybase ASE log.

Default:1

Range: 0 – 100

Tunable: Any time

Environment_File

Absolute path to the file that contains all of the Sybase ASE environment variables. HA for Sybase ASE requires that you define the variables SYBASE, SYBASE_ASE, and SYBASE_OCS. Other variables that you define are passed as environment variables to the Sybase server.

The definition of each environment variable must conform to the following format:

variable=value

Each environment variable that you define must also be specified, one per line in the Environment_File.

Typically, users use the SYBASE.sh environment file that is created by the Sybase installation in the $SYBASE directory.

Note -  The value of this property is independent of the shell that is being used by the sybase user. Specifically, the sybase user can have csh as its default shell.

Default: None

Range: Minimum=1

Tunable: When disabled

Monitor_Server_Name

The name of the monitor server. HA for Sybase ASE uses this property to locate the runserver file in the $SYBASE/$SYBASE_ASE/install directory. If you do not set this property, HA for Sybase ASE will not manage the server.

Default: Null

Range: None

Tunable: When disabled

Probe_timeout

The time after which the fault monitoring probe will time out and register a timeout error while probing the ASE DBMS.

Default: 60 seconds

Range: 1 – 99999 seconds

Tunable: Any time

Stop_File

The absolute path to the script that the STOP method executes to stop the Sybase ASE servers. This file stores the password of the Sybase ASE system administrator (sa). Protect the path so that only the user and group that are associated with the Sybase ASE installation can access the file. The HA for Sybase ASE package includes the sybase_stop_servers template. You must replace the existing password.

Default: None

Range: Minimum=1

Tunable: Any time

Text_Server_Name

The name of the text server. The HA for Sybase ASE data service uses this property to locate the runserver file in the $SYBASE/$SYBASE_ASE/install directory. If you do not set this property, the HA for Sybase ASE data service will not manage the server.

Default: Null

Range: None

Tunable: When disabled

Wait_for_online

Whether the START method waits for the database to be brought online before exiting.

Default: TRUE

Range: TRUE – FALSE

Tunable: Any time

Restart_type

When a fault with the resource is detected, the RESOURCE_RESTART value will ensure that only this resource is restarted. A value of RESOURCE_GROUP_RESTART will ensure that all resources in the resource group are restarted.

Default: RESOURCE_RESTART

Range: RESOURCE_RESTART – RESOURCE_GROUP_RESTART

Tunable: Any time

Custom_action_file

This file contains the custom fault monitor actions.

Default: None

Range: None

Tunable: Any time

Preset actions for DBMS errors and Sybase ASE logged alerts are listed as follows:

  • DBMS errors for which an action is preset are listed in Table A–1.

  • Logged alerts for which an action is preset are listed in Table A–2.

Table A-1  Preset Actions for DBMS Errors
Error Number
Action
Connection State
New State
Message
601
RESTART
*
*
Descriptor for system table in database not found in the descriptor hash table.
605
RESTART
*
co
Attempt to fetch logical page in database belongs to different object. See errorlog file for further details.
623
RESTART
on
*
Attempt to retrieve row from page via RID failed because logical page is not a data page.
706
RESTART
on
*
Process tried to remove PROC_HDR that it does not hold in Pss.
707
RESTART
on
*
System error detected during attempt to free memory at address ox%1x. See errorlog file for further details.
803
RESTART
on
*
Unable to place buffer holding logical page in sdes. See errorlog file for further details.
804
RESTART
on
co
Unable to find buffer holding logical page in sdes.
806
RESTART
on
co
Could not find virtual page for logical page %ld in database '%S_DBID'.
813
NONE
on
co
Logical page in database is already hashed. See errorlog file for further details.
821
RESTART
on
co
Attempt to unhash buffer. See errorlog file for further details.
822
SWITCH
*
*
Could not start I/O for request BLKIO. See errorlog file for further details.
823
STOP
*
*
I/O error detected during %S_MSG for %S_BUF.
921
NONE
*
*
Database has not recovered yet.
945
RESTART
on
co
Function %s was asked to locate page in database.
1207
RESTART
on
co
Locksleep called with bad process id. See errorlog file for further details.
1265
RESTART
on
*
A lock manager routine expected a lock record as an argument but was passed something else.
1509
STOP
on
*
Row compare failure.
1510
STOP
on
*
Sort failed: Out of space in database.
1602
STOP
on
*
Unable to initialize network.
1605
STOP
on
*
Failed to open virtual socket for new connections.
1813
RESTART
on
*
Cannot open new database. CREATE DATABASE is aborted.
3002
RESTART
on
co
DUMP DATABASE for database '%.*' failed to remove alarm with ID = %d. See errorlog file for further details.
3307
RESTART
on
co
Process %d was expected to hold logical lock on page %ld. See errorlog file for further details.
4002
NONE
*
co
Login failed. Please check fault monitor user id and password specified in the CONNECT_STRING property
4067
NONE
*
co
Login failed. Please check fault monitor user id and password specified in the CONNECT_STRING property
6902
SWITCH
on
co
Page timestamp value falls between the old and new timestamps from log.
7409
SWITCH
on
*
This task tried to sleep waitng for space to become available in the log, but could not.
7410
SWITCH
on
*
Function called with invalid argument. See errorlog file for further details.
7412
RESTART
on
*
Space available in the log segment has fallen critically low in database.
7413
RESTART
on
*
Task(s) are sleeping, waiting for space to become available in the log segment for database.
8201
RESTART
on
*
Keep count of descriptor was expected to be %d. Instead %d was found.
8203
RESTART
on
*
Expected to find the descriptor in %s state.
8204
STOP
on
*
Expected to receive system catalog id.
8211
RESTART
on
*
Mismatch found between the name and id descriptor hash table.
8704
RESTART
on
*
Could not get the address lock.
17716
RESTART
on
*
Could not update the last-chance threshold for database"; }
16843058
NONE
*
co
Connection broken.
16843175
NONE
*
co
Error in performing requested operation
33620275
NONE
*
co
Error in performing requested operation
84083972
RESTART
*
co
Server is not up, restarting
84083974
NONE
*
co
Server is recovering
Table A-2  Preset Actions for Sybase ASE Alerts
Alert String
Action
Connection State
New State
Message
server: Buffer
STOP
on
co
server error
kistartup: could
RESTART
*
co
kistartup: could not create shared memory
Kernel: current
NONE
*
co
Kernel: current process infected with %d
kernel: dstart I/O
STOP
*
*
kernel: dstart I/O request repeatedly delayed; block number: %ld, vdn: %ld. See errorlog file for further details
basis_dlock:
STOP
*
*
basis_dlock: file '%s' already in use by a SQL Server
Physical memory
STOP
*
*
Physical memory on this machine might be too fragmented
server: Warning:
NONE
*
co
OPEN OBJECTS parameter might be too low; attempt was made to free up descriptor in desfree(). Run sp_configure to increase parameter value.
kernel: write
STOP
*
*
kernel: write error on virtual disk %d, block %ld. See errorlog file for further details
kernel: read
STOP
*
*
kernel: read error on virtual disk %d, block %ld. See errorlog file for further details
Stack Guardword
SWITCH
*
*
kernel: *** Stack Guardword corrupted
Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices
Previous
Next