Home / server / Questions / 671002
In Process
Thorsten Niehues
Asked: 2015-02-25 05:57:34 +0800 CST

SAP HANA - Some services not started

  • 772

SAP HANA was configured correct and SAP HANA Studio was connected to SAP HANA.

From one day to another SAP HANA is not reachable in the SAP HANA Studio.

The operational state is "Some services not started"

How to fix this?
(I have an systems operation account on the HANA server)

Systems view

System monitor

sap

2 Answers

  1. I solved the issue by restarting SAP HANA

    /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function RestartSystem ALL
    • 1

  2. Since restarting the whole database is not always an option, there is a better way:

    1) check which service exactly is not running (e.g., in SAP HANA Studio, right click the system --> Configuration and Monitoring --> Open Administration; there in the 'Landscape' tab you are usually able to see which services are not running)

    2) start missing services (starting them from the 'Landscape' tab usually does not work, so you could do it from console of your server):

    • go to the folder of your instance, e.g. /usr/sap/XDB/XDB01/
    • su - <xdb>adm (where <xdb>adm is the admin user of your instance)
    • start missing service, e.g. exe/hdbnameserver &
    • 1