SAP on Azure: SAP Netweaver 7.5 with ASE 16 on Linux – High Availability Setup of SAP ASE DB with Floating IP using Azure Standard Load Balancer

DB Replication Setup on Primary DB

Sample DMA and Setup_hadr files

DB Replication Setup on Secondary DB

Sample DMA and Setup_hadr files.

Copy/Download the PDF files to create the ‘.rs’ files in text editor.

SAP On Azure : Azure Enhanced Monitoring Extension for SAP in Windows

Introduction

The Azure Enhanced Monitoring Extension for SAP provides configuration information and performance data of the underlying Azure infrastructure and makes it available to the SAP application. It contains built-in self-diagnostics which enables identification of the health and completeness of the infrastructure data required by SAP services and support.

Having set up the Azure Enhanced Monitoring Extension for SAP, the Windows service AzureEnhancedMonitoring is installed inside the VM and collects all Azure-related data. Afterwards, this data is consumed by SAP Host Agent for further use in the SAP system transaction ST06.

Setup Azure Enhanced Monitoring(AEM) for SAP

  • Check the status in ST06 before enabling AEM
  • Open RemoteDesktop Session and login as admin user
  • Open the PowerShell and Check the Power Shell version

$PSVersionTable.PSVersion

Major Minor Build Revision
—– —– —– ——–
5 1 17763 1007

Azure PowerShell works with PowerShell 5.1 or higher on Windows. To run Azure PowerShell in PowerShell 5.1 on Windows:

  1. Update to Windows PowerShell 5.1 if needed. If you’re on Windows 10, you already have PowerShell 5.1 installed.
  2. Install .NET Framework 4.7.2 or later.
  • Install the Azure Module for PowerShell

Install-Module -Name Az -AllowClobber -Scope AllUsers

  • Run the following PowerShell cmdlet

$env = Get-AzEnvironment -Name AzureCloud

Connect-AzAccount -Environment $env

Set-AzContext -SubscriptionName <subscription name>

Set-AzVMAEMExtension -ResourceGroupName <resource group name> -VMName <virtual machine name>

Above screen shows status as OK for the AEM deployment.

  • Test the AEM Deployment

Test-AzVMAEMExtension -ResourceGroupName <resource group name> -VMName <virtual machine name>

  • Readiness check for the AEM deployment

Perform the check by performing following step.

  1. Open the command prompt in the VM and change to directory to the installation folder of the Azure Extension for SAP. C:\Packages\Plugins\Microsoft.AzureCAT.AzureEnhancedMonitoring.AzureCATExtensionHandler\<version>\drop
  2. At the command prompt, run azperflib.exe without any parameters

Health status and Diagnostics status are in OK state. Empty Counters are 0.

  • Confirm the status in Tr Code ST06

This completes the setup of Azure Enhanced Monitoring for SAP on Windows Operating System.

Azure Enhanced Monitoring Extension (New Version)

Microsoft has released a New version of AEM for SAP and its suitable for specific scenarios as mentioned below, otherwise its perfectly fine to use the version and steps mentioned above.

  1. You want to install the extension with Terraform, Azure Resource Manager Templates or with other means than Azure CLI or Azure PowerShell.
  2. Microsoft or SAP support asks you to install the new extension
  3. You want to use Azure Ultra Disk or Standard Managed Disks

Prechecks :

  1. Make sure to use SAP Host Agent 7.21 PL 47 or higher.
  2. Make sure to uninstall the current version of the VM Extension for SAP. You can do this from Azure portal by selecting the ‘Extentions’ in the Settings section for the VM. It is not supported to install both versions of the VM Extension for SAP on the same virtual machine.

Steps :

Following are the PowerShell commands to run to setup the AEM for SAP.

$env = Get-AzEnvironment -Name <name of the environment>

Connect-AzAccount -Environment $env Set-AzContext -SubscriptionName <subscription name>

Set-AzVMAEMExtension -ResourceGroupName <resource group name> -VMName <virtual machine name> -InstallNewExtension

Testing :

Test the AEM deployment by executing the PowerShell script.

Test-AzVMAEMExtension -ResourceGroupName <resource group name> -VMName <virtual machine name>

Readiness Check :

  1. Open a web browser and navigate to http://127.0.0.1:11812/azure4sap/metrics
  2. The browser should display or download an XML file that contains the monitoring data of your virtual machine. 
  3. Check the value of the Provider Health Description element, value must be OK.

References

SAP on Azure : Setup squid Proxy Server for SAP HA on SUSE

During the high availability setup of SAP NetWeaver OR S/4 HANA system in Microsoft Azure Cloud, we need to deploy Standard Internal Load Balancer(ILB) to define virtual IP for the Linux Pacemaker Cluster SAP NetWeaver for ASCS OR DB VM nodes which are part of backend pool of Internal Load Balancer(ILB), outgoing internet connections may not be available for those Vms. This causes issues with Azure Fencing agent, SMT server ( for patch update), backup to blob etc.

As a workaround we can setup proxy server in SAP application server VM and direct ASCS and DB cluster nodes to connect to proxy for outbound internet connection.

Steps to follow

1. Install squid proxy server in a application server.

>>zypper in squid

>>systemctl start squid

>>systemctl enable squid

>>vi /etc/squid/squid.conf and add entry to allow the vnet to be connected this proxy.

acl localnet src xx.xx.xx.xx/yy

>>systemctl restart squid

2. In the ASCS Cluster node

Select Enable Proxy.

In HTTP Proxy URL, enter IP address of app server which is running squid proxy and “:3128” (or the http port defined in the file squid.conf in the proxy server.

Select ‘Use the Same Proxy for all Protocols”

3. Test from ASCS Node if outbound connection is working by running

>>curl google.com

>>sudo zypper update

References

https://www.linuxhelp.com/how-to-install-and-configure-squid-proxy-server-on-opensuse-leap-42-1

https://www.netiq.com/documentation/platespin-transformation-manager-1-1/ptm_appliance/data/config-proxy.html

Anjan Banerjee

Anjan Banerjee – Sr. Customer Engineer 

Anjan’s area of focus includes SAP on Azure in which he is helping customers in designing SAP solutions with high availability, disaster recovery, performance optimization, Backup & Archive, DevTest scenarios and its smooth deployment on Azure.

Anjan’s IT career spans 20 years, in which he has worked in various industries such as Manufacturing, Finance, Telecom, and Pharma where he has specialized in large enterprises designing & supporting mission critical systems. He has deep experience in SAP project management, technical architecture design, SAP Implementation, Upgrade and Unicode conversion, SAP Migrations, SAP HANA & Oracle database management and infrastructure management in SAP. He specializes in Virtualization technologies, high availability, clustering and disaster recovery scenarios.

Design a site like this with WordPress.com
Get started