SAP HANA (Single-Node Deployment Without High Availability Required)

Prerequisites

Ensure that Application Operations Management (AOM) ICAgent has been installed.

• AOM ICAgent is used to collect host OS metrics, such as CPU, memory, and disk. If it has not been installed, install it by referring to Installing an ICAgent.

Procedure

Installing and Configuring the Monitoring Agent

1. Run the following commands to obtain the installation script to install the monitoring agent:

   cd /tmp

   The download paths of the script vary depending on regions. For details about how to obtain the path, see Table 1. The following commands show the download path in AP-Bangkok.

   cd /tmp

   curl https://obs-sap-ap-southeast-2.obs.ap-southeast-2.myhuaweicloud.com/sapmon/install.sh | sh

   Table 1 Links to obtain the installation script

   Script Name	Description	Download Link
   install.sh	Installation script	AP-Bangkok: https://obs-sap-ap-southeast-2.obs.ap-southeast-2.myhuaweicloud.com/sapmon/install.sh AP-Singapore: https://obs-sap-ap-southeast-3.obs.ap-southeast-3.myhuaweicloud.com/sapmon/install.sh CN-Hong Kong: https://obs-sap-ap-southeast-1.obs.ap-southeast-1.myhuaweicloud.com/sapmon/install.sh SA-Johannesburg: https://obs-sap-af-south-1.obs.af-south-1.myhuaweicloud.com/sapmon/install.sh TR-Istanbul: https://obs-sap-tr-west-1.obs.tr-west-1.myhuaweicloud.com/sapmon/install.sh LA-Santiago: https://obs-sap-la-south-2.obs.la-south-2.myhuaweicloud.com/sapmon/install.sh LA-Sao Paulo1: https://obs-sap-sa-brazil-11.obs.sa-brazil-1.myhuaweicloud.com/sapmon/install.sh LA-Mexico City1: https://obs-sap-na-mexico-1.obs.na-mexico-1.myhuaweicloud.com/sapmon/install.sh LA-Mexico City2: https://obs-sap-la-north-2.obs.la-north-2.myhuaweicloud.com/sapmon/install.sh

2. Modify the configuration.
   1. Run the following command to encrypt the password:

      /usr/local/sapmon/bin/ktool -e

   2. Enter the password.
   3. Run the following command to modify the configuration file:

      vim /usr/local/sapmon/config/sapmon.ini

      Table 2 lists the parameters. Set the parameters based on the actual situation. Change the password to the encrypted password obtained in 2.a.

      Table 2 Configuration parameters

      Type	Name	Description	Example Value
      DEFAULT	log_level	Log level	INFO
      	log_file	Log file name. The log file path is /var/log/huawei/sapmon/.	sap_metrics.log
      	hostname	OS hostname	hana-1709
      database.hana	enable	Whether to obtain database metrics. The value can be true or false. NOTE: In the SAP HANA (single-node deployment with high availability required) scenario, the parameter is set to true for the active node and to false for the standby node.	true
      	ha_mode	Whether the database is deployed in high availability (HA) mode. If yes, set this parameter to true. If no, set it to false.	false
      	sid	Database SID	S00
      	instance_number	Database instance number	00
      	tenant_database_name	Name of the tenant database. This parameter is used in the multi-tenant scenario. If the HANA database is for single tenant, you do not need to set this parameter. If the HANA database is for multiple tenants, enter the name of the tenant database.	-
      	username	SAP HANA username NOTE: You need to use the following SQL statements to grant required permissions to this user: CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE; GRANT CATALOG READ to <username>; GRANT SELECT on SCHEMA _SYS_STATISTICS to <username>	-
      	password	SAP HANA user password	-

      NOTE:

      If you need to monitor multiple tenant databases, copy and paste parameters under database.hana, and change database.hana to database.hana.<tenantdb_name>.

      Replace <tenantdb_name> with the tenant database name, and change values of username, password, and other required parameters. username and password indicate the username and password for logging in to the tenant database.

   4. Run the following command to restart the monitoring agent.

      systemctl restart sapmon

(Optional) Uninstalling the Monitoring Agent

1. Run the following command to uninstall the monitoring agent.

   rpm -e sapmon