Wednesday, 4 April 2018

SAP Hana 2.0 hybrid Landscape Management with LaMa 3.0 & Solution Manager 7.2 Part-2

Configure Microsoft Azure connector for SAP LaMa


The Azure connector for SAP LaMa will allow me to perform several operations directly onto Azure such as activate or power off VMs, do SAP system relocate or perform SAP system copy/clone.
However, not all Azure resources are supported, only VMs deployed by ARM with managed disks are supported, VMs deployed in availability zone are currently not supported.

That thing says, let’s proceed with the setup. From Azure I will start to register a new app from AAD

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Note that the url can be random since the sign-on url is not used

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

My new app created I will click on setting and select the keys to create a new key, I will note the Application ID since it use as user name of the service principal used.

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once saved my key value appear so I save it

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Let’s now give my service principal user access to my entire Azure subscription, from the subscription list I choose my subscription and click on IAM to add user

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

AS a permission I provide “Owner” in order for the user to have full control on my subscription resources and as username I provide the application ID

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

I’m done for the Azure side, now I will configure the SAP LaMa part. On the Infrastructure panel select “Cloud Manager” and click Add

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Select Microsoft and click Next
Note: Before SAP LaMa .30 SP5 the adapter needs to be enable manually

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Enter the necessary information such as username is the application ID and the password the key generated earlier.
You will also need to provide your Subscription ID and tenant ID which can be retrieved from PowerShell after login in Azure

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Now if I check under virtual host I can see the template option available for me in order to deploy vm based on my personal one on Azure

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

And if I move further, I can now see all my resources group as well for me to deploy my template into

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

We are done for this part, I will explain later on the Azure specific part, for now I will install SAP Hana on Azure and show how to proceed with the registration on LaMa.

Register SAP Hana 2.0 from Azure in SAP LaMa


Before to deal with installation of SAP Hana it is important to make sure to set the VM properly, I have created a dedicated resource group to store all my object in order to not mix then with other artifact

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Now the most important thing, make sure to select manage disk since this only the supported type of disk by SAP on Azure, you can also see that I have select my specific VNet attached to the VPN which lead to the auto selection of the subnet.
If have also disable the public ip since I don’t want my server to be accessed directly from outside.

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once my server is up and running, I register it into my Azure DNS so it will be replicated in my on-premise DNS

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

I do a quick test from my SAP LaMa server at the OS layer, the name is resolve and I can ssh in my server on Azure from on-premise

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

My Hana on Azure installed I can connect to it

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

So now that my Hana on Azure is up, before to add it into SAP LaMa, the necessary Adaptive Extension needs to be installed.
Note that because I’m running on cloud the EXT version needs to be used

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once download run the following command from the hostcontrol folder

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Final step register my instance in SAP LaMa, from the configuration tab I will my hostname and domain

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

My two Hana system shows up

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

All set for this part, my two instances are managed and ready for HSR configuration

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Setup Replication between On-Premise and Azure with SAP LaMa


Before to start the replication, setup make sure to perform all necessary prerequisite, such as back all primary database (system & tenant), have the log_mode set in “normal”, copy the PKI SSF.key from the primary Hana system to the secondary.

Note: I have intentionally not created any tenant database on my second instance in order to replicate them from my on-premise environment.

The replication setup can be performed at many place, Hana studio, Hana cockpit, OS layer with hdbnsutil tool or SAP LaMa. I will show you how to proceed with SAP LaMa.

From the dashboard, go on the operations action and select the systemdb from my primary site, then select SAP Hana Replication to be enable

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Provide a Site name and enable it

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

LaMa will proceed with the enablement

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once done we can see this

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

I have shutdown my Azure instance before to proceed with the registration, so now I can register it as secondary tier

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

On this step I specify the necessary option I want to work with

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once the system restart, you can now see that take over action is available

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Let’s do some check, first I look at the hana studio, I see my 2 servers and the replication initialized

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

From the cockpit something

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once done the replication is active

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Ok so my replication between my on-premise environment and Azure is running, I will then include my system is Solution Manager

Configure Solution Manager monitoring


The monitoring portion in Solution Manager, what ever the version involves several steps as well as component that needs to be deployed and/or configured.

Because of such, I will convert it in a light way and highlight the base line part. The first part will consist to register my both Hana instance in my SLD in order to be replicated in LMDB.

From the cockpit, select the system database and form Lifecycle Management choose SLD registration

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Provide the SLD information and click next to proceed

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

When the operation is done from both Hana system check the entries in SLD

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Now done, I install the diagnostic agent on both sever and register them into the SLD as well

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

And check into my sld the registration

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

As well as agent registration from the administration side

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

When diagnostic agents are register, from the Solution Manager Configuration, i need to configure every Hana system as a manage system

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once the system is configured, they need to be assigned to a monitoring template in order to read system information’s and generate metrics

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

When all my system has an associate template, from the workcenter I can see them now

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

You probably noticed, red light and yellow … it’s normal because I did not push all the setup and just wanted to provide the major step to process the monitoring.

Now done with my monitoring setup, I will perform my Hana failed-over process within SAP LaMa.

Perform SAP Hana takover with SAP LaMa


SAP LaMa 3.0 allows you to perform various task from a replication point of view, to my takeover task, I go on the Operation dashboard and select the secondary instance in Azure

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Expend operation, select SAP Hana Process and choose “Take over”

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

While it’s happening, I can the lock on the instance because it’s processing it

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

To see what is going on in term of process, from the Monitoring dashboard I select activities and select my task associated

SAP HANA 2.0, SAP HANA Certifications, SAP HANA Materials, SAP HANA Guides, SAP HANA Learning

Once the takeover is completed, make sure to discover the new tenant replicated from the primary site, as well as process with Solution Manager monitoring setup for them.

My configuration is now completed for the simple replication and takeover process in SAP LaMa for SAP Hana, in my next document I will elaborate more scenario with HSR as well as dedicated Microsoft Azure resource deployment.