SAP HANA Database 2.0 High Availability Step By Step process

-

 Introduction

This blog post walk’s you through the step by step process for SAP HANA 2.0 high availability setup.  How to add a stand by host.

A distributed HANA(scale out) setup need 2 servers (one worker, another  standby).

Note : Both Host1 and Host2  server’s date and time should be same.

Below mentioned are the steps that need to followed for high availability setup.

Host 1 (worker)

SID = HDB

Instance Number = 00

Hostname = ca

Host Role = worker

Host 2 (Standby)

SID = HDB

Instance Number = 00

Hostname = portal

Host Role = Standby

 

NFS(network file system) is used to share the files between host1(worker) and host2(standby) (/hana/log, /hana/shared, /hana/data)

*Operating system used SUSE Linux SP15

  • Configure NFS server on host1 (ca)

  • Configure NFS client on host2 (portal)

 

  •    Install SID= HDB, master node (Host1) using installation media’s HDBLCM

 

  • On master node(Host1) execute action configure_internal_network (using resident HDBLCM) “./hdblcm –action=configure_internal_network“

 

  • Inter-service communication is configured now

 

  • On second node (Host2) navigate to /hana/shared/SID/hdblcm and execute “./hdblcm” to add host to master node

  • The below screen, shows services after adding standby node

  • Hosts – after adding standby node:

 

I hope this blog post information is helpful. can go through the below links for further reference (S-User needed to access the links)

https://help.sap.com/doc/eb75509ab0fd1014a2c6ba9b6d252832/2.0.00/en-US/SAP_HANA_Administration_Guide_en.pdf

Comments

Post a Comment

Popular posts from this blog

SAP Business One Web Client Tiles Not Loading (tiles.svc 500 Internal Server Error)

-
Image
Error: W hile trying to read the field 'bind' of a null object loaded from field com.sap.b1.infra.meta.tile.Tile.action of an object loaded from local variable 'tile" when we are logging into specific company Issue: This issue mainly occurs when adding any web client extension tile to the web client home page and you unassign the extension from the extension manager. Solution: Delete the existing users from the SAP Business One and OUSR table and then recreate the user. Then tiles should load in the Web client.
Read more

SAP Business One Company Initialization Error SAP DBTech JDBC: [259]: invalid table name: Could not find table/view M_TIME_DIMENSION in schema _SYS_BI

-
Image
 Error:  2022-04-29 11:03:39|ERROR|ENABLEMENT|Failed to re-initialize company :module id=Hana Model Deployer; cause:com.sap.businessone.model.renew.exception.ModelException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| 2022-04-29 11:03:38|ERROR|MODEL_DEPLOYMENT|Failed to execute sql statement: Create View Next6MonthEndView  as Select Top 6 Year, Month, Max(Date_SQL) as MonthEnd From _SYS_BI.M_TIME_DIMENSION Where Date_SAP <= Last_Day(Add_Months(Add_Days(CURRENT_DATE, 1-DayOfMonth(CURRENT_DATE)), 6)) and Date_Sql >Last_Day(CURRENT_DATE) Group By Year , Month Order By Year Desc, Month Desc, root cause: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| Solution:   Login to HANA studio  Run the below Query from SYSTEM...
Read more