cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Start/Stop Hana Tenant Database

Former Member
0 Kudos

Hi,

We are using SP09,Revision 96 HANA for our landscape.We have opened the HANA cockpit but unable to see Manage Databases app.

We need to start/stop Tenant Database but unable to do so as we get no option in HANA studio.Need your help.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Roy,

Thanks for updates,

Seems you have done with below points to stop/start multitenant DB.

Executing SQL Commands

ALTER SYSTEM START DATABSE <DBNAME>

ALTER SYSTEM STOP DATABASE<DBNAME>

OR BY

MANAGE DB APPLICATION OF SAP HANACOOKPIT.

regards,

Krupal.

Former Member
0 Kudos

Hi Krupal,

I cannot find the Manage DB Application inside HANA Cockpit,that is my concern.

Could you please let me know where exactly you get the Manage DB Application in Cockpit?

former_member182307
Contributor
0 Kudos

Hello, on my hana system, it is right on the start page after you got logged in :

HTH, Best regards,

Steve.

Former Member
0 Kudos

Thanks Steve..

With which user you have logged in to HANA Cockpit?Could you please specify the privileges you have assigned for this user.

srinivasan_vinayagam
Active Contributor
0 Kudos
Former Member
0 Kudos

Srini,

This is the link I have been following but could not find Manage Database App in HANA Cockpit tile?

This link is not useful at all.

Former Member
0 Kudos

Hi Roy,

Have you tried with SAPCONTROL to stop scale-out sap Hana systems from the command line?

Stop Multiple instance with instance number:

/usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function stopsystem HDB

Status of all hosts in the system:

/usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function GetSystemInstanceList

Note:

HDB Start or HDB stops only starts and stops the local host.

Regards,

Krupal.

Former Member
0 Kudos

Krupal- sapcontrol command will not work for Tenant Database as the Instance number same with System Database & hostname also.Only difference is the SID between System & Tenant Database.

lbreddemann
Active Contributor
0 Kudos

Has your admin user the appropriate role assigned? (DATABASE ADMIN)

Remember die HANA cockpit implements the role based UX experience approach of the FIORI launchpad.

Former Member
0 Kudos

Lars,

I am trying this with SYSTEM user only..Has all the necessary privileges.

Could you please tell me what is the "Tile" in HANA Cockpit that I need to enter for managing Tenant Database?