In my documentation I’ll explain how install/configure SAP Hana with SAP Netweaver instance and using HSR and file system replication in order to replicate from one data center to another one for failover.

For my scenario I’ll include a Hana upgrade phase from SP10 to SP11 process.


I will use my own lab on Vmware Vsphere 6.0, run SAP Hana revision 112 and use SAP Netweaver 7.5

Disclaimer: My deployment is only for test purpose and POC in order to show case functionalities and features. I make the security simple from a network perspective in order to realize this configuration and use open source software.

In order execution

  • Configure the DNS with hostname alias
  • Install SAP Hana Database Rev.101
  • Install Netweaver 7.50
  • Configure Hana replication
  • Configure FreeNas 10 storage replication
  • Perform failed over to Site2
  • Perform Hana upgrade to SP11


Guide used

SAP HANA Master Guide SP10+

SAP NetWeaver 7.5 Installation Guide

FreeNAS User Guide 9.10

Note used

2120226 – SAP HANA client software and entries in hdbuserstore when using virtual host names for SAP application servers

2183363 – Configuration of SAP HANA internal network

2141442 – SAP HANA client software: hdbuserstore not found when using virtual host names

2130496 – Application on HANA does not start after Disaster Recovery Takeover

Link used

Help SAP Hana for Hana

Help SAP Netweaver 7.5

Suse doc : Administration

FreeNAS User Guide 9.10

Overview Architecture

/wp-content/uploads/2016/06/1_974681.jpg

For my configuration I will deploy 4 SLES 11.3 server vm

  • 2 vm for app server: 12 GB ram, 1×4 core CPU, 20 GB of disk for instance, 1 NIC card
  • 2 vm for Hana database: 48 GB ram, 2×4 core CPU, 70 GB of disk, 2 NIC card 

Detailed Architecture

/wp-content/uploads/2016/06/2_974682.jpg

From a detail deployment point of view I’m not going to setup SLES cluster mechanism in order to control and perform the failed over switch manually.

I will configure my DNS server to use two alias name which will be used to access SAP Netweaver and Hana.

SAP Hana replication will be configure for synchronous replication from site 1 to site 2 and Netweaver application server will be replicated by storage replication functionality provided by FreeNas feature.

I have beforehand created all my users and groups needed in my external LDAP server

Configure the DNS with hostname alias

For my configuration I setup my DNS the way the client connection (hana studio and netweaver) will use a specific alias name which point to Netweaver (vmapp) and Hana (vmhana).

Using virtual hostname (alias) in the following case to build my scenario allow me to failed over from one site to another one without making any change into /etc/hosts local file for client connection, as well as not making any change to the default profile of my instance.

In case of failed over only the DNS will be updated to point the alias on the correct site.

/wp-content/uploads/2016/06/3_974683.jpg

Note: I setup my alias to work currently on site1 for the based configuration/installation

/wp-content/uploads/2016/06/4_974684.jpg  /wp-content/uploads/2016/06/5_974685.jpg

Install Hana Rev 101

My hana alias define I can now start now the installation of the new database, before to run the execution I’ll first check the resolution of the alias configured to make sure I’m all good to go

/wp-content/uploads/2016/06/6_974686.jpg

In my previous documentations I have explained and show how to install hana by command line and from graphical interface, in this one I will install hana in batch mode by using a config file in order to reuse it later for my second site.

Running such deployment is very useful to automation installation for scale-out, or on-demand (cloud) scenario.

From the installation medium I run the following command to generate my template .cfg file

/wp-content/uploads/2016/06/7_974687.jpg

My file generated I can now customize it in order to provide the necessary information such as:

Password, SID, Instance #, userid, gourpid, medium location …

Note: password could also be read from XML file

/wp-content/uploads/2016/06/8_974689.jpg

Once done I can run my installation in batch mode by specifying my config file

/wp-content/uploads/2016/06/9_974690.jpg

My installation done I can check from the studio and proceed with my second site

/wp-content/uploads/2016/06/10_974691.jpg

Install Netweaver 7.5

My Hana instance are now create and functional, I can start to build my Netweaver instance for the primary site.

Since I will use my FreeNas for filesystem replication, I need to assign to my application’s vms the right set of disk, I have then attached my two disk to my FreeNas and configure 1 dataset for each of them, which is require for replication task.

