SAP BASIS HANA ADMIN : February 2020

Saturday, 29 February 2020

SLD / LMDB Registration for HANA Database

We have to connect SAP HANA Database to solution manager for HANA DB monitoring purpose.In order to connect,We need to register SAP HANA database to SLD/LMDB.
This will push data from HANA database to SLD/LMDB.

SLD is optional in solman 7.2 SPS09,So you can register directly to LMDB and push the data to LMDB

1.Login to HANA DB server with <SIDADM> user
2.Switch to directory :
/hana/shared/SID/hdblcm
3. Run the command : ./hdblcm
4. You will get various option and select option 5 configure_sld

5. Enter the below Details

Enter SLD Host Name:

Enter SLD Port:

Enter SLD User Name:

Enter SLD Password:

Enter Use HTTPS [n]:

Do you want you to continue : yes

It will take some time and gives you message whether it completed successfully or failed.

you can check the log in the below directory.

var/tmp/hdb_SID_hdblcm_configure_sld_2020-02-12_16.11.16/hdblcm.log’ on host ‘<hostname>’.

If everything fine check SLDreg log for communication between HANA server and SLD system,Whether it has send a data to SLD/LMDB

Go to : /hana/shared/<SID>/HDBinstance no/<hostname>/trace

HANA DB related information has sent to SLD/LMDB,you can verify by checking for your HDB in SLD system.

Thursday, 20 February 2020

How To Install / Configure Wily Introscope On Solution Manager

How To Install / Configure Wily Introscope in Linux system for solution manager

Software packages:

Download the software package from service market place

Go to "Support Packages & Patches"/SAP TECHNOLOGY COMPONENTS/SAP SOLUTION MANAGER/SAP SOLUTION MANAGER 7.2/WILY INTROSCOPE/

1. WILY INTROSCOPE ENTER MGR 10.5 (For Linux Operating system)

2. WILY INTRO EM MGMT MODULES10.5

To download the third party external component package files:

Go to : https://opensrcd.broadcom.com/ips/osgi/

Download the following files from the subdirectory introscope_10.5.2.0

– eula.txt

– osgiPackages.v10.5.2.0.unix.zip

Extract WILY INTROSCOPE ENTPR MGR 10.5. SAR file and copy eula.txt and osgiPackages.v10.5.2.0.unix.zip in to same folder

Read the license in 'eula.txt' and once you agree with the terms, modify the last line to read "LGP=accept" (the installation cannot continue without doing this)

Read the license in 'ca-eula.txt' and once you agree with the terms, modify the last line to read "LGP=accept" (the installation cannot continue without doing this)

Go to the Wily path which you have extracted the files and execute the command

./introscope10.5.2.113linuxAMD64SAP.bin –Djava.awt.headless=true

Parameter –Djava.awt.headless=true has to be set to avoid the need of having an X server.

Go to : /usr/sap/ccms/apmintroscope/bin

Check the EM status and start the EM services

Install the SAP Management Modules Extract the file WILYISMM*.zip in the home directory of the Enterprise Manager installation, e.g., /usr/sap/ccms/apmintroscope.

Now check the status of EM service and you can check in solman configuration step -> Define CA Introscope

Local SLD Configuration On solution Manager

To Create a Local SLD in your new SAP Solman System and perform subsequent SLD configuration tasks.

Log in to your SAP System’s Landscape Directory by launching URL:

http://<solmanhost>:5xx00/sld

As you log in for the first time you will see the below message, “SLD Not Setup. Configure the SLD in Administration first”

Logged into NWA

Navigate to Configuration à Scenarios -- >Configuration Wizard

Navigate to Functional Units and select System Landscape directory - > Enable Automatically.

Define Master Password

After completing the job,now SLD configured sucessfully.

How to Stop/Start HANA Database?

1.Login with <SID ADM>

2.Go to the path /usr/sap/<SID>/<Instance_Number> and execute the command HDB info ( This command will show the list of services that are currently running).

3. Execute the command HDB stop to stop all the HANA services.

4. Start the database services using the command HDB start.

Wednesday, 19 February 2020

How to install HANA license by OS command

For single container system, you can follow below steps to install the license directly.

While for MDC system, you have to decide where the license needs to be installed. Generally, install system level license, you need to connect to system database.

And for tenant level license, you can connect to the specific tenant database to perform below steps.

1.Logon as sidadm user, connect to the Database via hdbsql.

For single container system, please try below command:

> hdbsql -n <hostname>:3<instance no.>15 -i <instance no.> -u <DB username> -p <password>

For MDC system, please try connecting to the system DB by below command:

> hdbsql -n <hostname>:3<instance no.>13 -i <instance no.> -u <DB username> -p <password>

To install license in a specific tenant, please maintain the SQL port of the tenant DB in the command accordingly.

> hdbsql -n <hostname>:3<instance no.><tenant SQL port> -i <instance no.> -u <DB username> -p <password>

2.Enable multiline mode in hdbsql

hdbsql <DB name>=> \mu

3.Enter statement

SET SYSTEM LICENSE ‘<License File content>’

Please note to add quotation mark outside the content of the license file you just downloaded.

4.Execute the statement by command: \g

hdbsql <DB name>=> \g

Remarks:

Install the new license via hdbsql cannot replace the old license. Please consider to delete the old license key before installing the new one.

You can also delete license keys by executing the SQL statement UNSET SYSTEM LICENSE ALL.

DAA Installation / Diagnostics agent installation

Software Package
1. SWPM 1.0 SP27
2. SAPEXE.SAR
3. SAPJVM8.SAR
4. SAPDIAGNOSTICSAGENT.SAR
5. SAPHOSTAGENT.SAR

Download all the software packages from service market place and extract all the packages and move to server which you want to install DAA

1.Logon with Root user and go to SWPM path
Run ./sapinst