HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present
There are many environments and larger landscapes where we have cluster environment.But in this environment we have Primary DB replicated with the secondary DB where the primary system is up an running and replicated to the secondary DB/DR Server.
Few of the pre requisites of Performing HANA SPS upgrade are defined in the below blog written by me
https://blogs.sap.com/2020/06/24/solution-for-hana-revision-ugrade-method-when-dependent-components-...
Note:
While performing the HANA SPS upgrade or HANA revision upgrade first the upgrade needs to be performed to the DR/secondary server before performing it on the primary server
Reason:The version present on the DR/secondary server should be higher or similar to that of the primary server.
Below is the methodology for Performing HANA SPS upgrade on DR server which replicated to primary server
Note:Disable replication on primary by checking ignore secondary option(Don’t do unregister from secondary bcz secondary DB needs to be down for unregistering.But we want system to be up for hana revision upgrade.If we bring down the DB for unregistering again we need to start DB manually but it was not coming up in our case)So only disable replication from on primary by checking ignore secondary option
1.Go to HANA studio and right click(This should be performed on systemdb)
2.Disable replication
3.Click on ignore secondary system and give finish
2.Confirm that replication is disabled from Landscape tab from HANA studio.In replication status active should not be present(Double click on systemdb)
3.Download and extract the softwares as per the my previous blog.
https://blogs.sap.com/2020/06/24/solution-for-hana-revision-ugrade-method-when-dependent-components-...
4.Once the software preparation is finished.Intiate the upgrade as below.
Note:Here we will be upgrading through command line interface.Infact there are other ways also like graphical user interface etc
Upgrading the HANA 2.0 SPS from rev 37 to HANA 2.0 rev 59
1 step-
Go to the location where softwares are extracted and kept in the location.I had kept the softwares in /hana/shared then trigger the hdblcm
Go to the softwares location in extracted folder further SAP HANA DATABASE folder and run
./hdblcm(from root user)
2 step-
Select 1
3 step-
Select 2
4 Step-
Give the sidadm password,SYSTEM user,SYSTEM Password,y and y
5
th Step
Upgrade will be started
6
th Step
Upgrading of patches will be completed and in the last step as pet the standard process of upgrade system will start the HANA process which will get stuck.Even when we try to bring the DB manually through HDB start HANA will not come up
Here is the solution for the above issue.
So we followed below procedure
Note:Below procedure should be executed in only secondary DB
1.Login into the secondary DB server
switch to hdbadm
ps –ef|grep hdbdadm
kill -9 <all the workprocess>
2.Unregister the secondary DB by the below commands
Switch to hdbadm
hdbnsutil –sr_unregister in secondary
3.Cleanup the stuck persistence in secondary
Switch to hdbadm
hdbnsutil -sr_cleanup –force
4.Go to primary DB in hana studio and enable replication(From systemdb)
Steps
Go to HANA studio->Right click on the systemdb->Select configuration and monitoring->Enable replication->provide hostname and instance number and finish
5.In secondary DB from OS level register the replication by the below commands
Switch to hdbadm
hdbnsutil -sr_register --name=<name of secondary site> --replicationmode=async --operationMode=logreplay --remoteHost=<primary hostname> --force_full_replica --remoteInstance=<instance num of primary>
6.Start the secondary DB
Switch to hdbadm
HDB start
7.HANA SPS version will be changed and replication will also be enabled
Conclusion-Hence above is the procedure to perform HANA SPS upgrade from version 3 to version 5 on DR server when there is primary and secondary server setup for replication