/wp-content/uploads/2016/06/11_974693.jpg

And attached each disk to its respective vm

/wp-content/uploads/2016/06/12_974694.jpg

/wp-content/uploads/2016/06/13_974695.jpg

This step done and check I can now start my Netweaver install by invoking my virtual hostname “vmapp”

/wp-content/uploads/2016/06/14_974696.jpg

/wp-content/uploads/2016/06/15_974697.jpg

/wp-content/uploads/2016/06/16_974698.jpg

/wp-content/uploads/2016/06/17_974702.jpg

/wp-content/uploads/2016/06/18_974703.jpg

/wp-content/uploads/2016/06/19_974704.jpg

/wp-content/uploads/2016/06/20_974705.jpg

Make sure the alias is use for the database hostname.

/wp-content/uploads/2016/06/21_974706.jpg

/wp-content/uploads/2016/06/22_974708.jpg

/wp-content/uploads/2016/06/23_974709.jpg

/wp-content/uploads/2016/06/24_974710.jpg

/wp-content/uploads/2016/06/25_974711.jpg

/wp-content/uploads/2016/06/26_974712.jpg

/wp-content/uploads/2016/06/27_974713.jpg

/wp-content/uploads/2016/06/28_974717.jpg

/wp-content/uploads/2016/06/29_974718.jpg

/wp-content/uploads/2016/06/30_974719.jpg

/wp-content/uploads/2016/06/31_974720.jpg

/wp-content/uploads/2016/06/32_974721.jpg

/wp-content/uploads/2016/06/33_974722.jpg

I won’t register my system for my test.

/wp-content/uploads/2016/06/34_974723.jpg

I will create an ACL for the message server

/wp-content/uploads/2016/06/35_974724.jpg

It’s just a test system so I’ll use the default key storage

/wp-content/uploads/2016/06/36_974725.jpg

/wp-content/uploads/2016/06/37_974729.jpg

I don’t install the diagnostic agent for my system because I’s not connect to Solution manager

/wp-content/uploads/2016/06/38_974730.jpg

Review the summary and run the installation

/wp-content/uploads/2016/06/39_974731.jpg

My system is now installed and up and running

/wp-content/uploads/2016/06/40_974732.jpg

I will make a connection over my saplogon to check the information retrieved

/wp-content/uploads/2016/06/41_974733.jpg

My application is connect on “vmhana04” database which is the primary site by using the “vmhana” alias and my application use “vmapp”

/wp-content/uploads/2016/06/42_974734.jpg

/wp-content/uploads/2016/06/43_974735.jpg

Configure SAP Hana Replication

My second site is already build and I have installed my second Hana instance with the same value as my primary site except for the hostname by using my config file generated earlier.

In my previous documentation I have explain how to configure HSR by using Hana Studio, in this one I’ll show I to perform the necessary action over command line with the tool “hdbnsutil

Before to start the configuration the primary site must be in log_mode “normal” and backup

/wp-content/uploads/2016/06/44_974736.jpg

For this setup I’ll use a dedicated network for replicated data, so I will set 3 parameter on both site in global.ini

  • [communication]  listeninterface = .internal
  • [internal_hostname_resolution]   ip of current site = hostname
  • [system_replication_hostname_resolution]  ip for replication of remote site = hostname of remote site

Once done I enable my site1 for replication by running: hdbnsutil -sr_enable –-name=site1

/wp-content/uploads/2016/06/45_974738.jpg

After the enablement of the site, I go on the secondary site and shutdown Hana

/wp-content/uploads/2016/06/46_974739.jpg

My secondary site down I can now register it as the secondary for replication by running:

hdbnsutil -sr_register –remoteHost=vmhana04 –remoteInstance=00 –mode=sync –name=Site2

Note : we can see that I’m using the ip for replication (10.10.15.119)

/wp-content/uploads/2016/06/47_974740.jpg

And to start the replication, I start my secondary site

/wp-content/uploads/2016/06/48_974741.jpg

Now competed i check the replication status, and configure FreeNas for storage replication in the second part of the documentation

SAP Hana TDI setup – SAP Hana HSR & SAP Netweaver  With file system replication (Part2)

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply