oracle:oda:patch_oda_from_19.20_to_19.21 [MDL Wiki]

Ceci est une ancienne révision du document !

The patch 19.20 to 19.21 will use the Data Preserving method

The main steps will be

Detach resources and software from the source version of the appliance
Reimage nodes using the Oracle Database Appliance ISO image
Restore nodes using the Data Preserving Reprovisioning method
Update Existing dbhomes

Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning

1- Download the Oracle Database Appliance Server Patch (patch 35938481) 2- Unzip the software 3- Update the repository with the server software 4- Update DCS admin 5- Update the DCS components 6- Update the DCS agent 7- Create the pre-upgrade report to run upgrade pre-checks 8- Detach the system for an operating system upgrade 9- Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance system

Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning

Download the Oracle Database Appliance release 19.21 bare metal ISO image and reimage the appliance (Patch 30403643)

Plumb the network as described in the topic Plumbing the Network configure-firstnet.rsp ( in the zip file saved)

Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method 1- Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch (patch 35938481) 2- Create the pre-patch report 3- Apply the server update 4- Run Prepatch report for the storage 5- Update the storage components 6- Update the storage components patch 30403673 7- Restore Oracle Grid Infrastructure 8- Restore the database

Below the detailled steps for the patching

Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning 1.1 Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 35938481) 1-2 Unzip the patch [root@moros patch_1921]# unzip p35938481_1921000_Linux-x86-64.zip Archive: p35938481_1921000_Linux-x86-64.zip extracting: oda-sm-19.21.0.0.0-231220-server.zip

inflating: README.txt

[root@moros patch_1921]#

