Home » Posts tagged '#Database'

Tag Archives: #Database

Start Stop SAP HANA DB using sapcontrol

To start and stop an SAP HANA database using the sapcontrol tool, you can execute the following commands:

  1. Start HANA database:
    • sapcontrol -nr <instance_number> -function StartSystem HDB
    • Replace <instance_number> with the number of the HANA instance you want to start. For example, if you want to start instance 00, the command would be:
    • sapcontrol -nr 00 -function StartSystem HDB
  2. Stop HANA database:
    • sapcontrol -nr <instance_number> -function StopSystem HDB
    • Replace <instance_number> with the number of the HANA instance you want to stop. For example, to stop instance 00:
    • sapcontrol -nr 00 -function StopSystem HDB

Note: The sapcontrol command requires administrative privileges, so you might need to execute it as a superuser or with appropriate administrative permissions. Also, ensure that the sapcontrol tool is in your system’s PATH or provide the full path to the sapcontrol executable in the command.

Start stop of HANA Database with HDB

To start and stop an SAP HANA database, you can use the following commands:

  1. Start HANA Database:
    • On Linux: sudo -u <SID> HDB start
    • On Windows: HDB start
    Replace <SID> with the System ID of your HANA database.
  2. Stop HANA Database:
    • On Linux: sudo -u <SID> HDB stop
    • On Windows: HDB stop
    Again, replace <SID> with the System ID of your HANA database.