Installing SAP HANA Cockpit

Objective

After completing this lesson, you will be able to install SAP HANA Cockpit

SAP HANA Cockpit Installation

Business Example

The installation package includes SAP HANA express database, the XSA, SAP HANA cockpit, and SAP HANA database explorer.

Hardware Requirements

SAP HANA cockpit can be installed on Intel-based hardware platforms or on IBM Power Systems. The minimum hardware requirements for a production environment depend on the use case. SAP HANA 2.0 cockpit can be installed on a dedicated server, or installed as an additional tenant inside an existing SAP HANA database system.

The supported operating systems are Red Hat Enterprise Linux (RHEL) for SAP Solutions, Red Hat Enterprise Linux (RHEL) for SAP HANA, SUSE Linux Enterprise Server (SLES) for SAP Applications or SUSE Linux Enterprise Server (SLES). For specific information about the supported operating systems for the SAP HANA cockpit, see the following SAP Notes: 2235581 – SAP HANA: Supported Operating Systems and SAP Note 2055470 – SAP HANA on POWER Hardware.

SAP HANA Cockpit Deployment Options

SAP HANA cockpit can be deployed on dedicated hardware, on shared hardware, or in an existing SAP HANA system (shared database). All deployment options are approved for production environments.

Note

Deploying on shared hardware has restrictions. For more information, see SAP Note 1681092 - Multiple SAP HANA systems (SIDs) on the same underlying server(s).

SAP HANA Cockpit Deployment Options

Hardware Requirements – Dedicated and Shared Hardware

  • Intel-based x64 platforms: SLES 12.x or 15.x and RHEL 7.x, 8.x, or 9.0

  • IBM PPC LE (Little Endian): SLES 12.x or 15.x and RHEL 7.x, 8.x, or 9.0

  • Host memory: minimal 16 GB

  • Disk space: minimum 16 GB + additional space for data.

  • Number of CPU or vCPU: 4

Hardware Requirements - Shared Database

  • Intel-based x64 platforms: SLES 12.x or 15.x and RHEL 7.x, 8.x, or 9.0

  • IBM PPC LE (Little Endian): SLES 12.x or 15.x and RHEL 7.x, 8.x, or 9.0

  • Tenant memory: minimal 22 GB

  • Disk space: minimum 1.5 GB + 2 MB per 100 registered resources.

Virtualization

The SAP HANA cockpit can be installed in either a dedicated virtual machine, or in a virtual machine that is shared with an SAP HANA system. For best results, a dedicated virtual machine is preferable.

Installation Overview

SAP HANA cockpit runs on an SAP HANA Express database, which is included in the installation. The SAP HANA cockpit can also be installed in an existing SAP HANA system in a separate tenant database (shared database).

The SAP HANA lifecycle management tool (HDBLCM) is used to install the SAP HANA cockpit via the graphical user interface or the command-line interface.

During the installation process, a fully authorized administration user named COCKPIT_ADMIN is created. The master password entered during the installation is assigned to this user.

The ports, through which the SAP HANA cockpit and the SAP HANA cockpit manager can be accessed, are assigned automatically during the installation. The ports used by SAP HANA cockpit and also specified before the installation. This is explained in SAP Note 2389709 – Specifying the port for SAP HANA Cockpit before installation.

The installation of SAP HANA cockpit is kept as easy as possible, so during the installation, only the local host name, the installation path, the SAP HANA system ID, instance number, and the master password are requested. Make sure you pass along this information to the SAP HANA cockpit administrator.

You can review the existing configuration settings for the SAP HANA cockpit. Installation settings can be found in the auto_install.cfg file (stand-alone installation) or auto_install_hdb.cfg file (installation in an existing SAP HANA system) located inside the folder:

Code Snippet
Copy code
Switch to dark mode
123
/<unpack location>/HDB__LCM_LINUX_X86_64/configurations
 or
 /<unpack location>/HDB__LCM_LINUX_PPC64LE/configurations
The default database server properties can be found inside the *.ini files inside the folder:
Code Snippet
Copy code
Switch to dark mode
1
/<unpack location>/HDB_SERVER_LINUX_X86_64/configurations/custom

You can also use the batch mode from the SAP HANA database lifecycle manager (HDBLCM) on the command line to install SAP HANA cockpit.

Extract the SAP HANA Cockpit .SAR File

The SAP HANA cockpit 2.0 software can be downloaded from SAP for Me>Download Software Center.

Download the SAR file to the SAP HANA cockpit server and unpack it using the following command line:

Code Snippet
Copy code
Switch to dark mode
1
SAPCAR -vxf SAPHANACOCKPIT##_$$.SAR -manifest SIGNATURE.SMF

Hint

Unpacking the SAR file with the -manifest SIGNATURE.SMF creates the required signature file.

## is the Support Package Stack number.

$$ is the patch level.

After the SAR file is unpacked, start the installation, as root user, by running the command:

Code Snippet
Copy code
Switch to dark mode
1
hdblcmgui.sh

Predefined Installation Settings for SAP HANA Cockpit

The required input is preset when using hdblcmgui, but it can be changed. You only need to provide the master password for the users created during the installation.

As soon as the installation is finished, you can start configuring SAP HANA cockpit by creating resources, resource groups, and cockpit users.

Write down the SAP HANA cockpit URLs that are displayed in the installation summary screen at the end of the installation. These URLs can change during an upgrade to a newer version of the SAP HANA cockpit.

The connectivity between SAP HANA cockpit and managed resources includes:

  • SAP HANA SQL port (Ports: 3xx13, 3xx15, …)
  • sapstartsrv (Ports: 5xx13, 5xx14)
  • Smart Data Streaming (SDS) (Port: 3xx26)
  • saphostagent (Port: 1129)

Note

xx is the SAP HANA instance number.

Log in to track your progress & complete quizzes