2

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

Improve this question

2 Answers 2

Reset to default
1

I solved the issue by restarting SAP HANA

/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function RestartSystem ALL
Improve this answer
1
  • 1
    there is a nuclear option for every problem, right ;-)
    – Florenz Kley
    Commented Mar 1, 2016 at 17:35
1

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 &
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .