How to prepare HANA, express edition environment for tutorials

How to prepare HANA, express edition environment for tutorials

This how-to shows you how to prepare your HANA, express edition for executing the other Tutorials.

Note on SAP HANA, express edition version 2.0 implications on “How-Tos” and “Tutorials”:

The most commonly used instance numbers are 00 and 90. The instance number can be chosen at the time of setup, although the installer from versions SPS00 onwards suggests instance number 90 while the SPS12 version uses 00 as the default instance number and port (3<instance number><15|13>). The following chart summarizes the common default ports:

HANA Express Version

Default Instance ID

Port

1.0 SP12

00

30015

2.0 SP00

90

39015

2.0 SP01

90

39013

If you are uncertain of the instance number, switch to user hxeadm using command su hxeadm, which will take you to a directory called /usr/sap/HXE/HDBXX, where XX is the instance number.

How-To Details

The HANA, express edition “Tutorials” reference a set of users. This set of instructions assures all required users and passwords are available and correct before attempting the other SAP HANA, express edition Tutorials.

The passwords referred to in the “Tutorials” will not match passwords chosen by the user. For example, any reference to the password "HANARocks2016" or HanaRocks2017 should be replaced by the user provided password (see below).

Step 1: Review system configuration

Review default system configuration for HANA, express edition:

Field Name

Value

System Host

hxehost

SID

HXE

System Instance Number

90 (version 1 SP12 00)

XSA Organization

HANAExpress

XSA Space

development

ALL passwords

(referred to as HANAROCKS2016 or HanaRocks2017in tutorials)

Note : The command xs will only be available if you have installed XS Classic or XS Advanced. The server-only installation as of HANA 2.0 SPS01 version does not bring xs by default.