[BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

[kashyap_shah3]

Dear Experts,

I am totally nuts about the following problem:

# /usr/sap/hostctrl/exe/saphostctrl -function ListDatabases

The passwords of <SID>adm, SYSTEM in SYSTEMDB and SAPDBCTRL are 100% correct, tried them all out.

SAP Note 

2023587 - Maintaining SAP HANA user store using SetDatabaseProperty for SAP Host Agent

is NOT helping

SAP Note 

2621457 - hdbconnectivity failure after upgrade to 2.0

is NOT helping

Please kindly advise how to get this solved.

[kashyap_shah3]

Hello,

Could you please elaborate on symptom, what problem you see, where. Appeciate that you are trying to avoid to reinvent the wheel and so listed your troubleshotting steps but it seems to confuse things, at least for me. I am not sure the screenshot that you havegiven is running what command from where. Also, is it secure connection (HTTPS) between Host agent and HANA? If yes, have both, agent and HANA got same root certificate installed or trust established by any other mans?

Thanks.

[symon_braunbaer]

Hello and thanks a lot for your reply!
This is the output from the command /usr/sap/hostctrl/exe/saphostctrl -function ListDatabases

I have intentionally left out the upper few lines, as I have to keep hostnames and SIDs private.
I have no idea if the connection you are mentioning is HTTPS. I did not setup any HTTPS. Furthermore, 
this is host-internal.

I am VERY puzzled by the statement no hosts left... Like if there is a list of hosts, but there isn't, it's
just this host. When I try to connect with hdbsql on the command line, it works flawlessly.
I have also updated to the latest SAP Host Agent, still the same problem!