本文重点介绍HANA 启动与关闭在不同管理工具的具体用法
- HANA 数据库启动与关闭的工具
- HANA 数据库启动与关闭工具需要的账号与密码
- HANA 数据库启动与关闭在各个不同管理工具的具体用法
1.HANA 数据库管理工具
the whole database system : SAP HANA COCKPIT and SAP Control
one or more tenants: SAP HANA COCKPIT and SQL
one or more hosts in scale-out scenairo: HDB and SAPControl
SAP HANA servcies: SAP HANA COCKPIT and SQL
2.不同管理工具需要的账号与密码
| Tools | Root | <sid>adm | Cockpit User | DB user |
| SAP HANA Cockpit | NO | YES | YES | YES |
| SAPControl | YES | YES | NO | NO |
| HDB | NO | YES | NO | NO |
| SQL via HANA Cockpit | NO | NO | YES | YES |
| SQL via HDBSQL | NO | YES | NO | NO |
注意 SAP HANA cockpit 和SAPcontrol 的特点
Using SAP HANA Cockpit and the SAPControl function Stop System and Start system will stop the entire sap HANA database system,independently of whether the system is
a singel-host system or a multi-host(scale-out) system.
3.各个管理工具的具体用法
SAPControl
sapcontrol -nr <instancenumber> -function StopSystem sapcontrol -nr <instancenumber> -function StartSystem sapcontrol -nr <instancenumber> -function RestartSystem sapcontrol -nr <instancenumber> -function GetSysteminstanceList
sapcontrol -nr <instancenumber> -function GetProcessList
SQL
alter system start database tenant1 alter system stop database H93
HDB
HDB STOP
HDB START
HDB RESTART
注意：
both SAP HANA Cockpit and the SAPControl use the the SAP start servcies (sapstartsrv)to stop and start HANA database system in a controled way.Sapstartsrv start all necessary OS servcies and the SAP HANA Daemon.
The SAP HANA daemon starts all required SAP HANA services, such as the name server,index server and for example the preprocessor services.