How to start/stop HANA Database / How to start/stop single tenant database from OS level or from HANA Studio

Please follow below procedure if you have HANA studio install

1: Open HANA studio  

2: go to System DB

3: open SQL à run command

Note: We have to provide name tenant database which we have to stop

Stop all tenant databases in the system.

In the system database, execute the SQL statement

ALTER SYSTEM STOP DATABASE <databasename>.

Note:
 You can also stop tenant databases in the Manage Databases app of the SAP HANA cockpit.

Start all tenant databases.

In the system database, execute the SQL statement

 ALTER SYSTEM START DATABASE <database_name>

Note: You can also start tenant databases in the Manage Databases app of the SAP HANA cockpit.

STOP HANA System and tenant DATABASE from OS level.

Note: Please login with sidadm of HDB. It will stop HANA DB. It will take time as per size of DB. We can check services status with command   “HDB info “ in duplicate session

E.g.

HANA DB SID: HDB

Login user id at OS: hdbadm

Run below command after login with hdbadm

HDB stop 

START HANA DATABASE from OS level.

 HDB start

To Check status of HANA service rung below command 

HDB info