Sunday, 30 July 2023

How to start HANA Systems in SAP HANA Studio ?

Start a System

To initiate or start an SAP HANA system, we can utilize the SAP HANA studio. This will start all tenant databases except for those that were manually stopped.

Prerequisites

To continue with the process, it's important to have the login information for the operating system user, especially the <sid>adm user that was created during the HANA database installation. Please make sure you have this information before proceeding.

Procedure

  1. In the Systems view, right-click the system you want to start and choose Configuration and Monitoring  Start System..
Note:  

Execute the start command from the system database. The Start System... command is not available from tenant databases. For more information about how to stop an individual tenant database, see Stop and Start a Tenant Database.

  1. Enter the user name and password of the operating system administrator that was created when the system was installed (that is, <sid>adm user).

  3: The Administration editor opens in diagnosis mode and the database services start one by one. When all services have started, the system appears as operational (Green LED) in the Systems view.

  4:  All tenant databases are started. However, if a tenant database was previously stopped individually, it is not started with the system. For more information about how to stop an individual tenant database, see Stop and Start a Tenant Database.


Thanks 
Rupesh Chavan