2061123 - Duplicate entry of HANA DB instance in LMDB SAP Solution Manager 7.1

Symptom

After setting up HANA DB with Solution Manager , in LMDB Transaction there are multiple DB system id get populated ,  HDB ,  HDB0001 , HDB0002 , HDB0003

Environment

SAP Solution Manager 7.1

Reproducing the Issue

Hana database hostprofile missmatch in DB Installation root and the ABAP profile under transaction RZ10.

Cause

Solution manager connected SLD is getting update from 2 Data source 1st is HANA Lifecycle Manager and the other one is RZ70.

Resolution

1. Get the ABAP profile parameter SAPDBHOST using RZ11.
2. Log on to the HANA host on OS level and adjust the DEFAULT.PFL of the HANA database.
3. The DEFAULT.PFL for HANA is located under /usr/sap/<SID>/SYS/profile (or just use command cdpro as <sid>adm to jump there). This directory should be shared between all HANA nodes of the HANA DB system.
4. Add or update the parameter SLDSYSTEMHOME=<SAPDBHOST known in RZ11> to the profile.
5. You have to restart HANA for the parameter change to take effect.
   

See Also

SAP Note : 1747682 : SolMan 7.1: Managed System Setup for HANA

SAP HANA platform is available on SAP Service Marketplace

How to Register HANA with SLD

Keywords

HANA , DB , PROFILE , DUPLICATE , SLD , RZ70 ,  DEFAULT.PFL , DBACOCKPIT , HDBINST , SAPEXEDB