Sun Cluster Data Service for SAP DB Guide for Solaris OS

Verifying the Sun Cluster HA for SAP DB Installation and Configuration

After you install, register, and configure Sun Cluster HA for SAP DB, verify the Sun Cluster HA for SAP DB installation and configuration. Verifying the Sun Cluster HA for SAP DB installation and configuration determines if the Sun Cluster HA for SAP DB data service makes the SAP DB application highly available.

Verifying the Sun Cluster HA for SAP DB installation involves verifying the operation of the following fault monitors:

How to Verify the Operation of the SAP DB Fault Monitor

Perform this procedure on each node where SAP DB can run.

  1. Log in as superuser to a node that can master the SAP DB resource group.

  2. Switch the SAP DB resource group to the node that you logged in to in Step 1.


    # scswitch -z -g sapdb-rg -h node
    
    -z

    Specifies that the node that masters a resource group is to be switched

    -g sapdb-rg

    Specifies that the SAP DB resource group is to be switched to another node

    -h node

    Specifies the node to which the SAP DB resource group is to be switched

  3. Abnormally terminate SAP DB.

    1. Determine the process identities of all kernel processes for the SAP DB database instance that you are running.


      # ps -ef | grep kernel | grep db-name
      
      db-name

      Specifies the name of the SAP DB database instance in uppercase

    2. Kill all kernel processes for the SAP DB database instance that you are running.


      # kill -9 sapdb-kernel-pid
      
      sapdb-kernel-pid

      Specifies the process identities of the SAP DB kernel processes that you determined in Step a

  4. Confirm that the Sun Cluster HA for SAP DB fault monitor performs the appropriate operation from the following list:

    • Restarting the SAP DB resource

    • Failing over the SAP DB resource to another node

    The expected behavior of the fault monitor depends on the failure history of the resource and the value of the Failover_enabled extension property. For more information, see the following sections:

  5. Terminate SAP DB normally.

    1. Become the OS user who administers the SAP DB database.


      # su - os-sapdb-adm-user
      
      os-sapdb-adm-user

      Specifies the UNIX user identity of the OS user who administers the SAP DB database. This user's home directory contains the .XUSER.62 file that was created during the installation and configuration of SAP DB. For more information, see Installing and Configuring SAP DB. You specify this user when you set the DB_User extension property as explained in How to Register and Configure an SAP DB Resource.

    2. Manually stop the SAP DB database instance.


      # dbmcli -U sapdb-adm-key db_offline
      
      -U sapdb-adm-key

      Specifies that the dbmcli command is run with the user key of the database user who administers the SAP DB database. This user key is created during the installation and configuration of SAP DB. For more information, see Installing and Configuring SAP DB. You specify this user key when you set the User_Key extension property as explained in How to Register and Configure an SAP DB Resource.

  6. Confirm that the Sun Cluster HA for SAP DB fault monitor performs the appropriate operation from the following list:

    • Restarting the SAP DB resource

    • Failing over the SAP DB resource to another node

    The expected behavior of the fault monitor depends on the failure history of the resource and the value of the Failover_enabled extension property. For more information, see the following sections:

How to Verify the Operation of the SAP xserver Fault Monitor

Perform this procedure on each node that can master SAP xserver.

  1. Log in to a node that can master SAP xserver.

  2. Abnormally terminate SAP xserver.

    1. Determine the process identities of all SAP xserver processes.


      # ps -ef | grep vserver
      
    2. Kill all SAP xserver processes.


      # kill -9 xserver-pid
      
      xserver-pid

      Specifies the process identities of the SAP xserver processes that you determined in Step a

  3. Confirm that the SAP xserver fault monitor restarts the SAP xserver resource.

  4. Terminate SAP xserver normally.

    1. Become the OS user who administers SAP xserver.


      # su - os-sapxsrvr-adm-user
      
      os-sapxsrvr-adm-user

      Specifies the UNIX user identity of the OS user who administers SAP xserver. By default, this user is root. You can specify this user by setting the Xserver_User extension property. For more information, see SUNW.sap_xserver Extension Properties.

    2. Manually stop the SAP xserver.


      # x_server stop
      
  5. Confirm that the SAP xserver fault monitor restarts the SAP xserver resource.