SAP HANA 2.0 Cockpit Installation and Configuration How to Guide
In this blog, I would like to provide a step-by-step procedure to install and configure new SAP HANA 2.0 Cockpit to monitor and maintain multiple SAP HANA databases. SAP HANA 2.0 Cockpit is a native web based centralized HANA administrator tool used to perform all database management and monitoring of multiple SAP HANA 2.0 and SAP HANA 1.0 SPS 12 databases.
HANA 2.0 Cockpit was introduced in SAP HANA 2.0 SPS 00 and absorbs functionalities of SAP DB Control Center. This tool is built as an SAP HANA XS Advanced application and uses SAPUI5 user interfaces. HANA 2.0 Cockpit is installed as a single stack but does not require a dedicated instance of SAP HANA to operate.
In the future, the SAP HANA 2.0 Cockpit will be the main and only native tool for administration and monitoring of SAP HANA databases, running both on-premise and the cloud.
Unlike the previous release SAP HANA Cockpit 1.0, cockpit 2.0 comes as a separate SAP HANA system. It runs on a special version of SAP HANA, Express edition with an XS advanced runtime environment included. You can’t deploy cockpit as an XS Advanced application on an existing SAP HANA instance nor can you deploy XSA applications to HANA Cockpit. It is recommended for a production environment to install the SAP HANA Cockpit on a dedicated hardware. For non-production, you can deploy on an existing SAP HANA server as discussed in the SAP HANA Cockpit Installation and Update Guide.
SAP HANA 2.0 Cockpit requires a minimum of 16GB RAM but may need more depends on the number of systems monitored. It is important to review installation and upgrade guide and SAP Notes to get hardware and operating system requirements before installation.
The following users with the privileges need to exists in the monitored resources:
User: COCKPIT_TECH_USER (to gather information such as state, status, and other generalized KPIs)
SELECT on _SYS_STATISTICS
User: COCKPIT_ADMIN_USER (for remote DB login to manage)
SELECT on _SYS_STATISTICS
HANA 2.0 Cockpit can be installed using hdblcm tool in command line or GUI. The installation includes a special version of SAP HANA Express edition with an XS advance runtime engine, which you can monitor and administer using the Cockpit. The following screenshots provides some of the installation steps:
Once you successful install HANA Cockpit, you need to login to Cockpit Manager portal to configure Resource Groups, Register Resources, and Cockpit users.
You will monitor and administer registered resources using Cockpit User portal. The user portal will provide resource information in tabs for performance and monitoring KPIs, Security, and other SAP HANA options like Application Lifecycle Management, Platform Lifecycle Management, and etc.,
You can download the complete document here . Hope you can follow the document to install and configure HANA 2.0 Cockpit in your environment and successfully monitor and administer multiple HANA databases.
If you have any questions or comments, please post in the comments section.
But I can’t add resource. Any created user on HANA db is rejected:
...while I can log on with him via HANA Studio. It is possible only on the SYSTEM user (not recommended). I still don’t find answer why.
For a user to qualified to be a technical user, he needs CATEGORY READ permission, and also best give him _SYS_STATISTICS object privilege also.
You should able to find the information from the Hana Cockpit's help: The question mark on the upper right, then select 'Register a Resource'
Why installer do not ask for /data /log location and try to create it in ../shared ? is there a way to set these paths?
True, he did not ask me too and located in /shared.
You can set desired location this way:
./hdblcm.sh --sid=SID --number=<IN> --sapmnt=/sapmnt --datapath=/sapmnt/SID/data --logpath=/sapmnt/SID/log
Edit the auto_install.cfg file under <DVD>/HDB_SERVER_LINUX*/configurations
i did tried the command sapcar -mainfest SIGNATURE.SMF -XVF abc.SAR
getting error "unknown option nfest (error 20)
is the mentioned port 51063 fixed for Hana Cockpit?
No, follow steps in the document and you will get the ports: https://wiki.scn.sap.com/wiki/display/SAPHANA/Troubleshooting+the+SAP+HANA+cockpit
SAP HANA cockpit is listed as cockpit-web-app. The cockpit manager is listed as cockpit-admin-web-app
don`t know yet, how to change those ports.
I successfully installed Cockpit via this document, many thanks. Also managed to register a resource, but when i try to access Cockpit from Cockpit Manager (or directly) i have only blank screen. SAP note 2255759 describes this issue, but it looks like it`s for old cockpit as those roles are not available. Any ideas? I also had to apply SAP note 2535229 during installation.
So SAP replied to OSS message that content was not deployed successfully during installation, solution was to redeploy:
sidadm> xs undeploy com.sap.hana.cockpit
sidadm> xs deploy <PATH TO MTAR FILE>/sap-xsac-cockpit-2.8.7.mtar
mtar file is located in installation medium
However, ports were different afterwards, please run as
sidadm> xs apps
Could you let me know the procedure how to install HANA Cockpit 2.0 as a Tenant Database?
Below video by SAP HANA Academy describe procedure to install HANA Cockpit on shared database.
SAP HANA Cockpit: Shared Database Installation - SAP HANA Academy
Does this work in collaboration with SolutionManager so we can have a single cockpit view accross the landscape - we have monitoring / alerts etc. all tracked in SolMan and want to make sure the data from HANA Cockpit is also available to our support teams via SolMan so our basis team have a single UI / interface.
Or I wonder if this is more why SAP released focused run?
where can I download the HANA Cockpit License? In HANA Cockpit is a temporary License installed.