Sunday, 3 November 2019

Enabling Autostart of sap hana database on server boot situation

There are multiple ways to achieve the auto start of HANA after a server reboot situation.

If you want to enable AUTOSTART option for your HANA database after a server reboot situation then you can do it with editing the following file…


1. Logon the linux operating system with adm user

2. Go to /hana/shared/#SID#/profile/ location

3. Edit the file #SID#_HDB#INSTANCE_NUMBER#_#HOSTNAME#

vi /hana/shared/$SAPSYSTEMNAME/profile/$SAPSYSTEMNAME_HDB*

4. Change the parameter “Autostart = 0″ to “Autostart = 1″

5. Save

Next reboot , HANA database will be started automatically…