skip to main content

SAP NetWeaver Newbie

Starting and Stopping SAP HANA

Stopping SAP HANA

You can stop SAP HANA system from OS level using one of the following commands:
  • HDB stop
  • /usr/sap/<SID>/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr <NN> -function StopSystem HDB

To stop HANA from HANA Studio
  1. Right-click on the system
  2. Choose "Configuration and Monitoring" and "Stop System" (you will be prompted to provide OS credentials)

You can verify the status of SAP HANA system using the following commands
  • sapcontrol -prot NI_HTTP -nr <NN> -function GetSystemInstanceList
  • HDB info

After shutdown hdbrsutil process will be running to keep row tables in memory. This allows for a faster HANA startup. If you wish to stop these processes (for example to reboot the host server), run the following command
hdbrsutil -f -k -p <port number (e.g. 3xx03)>

You can find the port number from the command "HDB proc"


Starting SAP HANA

You can start SAP HANA system from OS level using one of the following commands:
  • HDB start
  • /usr/sap/<SID>/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr <NN> -function StartSystem HDB

To start HANA from HANA Studio
  1. Right-click on the system
  2. Choose "Configuration and Monitoring" and "Start System" (you will be prompted to provide OS credentials)
How to start SAP HANA


 hdbrsutil will not run when HANA is running.

2 comments:

  1. Hello There,

    THANKS SO MUCH for sharing this! I would love to buy you a coffee since I now won’t be up all night that has been driving me crazy (until now!!). I just wish I knew what was going wrong but so glad it’s in the right place now! Thanks again:)
    I have created one ADSO through SAP BWMT 1.18 version on SAP HANA edition 1. sps11 with SAP HANA Studio version been 2.3.32 and then SAP HANA Training view on top of the hana view table for my ADSO.
    The view is active without any error, Checked SYS_BIC column views. but when I do Data preview I get error "View not found. Either the view is inactive or the selected attribute is not present in the active view."
    I went through few discussion and it was noted that latest version of the HANA studio solved the issue but they did not precise what was their version and Environment details.
    Could you please help me out on what could be the reason for such error?
    Below is the link I referred before.
    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
    Please keep providing such valuable information.

    Thank you,
    Abhiram

    ReplyDelete

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.