Provided by: resource-agents_4.2.0-1ubuntu2_amd64 bug

NAME

       ocf_heartbeat_SAPDatabase - Manages a SAP database instance as an HA resource.

SYNOPSIS

       SAPDatabase [start | stop | status | monitor | meta-data | validate-all]

DESCRIPTION

       Resource script for SAP databases. It manages a SAP database of any type as an HA
       resource.

       The purpose of the resource agent is to start, stop and monitor the database instance of a
       SAP system. Together with the RDBMS system it will also control the related network
       service for the database. Like the Oracle Listener and the xserver of MaxDB. The resource
       agent expects a standard SAP installation of the database and therefore needs less
       parameters to configure. The resource agent supports the following databases:

       - Oracle 10.2, 11.2 and 12

       - DB/2 UDB for Windows and Unix 9.x

       - SAP-DB / MaxDB 7.x

       - Sybase ASE 15.7

       - SAP HANA Database since 1.00 - with SAP note 1625203 (http://sdn.sap.com)

       In fact this resource agent does not run any database commands directly. It uses the SAP
       standard process SAPHostAgent to control the database. The SAPHostAgent must be installed
       on each cluster node locally. It will not work, if you try to run the SAPHostAgent also as
       a HA resource. Please follow SAP note 1031096 for the installation of SAPHostAgent. The
       required minimum version of SAPHostAgent is: Release: 7.20 Patch Number: 90 or compile
       time after: Dec 17 2011

       A single HANA is managed as a primitive resource by the SAPDatabase RA. Therefor the
       parameter MONITOR_SERVICES has to match the output service names of the command
       "sapcontrol -nr $InstNr -function GetProcessList". "$InstNr" has to be replaced by the
       respective instance number.

       For an HANA database with SID "TST" and instance number "10", the resource configuration
       looks like: primitive rsc_SAPDatabase_TST_HDB10 ocf:heartbeat:SAPDatabase \ params
       DBTYPE="HDB" SID="TST" \ MONITOR_SERVICES="hdbindexserver|hdbnameserver" \ op start
       interval="0" timeout="3600" \ op monitor interval="120" timeout="700" \ op stop
       interval="0" timeout="600"

SUPPORTED PARAMETERS

       SID
           The unique database system identifier. e.g. P01

           (unique, required, string, no default)

       DIR_EXECUTABLE
           The full qualified path where to find saphostexec and saphostctrl. Usually you can
           leave this empty. Then the default: /usr/sap/hostctrl/exe is used.

           (optional, string, default "/usr/sap/hostctrl/exe")

       DBTYPE
           The name of the database vendor you use. Set either: ADA, DB6, ORA, SYB, HDB

           (required, string, no default)

       DBINSTANCE
           Must be used for special database implementations, when database instance name is not
           equal to the SID (e.g. Oracle DataGuard)

           (unique, optional, string, no default)

       DBOSUSER
           The parameter can be set, if the database processes on operating system level are not
           executed with the default user of the used database type. Defaults: ADA=taken from
           /etc/opt/sdb, DB6=db2SID, ORA=oraSID and oracle, SYB=sybSID, HDB=SIDadm

           (unique, optional, string, no default)

       NETSERVICENAME
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, string, no default)

       DBJ2EE_ONLY
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, boolean, default false)

       JAVA_HOME
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, string, no default)

       STRICT_MONITORING
           This controls how the resource agent monitors the database. If set to true, it will
           use 'saphostctrl -function GetDatabaseStatus' to test the database state. If set to
           false, only operating system processes are monitored.

           (optional, boolean, default false)

       AUTOMATIC_RECOVER
           If you set this to true, 'saphostctrl -function StartDatabase' will always be called
           with the '-force' option.

           (optional, boolean, default false)

       MONITOR_SERVICES
           Defines which services are monitored by the SAPDatabase resource agent. Service names
           must correspond with the output of the 'saphostctrl -function GetDatabaseStatus'
           command. The default value is derived from the database type DBTYPE. For example,
           DBTYPE "ORA" sets MONITOR_SERVICES="Instance|Database|Listener".

           (optional, string, no default)

       DIR_BOOTSTRAP
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, string, no default)

       DIR_SECSTORE
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, string, no default)

       DB_JARS
           Deprecated - do not use anymore. This parameter will be deleted in one of the next
           releases.

           (optional, string, no default)

       PRE_START_USEREXIT
           The full qualified path where to find a script or program which should be executed
           before this resource gets started.

           (optional, string, no default)

       POST_START_USEREXIT
           The full qualified path where to find a script or program which should be executed
           after this resource got started.

           (optional, string, no default)

       PRE_STOP_USEREXIT
           The full qualified path where to find a script or program which should be executed
           before this resource gets stopped.

           (optional, string, no default)

       POST_STOP_USEREXIT
           The full qualified path where to find a script or program which should be executed
           after this resource got stopped.

           (optional, string, no default)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
           Starts the resource. Suggested minimum timeout: 1800s.

       stop
           Stops the resource. Suggested minimum timeout: 1800s.

       status
           Performs a status check. Suggested minimum timeout: 60s.

       monitor
           Performs a detailed status check. Suggested minimum timeout: 60s. Suggested interval:
           120s.

       validate-all
           Performs a validation of the resource configuration. Suggested minimum timeout: 5s.

       meta-data
           Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s.

       methods
           Suggested minimum timeout: 5s.

EXAMPLE CRM SHELL

       The following is an example configuration for a SAPDatabase resource using the crm(8)
       shell:

           primitive p_SAPDatabase ocf:heartbeat:SAPDatabase \
             params \
               SID=string \
               DBTYPE=string \
             op monitor depth="0" timeout="60s" interval="120s"

EXAMPLE PCS

       The following is an example configuration for a SAPDatabase resource using pcs(8)

           pcs resource create p_SAPDatabase ocf:heartbeat:SAPDatabase \
             SID=string \
             DBTYPE=string \
             op monitor depth="0" timeout="60s" interval="120s"

SEE ALSO

       http://clusterlabs.org/

AUTHOR

       ClusterLabs contributors (see the resource agent source for information about individual
       authors)