Ceci est une ancienne révision du document !

Patch ODA from 19.20 to 19.21

The patch 19.20 to 19.21 will use the Data Preserving method

The main steps will be

Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning

Download the Oracle Database Appliance Server Patch (patch 35938481)
Unzip the software
Update the repository with the server software
Update DCS admin
Update the DCS components
Update the DCS agent
Create the pre-upgrade report to run upgrade pre-checks
Detach the system for an operating system upgrade
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

Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch (patch 35938481)
Create the pre-patch report
Apply the server update
Run Prepatch report for the storage
Update the storage components
Update the storage components patch 30403673
Restore Oracle Grid Infrastructure
Restore the database

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