- SAP HANA Admin Tutorial
- SAP HANA Admin - Home
- SAP HANA Admin - Overview
- Architecture Overview
- Multitenant Database
- Multiple Host Systems
- Tools
- Cockpit
- Studio
- SAP HANA Admin - System Mngmt
- Multitenant DB Container Mgmt
- Starting a HANA System
- Stopping a HANA System
- License Keys
- Monitoring the HANA System
- SAP HANA Admin - Table Mngmt
- SAP HANA Admin - Table Partition
- SAP HANA Admin - Table Replication
- Data Compression
- Solman Integration
- SAP HANA Admin - Lifecycle Mngmt
- Securing HANA System
- User Provisioning
- Authentication Methods
- Auditing Activities
- Backing Up HANA System
- Recovery HANA System
- HANA XS Application Service
- Data Provisioning
- Smart Data Access
- New Remote System Connection
- Integration with Hadoop
- Key Commands
- Job Responsibilities
- SAP HANA Admin Useful Resources
- SAP HANA Admin - Quick Guide
- SAP HANA Admin - Useful Resources
- SAP HANA Admin - Discussion
SAP HANA Admin - Cockpit
This is an administration tool to manage your SAP HANA system and is based on SAP Fiori Launchpad based navigation to access long range of HANA applications. SAP HANA cockpit can be accessed via a web browser.
You can also use SAP HANA Cockpit in an offline mode to perform administration tasks - starting HANA system to fix performance-related issues.
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.
You can also perform a drill on these tiles to see the detailed information about specific applications.
Following roles are required to open and access tile-based SAP HANA Cockpit −
sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: Administrator
To open SAP HANA Cockpit via a web browser, you need to have browser support SAPUI5 library sap.m.
You can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system → Configuration and Monitoring → Open SAP HANA Cockpit.
A single-container system is accessed through the following URLs −
https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit
https://<host_FQDN>:80<instance>/sap/hana/admin/cockpit
Host name is SAP HANA system name and Instance number is SAP HANA system Instance number.
SAP HANA Cockpit for Offline Administration
You can also open HANA Cockpit in an offline mode using a web browser or via standard SAP HANA Cockpit tool. This is used to perform administration tasks - starting SAP HANA system, other offline administration activities.
To login to SAP HANA Cockpit for offline administration, following perquisites should be met −
You need to have credentials for Operating System user <sid> admuser created at the time of installation.
Port 1129 should be open for communication.
You need to have browser support SAPUI5 library sap.m.
There are two ways to open SAP HANA Cockpit in an offline mode −
Using the Web Browser
Enter the following URL in the web browser.
https://<host>:1129/lmsl/hdbcockpit/<sid>/index.html
You can directly enter the above URL in the web browser and it opens SAP HANA Cockpit for offline administration. You have to authenticate via Operating system user <sid> admuser.
This method is not recommended as it transfers the password in plain text via HTTP.
Using the Standard SAP HANA Cockpit
You can open SAP HANA cockpit by entering the following URL.
https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit
Navigate to SAP HANA Database Administration group → Select SAP HANA Cockpit for offline administration as shown in the 2nd last box of the following screenshot.
There are various options under SAP HANA Cockpit for offline mode, when you click on the options as shown in the following screenshot −
Start, Restart and Stop
This tile shows the status of your SAP HANA system. Following are the most common status messages you can see −
- Running
- Stopping
- Stopped
- Initializing
When you click on this tile, it allows you to start, stop, and restart a server.
Diagnosis Files
This is used to open the log files, trace results and other diagnosis files. You can use this tile to get the diagnosis files in zip format and it can be attached to support messages.
It is also possible to search diagnosis files to find specific words and phrases.
Troubleshoot Unresponsive System
This tile is used to access the information required for troubleshooting performance issues.
SAP HANA Documentation Tile
Using this tile, you can see the documentation of all the administrative tasks that you can perform in SAP HANA Cockpit for offline administration.
SAP HANA Cockpit
This tile is used to access the main window where you can access all applications for performing SAP HANA administration online. In case of system replication, this option is only available with primary system.
Note − In multitenant database containers, when you use Start option under SAP HANA Cockpit offline administration → Star, Restart, Stop tile → Footer bar, Start System - this options restarts all the tenant database systems.
When you stop a system, the status of the system under Start, Restart, and Stop tile is changed to Stopped (red) as seen in the following screenshot.
