Technical Articles

February 13, 2019 4 minute read

Update SAP HANA Cockpit 2.0 – by the SAP HANA Academy

Introduction

For the SAP HANA platform, application restraints might be stopping you from upgrading to the latest and greatest release. However, for the SAP HANA cockpit this should not be the case and we recommend always to update cockpit to the latest available Support Pack (SP).

It is very easy, just takes a little time:

Download / upload software archive (SAR file) to SAP HANA cockpit system
Extract file
Install (± 30 minutes)

For the code samples, see

https://github.com/saphanaacademy/cockpit/

For the full SAP HANA cockpit playlist on YouTube, see

SAP HANA Cockpit 2.0 – What’s New?

For the what’s new release blogs, see

SAP HANA Cockpit 2.0 SP 09 What’s New – by the SAP HANA Academy

For the (older) installation blog, see

Getting Started with SAP HANA Cockpit 2.0 – by the SAP HANA Academy

Tutorial Video

Download

You can download SAP HANA Cockpit 2.0 SP’s from the SAP ONE Software Downloads:

SAP HANA COCKPIT 2.0 (SUPPORT PACKAGES AND PATCHES) – SAP Software Downloads

SAP ONE Support Portal, Software Downloads

Extract Components

Download with SAP Download Manager and upload to the server with your SFTP tool of choice (e.g. WinSCP).

Extract the file with the resident installer (current installation) SAP HANA Lifecycle Management tool with command:

/hana/shared/H4C/hdblcm/hdblcm --action=extract_components

SAP HANA Lifecycle Management, Extract Components

Alternatively, extract the file using the SAPCAR utility from the SAP Host Agent (included with any SAP HANA installation):

/usr/sap/hostctrl/exe/SAPCAR -xvf \
 SAPHANACOCKPIT09_5-70002299.SAR -manifest SIGNATURE.SMF

Update in GUI Mode

For one-off installations, you can use the SAP HANA Lifecycle Management tool in graphical mode.

Prerequisites

When using a Windows client, install software to display X-Windows applications (e.g. Xming) and software to tunnel the display through an SSH connection (e.g. PuTTY):

SAP HANA Lifecycle Management, Graphical Mode

Update in Command Line Mode

For scripted (automated) installations, use the command line version (as root). You are prompted for the action (update), the system database user name and password, and the XS Advanced Admin user and password.

SAP HANA Lifecycle Management, Command Line Mode

Batch Updates

Just like with regular SAP HANA installations, you can run the command line mode installer in batch mode with a parameter file.

To generate the parameter file, run the command:

./hdblcm.sh --action=update --dump_configfile_template=cockpit.cfg

The actual name of the configuration file (and extension) is irrelevant.

Of the many parameters, only a couple are required for a cockpit update:

[Server]

# SAP HANA System ID ( Default: H4C )
sid=H4C

# Database User Name ( Default: SYSTEM )
system_user=SYSTEM

# Database User Password
system_user_password=

[Action]

# Action ( Default: exit; Valid values: install | update )
action=update

[XS_Advanced]

# XS Advanced Admin User ( Default: COCKPIT_ADMIN )
org_manager_user=COCKPIT_ADMIN

# XS Advanced Admin User Password
org_manager_password=

You do not need to provide default values, so in the above case only the action and the passwords are needed. However, for security purposes, you might prefer to store passwords separately in another file with different file protection configuration and distribution approach.

The format is XML, below an example:

In the vi editor, you can use the substitute command to easily change the asterisks to a new master password.

:%s/\*\*\*/your-master-password/

To execute a batch mode installation with password pipe the contents of the XML file as input to the installer.

cat passwords.xml | ./hdblcm.sh --read_password_from_stdin=xml \
 --configfile=cockpit.cfg -b

To run in batch mode with configuration file only, just provide configfile:

./hdblcm.sh --configfile=cockpit.cfg -b

Command line parameters overrule configuration file parameters, e.g.:

./hdblcm.sh --configfile=cockpit.cfg -b -SID=ABC

Documentation

New features and known issues are documented in

Updating the SAP HANA Cockpit – SAP HANA Cockpit Installation and Update Guide
2713615 – SAP HANA Cockpit 2.0 SP 09 – SAP Note

For all SAP HANA cockpit documentation, see

SAP HANA Cockpit – SAP Help Portal

SAP Help Portal, SAP HANA Cockpit Installation and Update Guide

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.