There are multiple way to stop and start SAP HANA Tenant Database .
But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio .
Step 1- Launch SAP HANA Studio and open SQL console .
Once SQL Console is open then you can execute below mentioned sql commands for Stop and Start SAP HANA Tenant Database.
How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID):
alter system stop database SMH
How to verify if Tenant database has been stopped:
Execute SQL command:
select * from m_databases;
ACTIVE _STATUS is NO for SMH .It implies database has been stopped.
How to Start SAP HANA Tenant Database:
alter system start database SMH
How to verify if Tenant database has been started:
Execute SQL command:
select * from m_databases;
ACTIVE _STATUS is YES for SMH .It implies database has been started.