Saturday, January 30, 2016

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


Keywords

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

No comments:

Post a Comment