Solution : https://service.sap.com/sap/support/notes/1625203 (SAP Service marketplace login required)
Summary :
SAP has updated the saphostagent to enable querying the database status, and managing database operations like start and stop for NewDB databases. Users are required to apply SAPHOSTagent patch level 84 or higher to access these features. For passwordless connection setup, a new database user with monitoring privileges needs to be created through NewDB studio using provided SQL commands. Additionally, the hdbuserstore tool must be configured on the server by creating a user key specific to SAPDBCTRL for authentication during operations without password input. Validation of these configurations can be carried out via specific commands detailed in the solution.
Key words :
/usr/sap/hostctrl/exe/saphostctrl -function getdatabasestatus -dbname <sid> -dbtype hdbif sapdbctrl responds, hdbuserstore set <sid>sapdbctrl <dbhost>, /usr/sap/<sid>/hdbclient3, alter user sapdbctrl password <password>2, user key <sid>sapdbctrl, /usr/sap/hdbclient, os user <sid>adm, hdbuserstore list <sid>sapdbctrlif, create user sapdbctrl password, database user authentication failed
Related Notes :
| 1031096 | Installing Package SAPHOSTAGENT |