Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Performing a Rolling Upgrade with HA and DR node for SAP ASE 16.0 Business Suite Application

utkarshibm1
Discoverer
Friday
877

The steps for performing a rolling upgrade having both HA and DR Node are as follows-

In the document we have assumed Primary Node as SITEA, HA/Standby Node as SITEB and DR Node as SITEC for easy understanding.

Here is the sequence of steps we will perform-

  • Upgrade the DR node Replication Server and SAP ASE database at SITEC.
  • Upgrade the primary node Replication Server at SITEA.
  • Perform a failover from the primary node(SITEA) to the standby node(SITEB).
  • Upgrade the standby node Replication Server at SITEB.
  • Upgrade the primary node SAP ASE at SITEA.
  • Perform a fail back from the standby node (SITEB) to the primary node(SITEA).
  • Upgrade the standby node SAP ASE at SITEB.

Validate if replication between Primary to standby and Primary to DR node is working fine post upgrade.

SAP Application will be up and running fine while performing below steps.

Note: Complete the upgrade steps in a single sequence: partial upgrade is not supported (for example, we cannot upgrade some components now and then upgrade the other components at another time). Replication is suspended during some steps of a rolling upgrade, and if we perform a partial upgrade, logs continue to grow, which can result in logs, or the SPQ (simple persistent queue), running out of space. During a rolling upgrade, the versions between SAP ASE and Replication Server need not match.

Isql command to run any query-  isql -U <user> -P <password> -S<SID> -X -w999

For DR_ADMIN user run below query- isql -U DR_admin -P <password> -S<hostname>:<port> -X -w999

We use DR_ADMIN user to perform any task related to replication and our RMA port is 4909.

In below scenario we are upgrading ASE from 16.0 SP04 PL03 to 16.0 SP04 PL06

Pre-Steps:

  1. Please take screenshot of output of command sp_version and select @@version before proceeding with upgrade.
  2. Download the software using SAP Note # 2469889 - How to download current ASE patches and keep it in download directory on all three node
  3. Check if replication between SITEA, SITEB and SITEC is working fine before your proceed with the upgrade.
  4. Before running installer there should not be any running isql session. Kindly kill those running sessions before proceeding with upgrade

 Procedure:

  1. Upgrade SRS (SAP replication server) at Primary Node (SITEA).
  1. Log into the DR node's RMA as the user DR_admin using isql , and issue below command to start the upgrade process and then shutdown RMA

               isql -U DR_admin -P v<password> -S<hostname>:<port> -X -w999

             sap_upgrade_server SRS, start, SITEC(DR)

             go

           shutdown

          go

utkarshibm1_0-1720024988090.png

 

utkarshibm1_1-1720024988099.png

b. Install the new version of Replication Server using the setup.bin utility. Go to download directory extract the software using SAPCAR and run setup.bin

            <installation_directory>/setup.bin

utkarshibm1_2-1720024988112.png

Continue and choose option 1-

utkarshibm1_3-1720024988116.png

Select option 2 as per below screenshot-

utkarshibm1_4-1720024988126.png

At this point of time open a duplicate session and check if rma and repserver is stopped by running below commands

ps -ef | grep repserver

ps -ef | grep rma

Click on continue and select No for host Agent

utkarshibm1_5-1720024988141.png

Select country as applicable and accept the license agreement in next screens and continue with the installation.

utkarshibm1_6-1720024988156.png

utkarshibm1_7-1720024988160.png

Exit the installer and start RMA

c. Go to below location and run the command ./rma & to start the RMA

        Location- /Sybase/<SID>/ASE-16_0/bin

utkarshibm1_8-1720024988162.png

d. Log into RMA on the DR node as the DR_admin user and issue below command to complete the upgrade for Replication Server and RMA.

          sap_upgrade_server SRS, finish, SITEC(DR)

utkarshibm1_9-1720024988173.png

2. Upgrade the SAP ASE database at DR Node

  1. Unlock the “sa” user in case it is locked. Sa user is needed during upgrade process.

       sp_locklogin sa, “unlock”

utkarshibm1_10-1720024988177.png

         b. Log into the DR node's RMA as the DR_admin user  and issue sap_upgrade_server to start the                      upgrade for SAP ASE.

               sap_upgrade_server ASE, start, SITEC(DR)

utkarshibm1_11-1720024988190.png

 c. shutdown backup server and SAP ASE database server.

        shutdown SYB_BACKUP

         go

        shutdown

        go

utkarshibm1_12-1720024988193.png

 

utkarshibm1_13-1720024988200.png

 

utkarshibm1_14-1720024988204.png

d. Upgrade the DR node's SAP ASE database. Start the SAP installer from the installation directory

    <install_directory>/setup.bin

Run setup.bin from installation directory and select options as highlighted in below screenshot.

We need to select option “update ASE component in rolling upgrade” in this scenario.

utkarshibm1_15-1720024988207.png

utkarshibm1_16-1720024988212.png

utkarshibm1_17-1720024988222.png 

Select location(as applicable) and accept the license terms and proceed with installation.

utkarshibm1_18-1720024988231.png

 

 

utkarshibm1_19-1720024988236.png

Once Installation is completed it was ask for upgrading system stored procedure. Kindly proceed as below

utkarshibm1_20-1720024988246.png

utkarshibm1_21-1720024988254.png

utkarshibm1_22-1720024988262.png

utkarshibm1_23-1720024988274.png

e. Exit installer and run below commands to check the updated version of SAP ASE database.

       Select @@version

      sp_version  (it will give output of if all the stored procedures are upgraded)

utkarshibm1_24-1720024988296.png

utkarshibm1_25-1720024988299.png

f. In case above stored procedure did not upgrade correctly , kindly refer point 4 of SAP Note # 2653784 and upgrade it through “updatease” utility as shown below.

 

