How to Stop and Start SAP HANA Tenant Database

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.

Leave a Reply

Your email address will not be published. Required fields are marked *