A while ago one of our HANA appliances crashed due to a hardware failure and i recognized that not all databases had started properly. This can be chose during the installation and different persons have installed the databases differently. But how to fix that?

  • Logon to the operating system of the SAP HANA Appliance with adm or change to adm.

  • Edit: /hana/shared/#SID#/profile/#SID#_HDB#INSTANCE_NUMBER#_#HOSTNAME#:

    vi /hana/shared/$SAPSYSTEMNAME/profile/$SAPSYSTEMNAME\_HDB\*
  • Change "Autostart = **0**" to "Autostart = **1**"

  • Save

On the next boot this database will be started properly.