utkarshibm1_26-1720024988307.png

 

utkarshibm1_27-1720024988312.png

g. Check showsever command and check if backup server is started or not, if not kindly start backup server using below command

utkarshibm1_28-1720024988315.png

h.Log into DR node's RMA as the DR_admin user and issue sap_upgrade_server to finish the upgrade for SAP ASE

           sap_upgrade_server ASE, finish, SITEC(DR)

utkarshibm1_29-1720024988326.png

i. Lock the “sa” user by running below command through isql

        sp_locklogin sa, "lock"

j. At this point just check if replication is working fine at this stage

utkarshibm1_30-1720024988355.png

This completes the upgrade at DR node(SITEC).

3. Stop Fault Manager by issuing below command from bin directory of Fault Manager

         sybdbfm stop

 4. Upgrade the Primary node's Replication Server at SITEA.

  1.  Log into the Primary node’s RMA as DR_admin user , and issue below command. This shuts down the Primary node's(SITEA) Replication Server and RMA.

        sap_upgrade_server SRS, start, SITEA(Primary Node)

       go

      shutdown

      go

   Refer Procedure section 1 for screenshots.

b. Install the new version of Replication Server using the setup.bin utility. Go to download directory extract the software using SAPCAR and run setup.bin

         <installation_directory>/setup.bin

     Refer procedure section 1b for detailed screenshot and steps.

c. Go to below location and run the command ./rma & to start the RMA

          Location- /Sybase/<SID>/ASE-16_0/bin

d. Log into the Primary node's(SITEA) RMA as the DR_admin user  and issue sap_upgrade_server to finish the upgrade for the Replication Server.

      sap_upgrade_server SRS, finish, SITEA(primary Node)

utkarshibm1_31-1720024988368.png

5. Now, Fail over from the Primary node(SITEA) to the HA node(SITEB). Log into the Primary node's RMA as DR_admin user  and issue below commands.

          sap_failover SITEA(primary), SITEB(HA), 30

          sap_failover_drain_to_dr 30

        sap_host_available SITEA(Primary)

         sap_host_available SITEC(DR)

 

6. Upgrade the HA node's (SITEB) Replication Server.                                                                            

  1. Log into the HA node’s (SITEB) RMA as  DR_admin, and issue below commands to shut down the HA node's Replication Server and RMA.

       sap_upgrade_server SRS, start, SITEB (HA)

        go

       shutdown

        go

  b. Install the new version of Replication Server using the setup.bin utility. Go to download directory         extract the software using SAPCAR and run setup.bin

            <installation_directory>/setup.bin

c. Start the RMA at SITEB(HA Node)

          Go to location /Sybase/<SID>/ASE-16_0/bin and run command ./rma &

d. Log into the HA node's (SITEB) RMA as the DR_admin user  and issue sap_upgrade_server to finish the Replicatin Server upgrade.

           sap_upgrade_server SRS, finish, SITEB(HA).

7. Upgrade the Primary node's (SITEA) SAP ASE database.

a. Unlock “sa” user by running below command

          sp_locklogin sa, “unlock”

b. Log into Primary node's (SITEA) RMA as the DR_admin user with 4909 port and issue              sap_upgrade_server to start the SAP ASE upgrade.

         sap_upgrade_server ASE, start, SITEA(Primary)

c. Shut down the Primary node's (SITEA) Backup Server and ASE database. Log into the Primary node's SAP ASE and issue below commands-

        shutdown SYB_BACKUP

         go

        shutdown

         go

d. Upgrade the PR node's (SITEA) SAP ASE. Start the SAP installer from the installation directory and follow procedure step 2d to 2g.

         <install_directory>/setup.bin

e. Log into the Primary node's (SITEA) RMA as the DR_admin user and issue sap_upgrade_server to finish the upgrade for SAP ASE.

           sap_upgrade_server ASE, finish, SITEA(primary Node)

f. lock the “sa” user at primary Node(SITEA) by running below command-

          sp_locklogin sa, "lock"

8. Fail back from the HA node(SITEB) to the Primary node(SITEB). Log into the HA node's RMA as DR_admin user and 4909 port and issue below commands.

         sap_failover SITEB(HA), SITEA(PR), 30

        sap_failover_drain_to_dr 30

        sap_host_available SITEB(HA)

        sap_host_available SITEC(DR)

9. Upgrade the HA node's SAP ASE database at SITEB

  a. Unlock “sa” user by running below command-

           sp_locklogin sa, “unlock”

b.Log into the HA node's RMA (at SITEB) as the DR_admin user and issue sap_upgrade_server to start the upgrade for SAP ASE.

         sap_upgrade_server ASE, finish, SITEB (HA Node)

c.Shut down the HA node's (SITEB) Backup Server and ASE database. Log into the HA node's SAP ASE and issue below commands.

          shutdown SYB_BACKUP

           go

          shutdown

           go

d. Upgrade the HA node's (SITEB) SAP ASE. Start the SAP installer from the installation directory and follow procedure step 2d to 2g.

          <install_directory>/setup.bin

e. Log into the HA node's (SITEB) RMA as the DR_admin user and issue sap_upgrade_server to finish the upgrade for SAP ASE.

           sap_upgrade_server ASE, finish, SITEB (HA Node)

f. Lock the “sa” user by running below command at HA node(SITEB)

          sp_locklogin sa, "lock".

10. Start the Fault Manager by issuing below command.

         <Fault_Manager_install_dir>/FaultManager/sybdbfm_<CID>

 

This way we can Upgrade the SAP ASE database with HA and DR node with zero downtime.

Validate the replication by running command ‘sap_status path” once above processes are finished.

 

Labels:
2 Comments
Labels in this area
Popular Blog Posts