SAP HANA 2.0 SP04 Suse

Preinstalled SAP HANA 2.0 SP04 Suse (SAP License not included) #

Our team of consultants is continuously working on updating available AMIs and adding new products. In case you miss something, please let us know by sending an e-mail to product.support@linkeit.com

HANA Installation data #

During the SAP software installation in this AMI some options had to be chosen to complete the installation. Chosen options are detailed below.

  • HANA Instances: This AMI includes a database instance single node.

The following table shows the relevant information about the SAP software installation included in the AMI. Information such as HANA SID, Master Password, Instance number and software location in the server are shown here.

SAP Instance Values
Hostname saphana
Domain linkeit.local
Master Password Zaq12wsX
HANA Instance Number 00
HANA Admin User lnhadm

PASSWORD CHANGE: It is mandatory to change the Database installation Master Password so that it remains private to you and meets all security requirements.
Important: HANA Studio is not installed in the AMI. You will need to install HANA Studio to administrate HANA Database.

Getting Started #

Part 1 - Create your own HANA instance on AWS #

Start your new HANA server by following the next steps.

  1. Log on to Amazon Market Place: https://aws.amazon.com/marketplace/pp/B0844XZ2KL and click on Continue to Subscribe

  2. Choose an Instance Type Select one of the AWS instance size from the available choices.

    For HANA database, a minimum of 61Gb memory is required (SAP HANA on AWS). For more detailed information about SAP Business Suite Sizing and appropriate EC2 instance types, please refer to SAP documentation, SAP sizing tool and OSS Notes (S-User required): (http://service.sap.com/instguides) (http://service.sap.com/quicksizer) (http://service.sap.com/sap/support/notes/1656099)

  3. Configure Instance Details. Configure and define a network and subnet. If you need to connect directly by internet you need to enable Auto-assign Public IP.

  4. Add Storage. You can choose the EBS volume type, you can leave as default or use SSD / IOPS for best performance. In this point you can increase the size of the volumes to expand the filesystems. It depends on the size of the database you are going to use.

  5. Add Tags. Next step is to tag the instance so you can identify it in the AWS Console.

  6. Configure Security Group. You should adapt these settings to meet your specific security policies. More information in Part 2 - Important SAP and HANA ports

  7. Review Instance Launch. Review the configuration and click on Launch when accepted.

  8. The process will ask you to provide an existing Key Pair or to create a new one. If you choose to create a new one, do not forget to download the Key Pair file as this will be mandatory to access the EC2 instance through SSH.

  9. After a few minutes, you can access your instance with SSH and do the final configuration steps.

Part 2 - Important HANA ports #

You have to open the necessary ports in AWS security Group to allow the connection. This is the list of most important ports for SSH, SAP and HANA:

To open other specific ports this is the list of the most important. alt text

Hana External Ports: https://wiki.scn.sap.com/wiki/display/TCPIP/SAP+HANA+Platform alt text

Part 3 – SSH connection to your SAP AWS instance #

  1. In the EC2 console, navigate to instances. This will list all your instances in Amazon EC2. Make sure the SAP instance you want to connect to is in “running” state. If not, choose the instance, then click on Instance Actions menu, and click on Start in the pull down menu.

  2. Make a note of the IP address assigned to the instance. You will need it to connect to this SAP instance in AWS.

  3. SSH to the instance with ec2-user and the key pair chosen at launch time. To access your instance: 1.Open an SSH client. (Recommended - find out how to connect using PuTTY) 2.Locate your private key file (.pem). 3.Connect to your instance using its IP:

    Example:

        ssh -i "<keypair_location>/<keypair>.pem" ec2-user@<IP Addr>
    

    ``

  4. The first time you start SAP may take longer (up to 1 hour) since the disks in AWS are still not stable. The successive starts will be immediate.

    We recommend you run some pre-warming commands the first time you start the system to increase performance from the beginning. First time you launch an instance from an AMI, the process synchronizes the snapshots that compose this AMI with the EBS volumes of your instance. This can take a long time depending on the size of the disks and the instance type you have chosen. Depending on the instance, it can run out of storage credits and perform at its baseline (3 iops x gb), this situation becomes a bottleneck. The process can take up to 12 hours with a m4.4xlarge instance. This is the AWS document that explains these steps: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html It will only be necessary to perform these actions once after the creation of the Instance In our case the commands to be executed are as follows, please note, it can take up to 12 hours for all these commands to execute successfully depending on EBS size and types chosen for your instance. If you do not execute these actions, the first time you run HANA it will take a long time to boot.

Part 4 – Configure HANA Studio to HANA Database access #

To activate SAP HANA database you must provide the system with a valid license. Follow the next steps to activate the server.

Connect to the database #

To manage the HANA database, you need to install the Hana studio program on a PC/laptop, you can download it from the SAP website (https://launchpad.support.sap.com) with S-User credentials. To connect you have to enter the connection data of the instance created in AWS.

Access to SystemDB Access to Tenant DB
Access to System DB Access to Tenant (SAP) DB

We need to configure SAP Hana Studio to install the new license. The first time you connect to Hana studio an error message will appear to inform that you need a proper license. License Error To install it see the next part.

Licensing SAP HANA #

To install the HANA license, you should be to connected to Hana studio. If you are still not connected, follow the steps in the previous section to connect and ensure that database is started.

When you try to connect to HANA Database first time in Hana Studio, you get the error: Access to Tenant (SAP) DB

Click on the Checking license properties... link in the warning message, or access the Properties of the server in the drop down menu. Access to Tenant (SAP) DB

You can also obtain the hardware key by executing the following command from shell with the lnhadm user:

saplicense -get

Once you have the Hardware Key you must request for a new license key in SAP Portal. Go to https://support.sap.com/keys-systems-installations/keys.html and obtain a valid license key for your HANA system.

You can find additional information on how to create a license in the following link: https://help.sap.com/saphelp_hanaplatform/helpdata/en/c1/2868abbb571014abb6a940e75f9c3e/content.htm

Ready to work #

Now you are ready to start working with your HANA instance!!

PASSWORD CHANGE: Remember that it is mandatory to change the Database installation Master Password so that it remains private to you and meets all security requirements.

Additional Information #

Start/Stop processes #

Start HANA on AWS instance #

In order to be able to connect to your Instance for starting SAP software you need to connect by ssh software as explained in previous Part.

Start HANA #

HANA instance should start automatically, but in case it fails it can be started connected to a shell with user lnhadm:

HDB start

Check that the instance is running by executing the following the command ps -fu lnhadm. The output should be similar to this:

saphana:~ # ps -fu lnhadm
UID        PID  PPID  C STIME TTY          TIME CMD
lnhadm    7432     1  0 09:14 ?        00:00:00 /usr/sap/LNH/HDB00/exe/sapstartsrv pf=/usr/sap/LNH/SYS/profile/LNH_HDB00_saphana -D -u lnhadm
lnhadm    7559     1  0 09:14 ?        00:00:00 sapstart pf=/usr/sap/LNH/SYS/profile/LNH_HDB00_saphana
lnhadm    7634  7559  0 09:14 ?        00:00:00 /usr/sap/LNH/HDB00/saphana/trace/hdb.sapLNH_HDB00 -d -nw -f /usr/sap/LNH/HDB00/saphana/daemon.ini pf=/usr/sap/LNH/SYS/profile/LNH_HDB00_saphana
lnhadm    8253  7634  6 09:14 ?        00:00:45 hdbnameserver
lnhadm   10585     1  0 09:18 ?        00:00:00 hdbrsutil  --start --port 30001 --volume 1 --volumesuffix mnt00001/hdb00001 --identifier 1591082281
lnhadm   10772  7634  0 09:18 ?        00:00:01 hdbcompileserver
lnhadm   10775  7634  0 09:18 ?        00:00:01 hdbpreprocessor
lnhadm   10820  7634 14 09:18 ?        00:01:04 hdbindexserver -port 30003
lnhadm   10823  7634  2 09:18 ?        00:00:09 hdbxsengine -port 30007
lnhadm   11039     1  0 09:19 ?        00:00:00 hdbrsutil  --start --port 30003 --volume 3 --volumesuffix mnt00001/hdb00003.00003 --identifier 1591082344
lnhadm   11314  7634  1 09:19 ?        00:00:03 hdbwebdispatcher

Stop SAP HANA on AWS instance #

Stop HANA #

To stop the HANA server, execute the following command connected to a shell with user lnhadm:

HDB stop