1.3 Update the repository with the server software file [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip {

"jobId" : "187e6c62-c356-4327-b7df-0a9e3d5f084e",
"status" : "Created",
"message" : "/u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip",
"reports" : [ ],
"createTimestamp" : "January 15, 2024 10:58:25 AM CET",
"resourceList" : [ ],
"description" : "Repository Update",
"updatedTime" : "January 15, 2024 10:58:25 AM CET",
"jobType" : null

} [root@moros patch_1921]#

Validate the job status

[root@moros patch_1921]# odacli describe-job -i “187e6c62-c356-4327-b7df-0a9e3d5f084e”

Job details

                   ID:  187e6c62-c356-4327-b7df-0a9e3d5f084e
          Description:  Repository Update
               Status:  Success
              Created:  January 15, 2024 10:58:25 AM CET
              Message:  /u01/Downloads/patch_1921/oda-sm-19.21.0.0.0-231220-server.zip

Task Name Start Time End Time Status —————————————- ———————————– ———————————– ———- Unzip bundle January 15, 2024 10:58:25 AM CET January 15, 2024 10:58:58 AM CET Success

[root@moros patch_1921]#

1.4 Update DCS admin [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.21.0.0.0 {

"jobId" : "f53559f1-8828-482a-8bb7-111e2b75377d",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "January 15, 2024 11:01:16 AM CET",
"resourceList" : [ ],
"description" : "DcsAdmin patching",
"updatedTime" : "January 15, 2024 11:01:16 AM CET",
"jobType" : null

} [root@moros patch_1921]#

Validate the job

[root@moros patch_1921]# odacli describe-job -i “f53559f1-8828-482a-8bb7-111e2b75377d”

Job details

                   ID:  f53559f1-8828-482a-8bb7-111e2b75377d
          Description:  DcsAdmin patching
               Status:  Success
              Created:  January 15, 2024 11:01:16 AM CET
              Message:

Task Name Start Time End Time Status —————————————- ———————————– ———————————– ———- Patch location validation January 15, 2024 11:01:16 AM CET January 15, 2024 11:01:16 AM CET Success Dcs-admin upgrade January 15, 2024 11:01:16 AM CET January 15, 2024 11:01:22 AM CET Success

[root@moros patch_1921]#

1.5 Update the DCS components

[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.21.0.0.0 {

"jobId" : "9bffdad6-9af3-4c04-a697-2470c9e63d8e",
"status" : "Success",
"message" : " DCS-Agent shutdown is successful. Skipping MySQL upgrade on OL7 Metadata schema update is done. dcsagent RPM upgrade is successful. dcscli RPM upgrade is successful. dcscontroller RPM upgrade is successful.  Successfully reset the Keystore password.  HAMI is not enabled  Skipped removing old Libs. Successfully ran setupAgentAuth.sh ",
"reports" : null,
"createTimestamp" : "January 15, 2024 11:04:22 AM CET",
"description" : "Update-dcscomponents job completed and is not part of Agent job list",
"updatedTime" : "January 15, 2024 11:05:30 AM CET"

} [root@moros patch_1921]#

1.6 Update the DCS agent

[root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.21.0.0.0 {

"jobId" : "4c5cbf22-0e70-4f80-acef-33f57eb542ff",
"status" : "Created",
"message" : "DCS agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands",
"reports" : [ ],
"createTimestamp" : "January 15, 2024 11:07:11 AM CET",
"resourceList" : [ ],
"description" : "DcsAgent patching",
"updatedTime" : "January 15, 2024 11:07:11 AM CET",
"jobType" : null

} [root@moros patch_1921]#

Validate the job

[root@moros patch_1921]# odacli describe-job -i “4c5cbf22-0e70-4f80-acef-33f57eb542ff”

Job details

                   ID:  4c5cbf22-0e70-4f80-acef-33f57eb542ff
          Description:  DcsAgent patching
               Status:  Success
              Created:  January 15, 2024 11:07:11 AM CET
              Message:

Task Name Start Time End Time Status —————————————- —————————————- —————————————- ———- Dcs-agent upgrade to version January 15, 2024 11:07:11 AM CET January 15, 2024 11:09:29 AM CET Success 19.21.0.0.0 Update System version January 15, 2024 11:09:29 AM CET January 15, 2024 11:09:29 AM CET Success

[root@moros patch_1921]#

1.7 Run upgrade pre-checks [root@moros patch_1921]# odacli create-preupgradereport -bm

Job details

                   ID:  61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
          Description:  Run pre-upgrade checks for Bare Metal
               Status:  Created
              Created:  January 15, 2024 11:12:22 AM CET
              Message:  Use 'odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905' to check details of results

Task Name Start Time End Time Status —————————————- —————————————- —————————————- ———-

[root@moros patch_1921]#

Check the report, any error should be corrected

[root@moros patch_1921]# odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905

Upgrade pre-check report

               Job ID:  61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
          Description:  Run pre-upgrade checks for Bare Metal
               Status:  SUCCESS
              Created:  January 15, 2024 11:12:22 AM CET
               Result:  All pre-checks succeeded

Node Name

moros

Check Status Message Action —————————— ——– ————————————– ————————————– GI Check presence of databases Success No additional database found None not managed by ODA registered in CRS Check custom filesystems Success All file systems are owned and used None

                                      by OS users provisioned by ODA

Check presence of HAVIP Success No HAVIP resources found registered None resources not managed by ODA in CRS Check presence of export Success No EXPORT resources found registered None resources not managed by ODA in CRS

OS Check Required OS files Success All the required files are present None Check Additional OS RPMs Alert Additional OS RPMs, compared to the None; the list of these RPMs can be

                                      base ODA image, are installed on the   found at
                                      system                                 '/opt/oracle/dcs/log/
                                                                             reprovision-custom-rpms.list'. The
                                                                             upgraded versions of these rpms will
                                                                             have to be reinstalled manually after
                                                                             reimage

STORAGE Check Required Storage files Success All the required files are present None Validate OAK Disks Success All OAK disks are in valid state None Validate ASM Disk Groups Success All ASM disk groups are in valid state None Validate ASM Disks Success All ASM disks are in valid state None Check Database Home Storage Success The volume(s) orahome_sh,odabase_n0 None volumes state is CONFIGURED. Check space under /opt Success Free space on /opt: 68753.72 MB is None

                                      more than required space: 1024 MB

Check space in ASM disk Success Space required for creating local None group(s) homes is present in ACFS database

                                      home storage. Required: 0 GB
                                      Available: 74 GB

SYS Validate Hardware Type Success Current hardware is supported None Validate ILOM interconnect Success ILOM interconnect is not enabled None Validate System Version Success System version 19.21.0.0.0 is None

                                      supported

Verify System Timezone Success Succesfully verified the time zone None

                                      file

Verify Grid User Success Grid user is verified None Verify Grid Version Success Oracle Grid Infrastructure is running None

                                      on the '19.20.0.0.230718' version on
                                      all nodes

Check Audit Files Success Local Audit files not found None

DB Validate Database Status Success Database 'REPOCDB' is running and is None

                                      in 'CONFIGURED' state