meta données pour cette page
Patch ODA from 19.20 to 19.21
This procedure includes ODA reimaging
For the patch 19.20 to 19.21, there is OS upgrade from OL7 to OL8, the OS FS is wiped
This procedure 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 Validate Database Version Success Version '19.20.0.0.230718' for None database 'REPOCDB' is supported Validate Database Datapatch Success Database 'REPOCDB' is completely None Application Status applied with datapatch Validate TDE wallet presence Success Database 'REPOCDB' is not TDE None enabled. Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database REPOCDB Validate Database Status Success Database 'OKVCOE' is running and is None in 'CONFIGURED' state Validate Database Version Success Version '19.20.0.0.230718' for None database 'OKVCOE' is supported Validate Database Datapatch Success Database 'OKVCOE' is completely None Application Status applied with datapatch Validate TDE wallet presence Success Database 'OKVCOE' is not TDE enabled. None Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database OKVCOE Validate Database Status Success Database 'NOTDEOKV' is running and is None in 'CONFIGURED' state Validate Database Version Success Version '19.20.0.0.230718' for None database 'NOTDEOKV' is supported Validate Database Datapatch Success Database 'NOTDEOKV' is completely None Application Status applied with datapatch Validate TDE wallet presence Success Database 'NOTDEOKV' is not TDE None enabled. Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database NOTDEOKV Validate Database Status Success Database 'TDEOKV' is running and is None in 'CONFIGURED' state Validate Database Version Success Version '19.20.0.0.230718' for None database 'TDEOKV' is supported Validate Database Datapatch Success Database 'TDEOKV' is completely None Application Status applied with datapatch Validate TDE wallet presence Success TDE Wallet Management of database None 'TDEOKV' is ODA. Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database TDEOKV Validate Database Status Success Database 'ONTDEOKV' is running and is None in 'CONFIGURED' state Validate Database Version Success Version '19.20.0.0.230718' for None database 'ONTDEOKV' is supported Validate Database Datapatch Success Database 'ONTDEOKV' is completely None Application Status applied with datapatch Validate TDE wallet presence Success Database 'ONTDEOKV' is not TDE None enabled. Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database ONTDEOKV Validate Database Status Success Database 'MYTDE' is running and is in None 'CONFIGURED' state Validate Database Version Success Version '19.20.0.0.230718' for None database 'MYTDE' is supported Validate Database Datapatch Success Database 'MYTDE' is completely None Application Status applied with datapatch Validate TDE wallet presence Success Database 'MYTDE' is not TDE enabled. None Skipping TDE wallet presence check. Validate Database Home Success Database home location check passed None location for database MYTDE __CERTIFICATES__ Check using custom Success Using Default key pair None certificates Check the agent of the DB Success All the agents of the DB systems are None System accessible accessible [root@moros patch_1921]#
- 1.8 detach the system for an operating system upgrade
[root@moros patch_1921]# odacli detach-node -all ******************************************************************************** IMPORTANT ******************************************************************************** 'odacli detach-node' will bring down the databases and grid services on the system. The files that belong to the databases, which are stored on ASM or ACFS, are left intact on the storage. The databases will be started up back after re-imaging the ODA system using 'odacli restore-node' commands. As a good precautionary measure, please backup all the databases on the system before you start this process. Do not store the backup on this ODA machine since the local file system will be wiped out as part of the re-image. ******************************************************************************** Do you want to continue (yes/no)[no] : yes { "jobId" : "36428cf3-16a3-4ad2-aa2a-48d772c73eee", "status" : "Created", "message" : "On successful job completion, the server archive file will be generated at /opt/oracle/oak/restore/out. Please copy the server archive file outside of the ODA system before re-image", "reports" : [ ], "createTimestamp" : "January 15, 2024 11:23:11 AM CET", "resourceList" : [ ], "description" : "Detach node service creation for upgrade", "updatedTime" : "January 15, 2024 11:23:11 AM CET", "jobType" : null } [root@moros patch_1921]#
- Validate the job
[root@moros patch_1921]# odacli describe-job -i "36428cf3-16a3-4ad2-aa2a-48d772c73eee" Job details ---------------------------------------------------------------- ID: 36428cf3-16a3-4ad2-aa2a-48d772c73eee Description: Detach node service creation for upgrade Status: Success Created: January 15, 2024 11:23:11 AM CET Message: On successful job completion, the server archive file will be generated at /opt/oracle/oak/restore/out. Please copy the server archive file outside of the ODA system before re-image Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Creating initialization file January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Creating firstnet response file January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Saving system information January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Saving Appliance data January 15, 2024 11:23:11 AM CET January 15, 2024 11:24:42 AM CET Success Saving OS files January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Saving CPU cores information January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Saving storage files January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:11 AM CET Success Saving Volumes January 15, 2024 11:23:11 AM CET January 15, 2024 11:23:20 AM CET Success Saving File Systems January 15, 2024 11:23:20 AM CET January 15, 2024 11:23:27 AM CET Success Saving Quorum Disks January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:27 AM CET Success Saving System January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:27 AM CET Success Saving Networks January 15, 2024 11:23:27 AM CET January 15, 2024 11:23:28 AM CET Success Saving Database Storages January 15, 2024 11:23:28 AM CET January 15, 2024 11:24:12 AM CET Success Saving Database Homes January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success +-- Saving OraDB19000_home4 January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success +-- Saving OraDB19000_home5 January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:12 AM CET Success Saving Databases January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:42 AM CET Success +-- Saving REPOCDB January 15, 2024 11:24:12 AM CET January 15, 2024 11:24:17 AM CET Success +-- Saving OKVCOE January 15, 2024 11:24:17 AM CET January 15, 2024 11:24:22 AM CET Success +-- Saving NOTDEOKV January 15, 2024 11:24:22 AM CET January 15, 2024 11:24:27 AM CET Success +-- Saving TDEOKV January 15, 2024 11:24:27 AM CET January 15, 2024 11:24:32 AM CET Success +-- Saving ONTDEOKV January 15, 2024 11:24:32 AM CET January 15, 2024 11:24:37 AM CET Success +-- Saving MYTDE January 15, 2024 11:24:37 AM CET January 15, 2024 11:24:42 AM CET Success Saving Object swift stores January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Saving Database Backups January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Saving NFS Backups January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Saving Certificates and wallets Backup January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Saving KVM black-box resources January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Saving DB System Resources January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Creating databases version list January 15, 2024 11:24:42 AM CET January 15, 2024 11:24:42 AM CET Success Deconfiguring Appliance January 15, 2024 11:24:42 AM CET January 15, 2024 11:37:41 AM CET Success Deconfiguring Databases January 15, 2024 11:24:42 AM CET January 15, 2024 11:31:40 AM CET Success +-- Deconfiguring REPOCDB January 15, 2024 11:24:42 AM CET January 15, 2024 11:26:04 AM CET Success +-- Deconfiguring OKVCOE January 15, 2024 11:26:04 AM CET January 15, 2024 11:27:12 AM CET Success +-- Deconfiguring NOTDEOKV January 15, 2024 11:27:12 AM CET January 15, 2024 11:28:19 AM CET Success +-- Deconfiguring TDEOKV January 15, 2024 11:28:19 AM CET January 15, 2024 11:29:27 AM CET Success +-- Deconfiguring ONTDEOKV January 15, 2024 11:29:27 AM CET January 15, 2024 11:30:34 AM CET Success +-- Deconfiguring MYTDE January 15, 2024 11:30:34 AM CET January 15, 2024 11:31:40 AM CET Success Saving database backup reports January 15, 2024 11:31:40 AM CET January 15, 2024 11:31:40 AM CET Success Resizing Quorum Disks January 15, 2024 11:31:40 AM CET January 15, 2024 11:31:40 AM CET Success Deconfiguring Grid Infrastructure January 15, 2024 11:31:40 AM CET January 15, 2024 11:37:41 AM CET Success Backup Quorum Disks January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:41 AM CET Success Creating the server archive files January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:41 AM CET Success Zipping the server archive files January 15, 2024 11:37:41 AM CET January 15, 2024 11:37:42 AM CET Success [root@moros patch_1921]#
- 1.9 Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance
[root@phanes out_oda_moros_patch]# ls files serverarchive_moros.zip serverarchive_moros.zip.sha256 [root@phanes out_oda_moros_patch]#
Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning
- 2.1 Reimage
Do the reimage according the documentation https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.21/daten/reimaging-oda.html#GUID-5D72EF11-BA2F-4EC7-B0C9-E5FCE6BFC901
- 2.2 Configure network
If you have noted your configuration network you will have to provided them. Otherwise in the archive file generated in Step 1.8, the configure-firstnet.rsp file will have all required information. Note that you should not change the network settings.
localhost login: root Password: Last login: Mon Jan 15 23:51:40 on tty1 [root@oak ~]# configure-firstnet Select the Interface to configure the network on (btbond1 btbond3) [btbond1]: Use LACP bonding on btbond1 (yes/no) [no]: Configure DHCP on btbond1 (yes/no) [no]: INFO: You have chosen Static configuration Use VLAN on btbond1 (yes/no) [no]: Enter the IP address to configure : 180.213.32.20 Enter the Netmask address to configure : 255.255.255.0 Enter the Gateway address to configure [180.213.32.1] : 180.213.32.200 INFO: Restarting the network WARNING: Cannot ping the default gateway, please check the network information manually [root@oak ~]#
- We can check the status of the components
[root@oak ~]# odacli describe-component System Version --------------- 19.21.0.0.0 System node Name --------------- oak Local System Version --------------- 19.21.0.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- OAK 19.21.0.0.0 up-to-date DCSCONTROLLER 19.21.0.0.0 up-to-date DCSCLI 19.21.0.0.0 up-to-date DCSAGENT 19.21.0.0.0 up-to-date DCSADMIN 19.21.0.0.0 up-to-date OS 8.8 up-to-date ILOM 5.1.1.23.r151750 5.1.3.20.r153596 BIOS 52100600 52110200 LOCAL CONTROLLER FIRMWARE 214.2.271.9 up-to-date SHARED CONTROLLER FIRMWARE VDV1RL06 up-to-date LOCAL DISK FIRMWARE D3MU001 up-to-date HMP 2.4.9.1.601 up-to-date [root@oak ~]#
Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method
- 3.1 Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch
[root@oak Download]# 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@oak Download]#
- Validate the job
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip { "jobId" : "d74fc503-3007-4774-bc63-3f938179d2a8", "status" : "Created", "message" : "/u01/Download/oda-sm-19.21.0.0.0-231220-server.zip", "reports" : [ ], "createTimestamp" : "January 16, 2024 16:53:35 PM UTC", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "January 16, 2024 16:53:35 PM UTC", "jobType" : null } [root@oak Download]#
- Validate the job
[root@oak Download]# odacli describe-job -i "d74fc503-3007-4774-bc63-3f938179d2a8" Job details ---------------------------------------------------------------- ID: d74fc503-3007-4774-bc63-3f938179d2a8 Description: Repository Update Status: Success Created: January 16, 2024 4:53:35 PM UTC Message: /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Unzip bundle January 16, 2024 4:53:35 PM UTC January 16, 2024 4:54:00 PM UTC Success [root@oak Download]#
- 3.2 Apply the Server Patch
- Run Prepatch Report
[root@oak Download]# odacli create-prepatchreport -s -v 19.21.0.0.0 Job details ---------------------------------------------------------------- ID: b3745161-b18f-48bd-8b79-1f2d8d46770e Description: Patch pre-checks for [OS, ILOM, SERVER] Status: Created Created: January 16, 2024 5:03:22 PM UTC Message: Use 'odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e' to check details of results Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- [root@oak Download]#
- Validate the job
[root@oak Download]# odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e Patch pre-check report ------------------------------------------------------------------------ Job ID: b3745161-b18f-48bd-8b79-1f2d8d46770e Description: Patch pre-checks for [OS, ILOM, SERVER] Status: SUCCESS Created: January 16, 2024 5:03:22 PM UTC Result: All pre-checks succeeded Node Name --------------- oak Pre-Check Status Comments ------------------------------ -------- -------------------------------------- __OS__ Validate supported versions Success Validated minimum supported versions. Validate patching tag Success Validated patching tag: 19.21.0.0.0. Is patch location available Success Patch location is available. Verify OS patch Success There are no packages available for an update Validate command execution Success Skipped command execution verfication - Instance is not provisioned __ILOM__ Validate ILOM server reachable Success Successfully connected with ILOM server using public IP and USB interconnect Validate supported versions Success Validated minimum supported versions. Validate patching tag Success Validated patching tag: 19.21.0.0.0. Is patch location available Success Patch location is available. Checking Ilom patch Version Success Successfully verified the versions Patch location validation Success Successfully validated location Validate command execution Success Skipped command execution verfication - Instance is not provisioned __SERVER__ Validate local patching Success Successfully validated server local patching Validate command execution Success Skipped command execution verfication - Instance is not provisioned [root@oak Download]#
- 3.1.2 Apply the server patch
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-server -v 19.21.0.0.0 { "jobId" : "808035e1-39b0-472a-b668-74beeada3cfa", "status" : "Created", "message" : "Success of server update will trigger reboot of the node after 4-5 minutes. Please wait until the node reboots.", "reports" : [ ], "createTimestamp" : "January 16, 2024 17:05:38 PM UTC", "resourceList" : [ ], "description" : "Server Patching", "updatedTime" : "January 16, 2024 17:05:38 PM UTC", "jobType" : null } [root@oak Download]#
- Validate the job
[root@oak ~]# odacli describe-job -i "808035e1-39b0-472a-b668-74beeada3cfa" Job details ---------------------------------------------------------------- ID: 808035e1-39b0-472a-b668-74beeada3cfa Description: Server Patching Status: Success Created: January 16, 2024 5:05:38 PM UTC Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Validate ILOM server reachable January 16, 2024 5:05:39 PM UTC January 16, 2024 5:05:39 PM UTC Success Stop DCS Admin January 16, 2024 5:05:41 PM UTC January 16, 2024 5:05:41 PM UTC Success Generate mTLS certificates January 16, 2024 5:05:41 PM UTC January 16, 2024 5:05:43 PM UTC Success Exporting Public Keys January 16, 2024 5:05:43 PM UTC January 16, 2024 5:05:44 PM UTC Success Creating Trust Store January 16, 2024 5:05:44 PM UTC January 16, 2024 5:05:47 PM UTC Success Update config files January 16, 2024 5:05:47 PM UTC January 16, 2024 5:05:47 PM UTC Success Restart DCS Admin January 16, 2024 5:05:47 PM UTC January 16, 2024 5:06:08 PM UTC Success Modify BM udev rules January 16, 2024 5:06:08 PM UTC January 16, 2024 5:06:28 PM UTC Success Creating repositories using yum January 16, 2024 5:06:28 PM UTC January 16, 2024 5:06:32 PM UTC Success Updating YumPluginVersionLock rpm January 16, 2024 5:06:32 PM UTC January 16, 2024 5:06:32 PM UTC Success Applying OS Patches January 16, 2024 5:06:32 PM UTC January 16, 2024 5:06:36 PM UTC Success Creating repositories using yum January 16, 2024 5:06:36 PM UTC January 16, 2024 5:06:37 PM UTC Success Applying HMP Patches January 16, 2024 5:06:37 PM UTC January 16, 2024 5:06:39 PM UTC Success Patch location validation January 16, 2024 5:06:39 PM UTC January 16, 2024 5:06:39 PM UTC Success Oda-hw-mgmt upgrade January 16, 2024 5:06:39 PM UTC January 16, 2024 5:06:40 PM UTC Success Applying Firmware Disk Patches January 16, 2024 5:06:40 PM UTC January 16, 2024 5:06:42 PM UTC Success Applying Firmware Controller Patches January 16, 2024 5:06:42 PM UTC January 16, 2024 5:06:48 PM UTC Success Checking Ilom patch Version January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:48 PM UTC Success Patch location validation January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:48 PM UTC Success Save password in Wallet January 16, 2024 5:06:48 PM UTC January 16, 2024 5:06:49 PM UTC Success Disabling IPMI v2 January 16, 2024 5:06:49 PM UTC January 16, 2024 5:06:49 PM UTC Success Apply Ilom patch January 16, 2024 5:06:49 PM UTC January 16, 2024 5:16:40 PM UTC Success Copying Flash Bios to Temp location January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success Update System version January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success Cleanup JRE Home January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:40 PM UTC Success Generating and saving BOM January 16, 2024 5:16:40 PM UTC January 16, 2024 5:16:44 PM UTC Success PreRebootNode Actions January 16, 2024 5:16:44 PM UTC January 16, 2024 5:16:44 PM UTC Success Reboot Ilom January 16, 2024 5:16:44 PM UTC January 16, 2024 5:16:44 PM UTC Success [root@oak ~]#
- Now the component status
[root@oak ~]# odacli describe-component System Version --------------- 19.21.0.0.0 System node Name --------------- oak Local System Version --------------- 19.21.0.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- OAK 19.21.0.0.0 up-to-date DCSCONTROLLER 19.21.0.0.0 up-to-date DCSCLI 19.21.0.0.0 up-to-date DCSAGENT 19.21.0.0.0 up-to-date DCSADMIN 19.21.0.0.0 up-to-date OS 8.8 up-to-date ILOM 5.1.3.20.r153596 up-to-date BIOS 52110200 up-to-date LOCAL CONTROLLER FIRMWARE 214.2.271.9 up-to-date SHARED CONTROLLER FIRMWARE VDV1RL06 up-to-date LOCAL DISK FIRMWARE D3MU001 up-to-date HMP 2.4.9.1.601 up-to-date [root@oak ~]#
- 3.3 Update the storage components
- Run prepatch storage report
[root@oak ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.21.0.0.0 Job details ---------------------------------------------------------------- ID: 2559a143-3c82-4dba-aee7-7be054767c87 Description: Patch pre-checks for [STORAGE] Status: Created Created: January 16, 2024 5:27:34 PM UTC Message: Use 'odacli describe-prepatchreport -i 2559a143-3c82-4dba-aee7-7be054767c87' to check details of results Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- [root@oak ~]# [root@oak ~]# odacli describe-prepatchreport -i 2559a143-3c82-4dba-aee7-7be054767c87 Patch pre-check report ------------------------------------------------------------------------ Job ID: 2559a143-3c82-4dba-aee7-7be054767c87 Description: Patch pre-checks for [STORAGE] Status: SUCCESS Created: January 16, 2024 5:27:34 PM UTC Result: All pre-checks succeeded Node Name --------------- oak Pre-Check Status Comments ------------------------------ -------- -------------------------------------- __STORAGE__ Validate patching tag Success Validated patching tag: 19.21.0.0.0. Patch location validation Success Verified patch location Patch tag validation Success Verified patch tag Storage patch tag validation Success Verified storage patch location Verify ASM disks status Success Skipped ASM disks status verification - Instance is not provisioned Validate command execution Success Skipped command execution verfication - Instance is not provisioned [root@oak ~]#
- Patch the storage
[root@oak ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.21.0.0.0 { "jobId" : "3b3ec526-da19-4a86-bf59-80e029fe7bd6", "status" : "Created", "message" : "Success of Storage Update may trigger reboot of node after 4-5 minutes. Please wait till node restart", "reports" : [ ], "createTimestamp" : "January 16, 2024 17:28:58 PM UTC", "resourceList" : [ ], "description" : "Storage Firmware Patching", "updatedTime" : "January 16, 2024 17:28:58 PM UTC", "jobType" : null } [root@oak ~]# [root@oak ~]# odacli describe-job -i "3b3ec526-da19-4a86-bf59-80e029fe7bd6" Job details ---------------------------------------------------------------- ID: 3b3ec526-da19-4a86-bf59-80e029fe7bd6 Description: Storage Firmware Patching Status: Success Created: January 16, 2024 5:28:58 PM UTC Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Applying Firmware Disk Patches January 16, 2024 5:29:01 PM UTC January 16, 2024 5:29:04 PM UTC Success Generating and saving BOM January 16, 2024 5:29:04 PM UTC January 16, 2024 5:29:08 PM UTC Success PreRebootNode Actions January 16, 2024 5:29:08 PM UTC January 16, 2024 5:29:08 PM UTC Success Reboot Ilom January 16, 2024 5:29:08 PM UTC January 16, 2024 5:29:08 PM UTC Success [root@oak ~]#
- 3.4 Update the repository with the 19.21 Oracle Grid Infrastructure : p30403673_1921000_Linux-x86-64.zip
[root@oak Download]# unzip p30403673_1921000_Linux-x86-64.zip Archive: p30403673_1921000_Linux-x86-64.zip extracting: odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip inflating: README.txt [root@oak Download]# [root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip { "jobId" : "a706c404-a833-4ef4-858f-fc7e82af7f2b", "status" : "Created", "message" : "/u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip", "reports" : [ ], "createTimestamp" : "January 16, 2024 17:42:28 PM UTC", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "January 16, 2024 17:42:28 PM UTC", "jobType" : null } [root@oak Download]# [root@oak Download]# odacli describe-job -i "a706c404-a833-4ef4-858f-fc7e82af7f2b" Job details ---------------------------------------------------------------- ID: a706c404-a833-4ef4-858f-fc7e82af7f2b Description: Repository Update Status: Success Created: January 16, 2024 5:42:28 PM UTC Message: /u01/Download/odacli-dcs-19.21.0.0.0-231211-GI-19.21.0.0.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Unzip bundle January 16, 2024 5:42:28 PM UTC January 16, 2024 5:42:59 PM UTC Success [root@oak Download]#
- 3.5 Update the repository with the server data archive files generated in Step 1
[root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/serverarchive_moros.zip { "jobId" : "5ed8951a-d178-45ef-8627-61bf72235564", "status" : "Created", "message" : "/u01/Download/serverarchive_moros.zip", "reports" : [ ], "createTimestamp" : "January 16, 2024 17:47:30 PM UTC", "resourceList" : [ ], "description" : "Repository Update", "updatedTime" : "January 16, 2024 17:47:30 PM UTC", "jobType" : null } [root@oak Download]# [root@oak Download]# odacli describe-job -i "5ed8951a-d178-45ef-8627-61bf72235564" Job details ---------------------------------------------------------------- ID: 5ed8951a-d178-45ef-8627-61bf72235564 Description: Repository Update Status: Success Created: January 16, 2024 5:47:30 PM UTC Message: /u01/Download/serverarchive_moros.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Unzip bundle January 16, 2024 5:47:30 PM UTC January 16, 2024 5:47:30 PM UTC Success [root@oak Download]#
- 3.6 Restore Oracle Grid Infrastructure
[root@oak Download]# odacli restore-node -g Enter New system password: Retype New system password: Enter an initial password for Web Console account (oda-admin): Retype the password for Web Console account (oda-admin): User 'oda-admin' created successfully... { "jobId" : "1a8d5eb8-433c-4bec-aa9b-c6fab96373c5", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "January 16, 2024 17:53:47 PM UTC", "resourceList" : [ ], "description" : "Restore node service - GI", "updatedTime" : "January 16, 2024 17:53:47 PM UTC", "jobType" : null } [root@oak Download]# [root@moros ~]# odacli describe-job -i "1a8d5eb8-433c-4bec-aa9b-c6fab96373c5" Job details ---------------------------------------------------------------- ID: 1a8d5eb8-433c-4bec-aa9b-c6fab96373c5 Description: Restore node service - GI Status: Success Created: January 16, 2024 4:53:47 PM CET Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Restore node service creation January 16, 2024 4:53:55 PM CET January 16, 2024 5:19:28 PM CET Success Setting up Network January 16, 2024 4:53:58 PM CET January 16, 2024 4:53:58 PM CET Success Setting up Vlan January 16, 2024 4:54:31 PM CET January 16, 2024 4:54:33 PM CET Success Setting up Network January 16, 2024 4:55:07 PM CET January 16, 2024 4:55:07 PM CET Success Network update January 16, 2024 4:55:43 PM CET January 16, 2024 4:56:14 PM CET Success Updating network January 16, 2024 4:55:43 PM CET January 16, 2024 4:56:14 PM CET Success Setting up Network January 16, 2024 4:55:43 PM CET January 16, 2024 4:55:43 PM CET Success OS usergroup 'asmdba' creation January 16, 2024 4:56:14 PM CET January 16, 2024 4:56:15 PM CET Success OS usergroup 'asmoper' creation January 16, 2024 4:56:15 PM CET January 16, 2024 4:56:15 PM CET Success OS usergroup 'asmadmin' creation January 16, 2024 4:56:15 PM CET January 16, 2024 4:56:16 PM CET Success OS usergroup 'dba' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success OS usergroup 'dbaoper' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success OS usergroup 'oinstall' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:16 PM CET Success OS user 'oracle' creation January 16, 2024 4:56:16 PM CET January 16, 2024 4:56:17 PM CET Success Default backup policy creation January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success Backup Config name validation January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success Backup config metadata persist January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:17 PM CET Success Grant permission to RHP files January 16, 2024 4:56:17 PM CET January 16, 2024 4:56:18 PM CET Success Add SYSNAME in Env January 16, 2024 4:56:18 PM CET January 16, 2024 4:56:18 PM CET Success Install oracle-ahf January 16, 2024 4:56:18 PM CET January 16, 2024 4:59:13 PM CET Success Stop DCS Admin January 16, 2024 4:59:55 PM CET January 16, 2024 4:59:55 PM CET Success Generate mTLS certificates January 16, 2024 4:59:55 PM CET January 16, 2024 4:59:57 PM CET Success Exporting Public Keys January 16, 2024 4:59:57 PM CET January 16, 2024 4:59:58 PM CET Success Creating Trust Store January 16, 2024 4:59:58 PM CET January 16, 2024 5:00:02 PM CET Success Update config files January 16, 2024 5:00:02 PM CET January 16, 2024 5:00:02 PM CET Success Restart DCS Admin January 16, 2024 5:00:02 PM CET January 16, 2024 5:00:23 PM CET Success Unzipping storage configuration files January 16, 2024 5:00:23 PM CET January 16, 2024 5:00:23 PM CET Success Reloading multipath devices January 16, 2024 5:00:23 PM CET January 16, 2024 5:00:24 PM CET Success Restart oakd January 16, 2024 5:00:24 PM CET January 16, 2024 5:00:35 PM CET Success Restart oakd January 16, 2024 5:01:46 PM CET January 16, 2024 5:01:56 PM CET Success Restore Quorum Disks January 16, 2024 5:01:56 PM CET January 16, 2024 5:01:56 PM CET Success Creating GI home directories January 16, 2024 5:01:56 PM CET January 16, 2024 5:01:56 PM CET Success Extract GI clone January 16, 2024 5:01:56 PM CET January 16, 2024 5:03:00 PM CET Success Creating wallet for Root User January 16, 2024 5:03:02 PM CET January 16, 2024 5:03:06 PM CET Success Creating wallet for ASM Client January 16, 2024 5:03:06 PM CET January 16, 2024 5:03:11 PM CET Success Grid stack creation January 16, 2024 5:03:12 PM CET January 16, 2024 5:15:29 PM CET Success GI Restore with RHP January 16, 2024 5:03:12 PM CET January 16, 2024 5:12:03 PM CET Success Updating GIHome version January 16, 2024 5:12:04 PM CET January 16, 2024 5:12:08 PM CET Success Post cluster OAKD configuration January 16, 2024 5:15:29 PM CET January 16, 2024 5:16:26 PM CET Success Mounting disk group DATA January 16, 2024 5:16:26 PM CET January 16, 2024 5:16:27 PM CET Success Mounting disk group RECO January 16, 2024 5:16:35 PM CET January 16, 2024 5:16:43 PM CET Success Setting ACL for disk groups January 16, 2024 5:16:50 PM CET January 16, 2024 5:16:53 PM CET Success Register Scan and Vips to Public Network January 16, 2024 5:16:53 PM CET January 16, 2024 5:16:55 PM CET Success Adding Volume ORAHOME_SH to Clusterware January 16, 2024 5:17:24 PM CET January 16, 2024 5:17:27 PM CET Success Adding Volume COMMONSTORE to Clusterware January 16, 2024 5:17:27 PM CET January 16, 2024 5:17:30 PM CET Success Adding Volume ACFSCLONE to Clusterware January 16, 2024 5:17:30 PM CET January 16, 2024 5:17:33 PM CET Success Adding Volume ODABASE_N0 to Clusterware January 16, 2024 5:17:33 PM CET January 16, 2024 5:17:36 PM CET Success Enabling Volume(s) January 16, 2024 5:17:36 PM CET January 16, 2024 5:18:28 PM CET Success Discover ACFS clones config January 16, 2024 5:19:11 PM CET January 16, 2024 5:19:21 PM CET Success Configure export clones resource January 16, 2024 5:19:20 PM CET January 16, 2024 5:19:21 PM CET Success Discover DbHomes ACFS config January 16, 2024 5:19:21 PM CET January 16, 2024 5:19:25 PM CET Success Discover OraHomeStorage volumes January 16, 2024 5:19:21 PM CET January 16, 2024 5:19:25 PM CET Success Provisioning service creation January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success Persist new agent state entry January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success Persist new agent state entry January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:27 PM CET Success Restart DCS Agent January 16, 2024 5:19:27 PM CET January 16, 2024 5:19:28 PM CET Success [root@moros ~]#
- 3.7 Restore the database
[root@moros ~]# odacli restore-node -d { "jobId" : "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "January 16, 2024 19:24:08 PM CET", "resourceList" : [ ], "description" : "Restore node service - DB", "updatedTime" : "January 16, 2024 19:24:08 PM CET", "jobType" : null } [root@moros ~]#
- The first time we got some errors due to wallet not saved before the reimage
[root@moros ~]# odacli describe-job -i "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98" Job details ---------------------------------------------------------------- ID: 3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98 Description: Restore node service - DB Status: Failure (To view Error Correlation report, run "odacli describe-job -i 3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98 --ecr" command) Created: January 16, 2024 7:24:08 PM CET Message: DCS-10001:Internal error encountered: Failed to get pfile from spfile - ERROR: ORA-12578: TNS:wallet open failed SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus. Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Restore node service creation January 16, 2024 7:24:11 PM CET January 16, 2024 7:25:09 PM CET Failure Restore node service creation January 16, 2024 7:24:11 PM CET January 16, 2024 7:25:09 PM CET Failure Setting up SSH equivalence for 'oracle' January 16, 2024 7:24:11 PM CET January 16, 2024 7:24:12 PM CET Success Restore BM CPU Pools January 16, 2024 7:24:12 PM CET January 16, 2024 7:24:12 PM CET Success Register DB home: OraDB19000_home5 January 16, 2024 7:24:12 PM CET January 16, 2024 7:24:38 PM CET Success Register DB home: OraDB19000_home4 January 16, 2024 7:24:38 PM CET January 16, 2024 7:25:06 PM CET Success Persist database storage locations January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for OKVCOE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for ONTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for NOTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for MYTDE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for REPOCDB January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Persist database storages January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for OKVCOE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for ONTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for NOTDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for MYTDE January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Save metadata for REPOCDB January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:07 PM CET Success Restore node service creation January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Failure Restore database: TDEOKV January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Failure +-- Adding database to GI January 16, 2024 7:25:07 PM CET January 16, 2024 7:25:09 PM CET Success +-- Adding database instance(s) to GI January 16, 2024 7:25:09 PM CET January 16, 2024 7:25:09 PM CET Success +-- Modifying SPFILE for database January 16, 2024 7:25:09 PM CET January 16, 2024 7:25:09 PM CET Failure
- I then decide to restore only database without wallet
[root@moros restore]# odacli restore-node -d { "jobId" : "92406b7e-9803-4cb6-a0b6-b1ba749acd00", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "January 16, 2024 23:21:14 PM CET", "resourceList" : [ ], "description" : "Restore node service - DB", "updatedTime" : "January 16, 2024 23:21:14 PM CET", "jobType" : null }
- And the job went fine
[root@moros restore]# odacli describe-job -i "92406b7e-9803-4cb6-a0b6-b1ba749acd00" Job details ---------------------------------------------------------------- ID: 92406b7e-9803-4cb6-a0b6-b1ba749acd00 Description: Restore node service - DB Status: Success Created: January 16, 2024 11:21:14 PM CET Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Setting up SSH equivalence for 'oracle' January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success Restore BM CPU Pools January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success DB home creation: OraDB19000_home5 January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Skipped DB home creation: OraDB19000_home4 January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Skipped Persist database storage locations January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success Save metadata for REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success Persist database storages January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success Save metadata for REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:15 PM CET Success Restore database: REPOCDB January 16, 2024 11:21:15 PM CET January 16, 2024 11:23:18 PM CET Success +-- Adding database to GI January 16, 2024 11:21:15 PM CET January 16, 2024 11:21:17 PM CET Success +-- Adding database instance(s) to GI January 16, 2024 11:21:17 PM CET January 16, 2024 11:21:17 PM CET Success +-- Modifying SPFILE for database January 16, 2024 11:21:17 PM CET January 16, 2024 11:22:12 PM CET Success +-- Restore password file for database January 16, 2024 11:22:12 PM CET January 16, 2024 11:22:12 PM CET Skipped +-- Start instance(s) for database January 16, 2024 11:22:12 PM CET January 16, 2024 11:22:51 PM CET Success +-- Persist metadata for database January 16, 2024 11:22:51 PM CET January 16, 2024 11:22:51 PM CET Success +-- Create adrci directory January 16, 2024 11:22:51 PM CET January 16, 2024 11:22:51 PM CET Success +-- Run SqlPatch January 16, 2024 11:22:51 PM CET January 16, 2024 11:23:18 PM CET Success Restore Object Stores January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success Remount NFS backups January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success Restore BackupConfigs January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success Reattach backupconfigs to DBs January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success Restore backup reports January 16, 2024 11:23:18 PM CET January 16, 2024 11:23:18 PM CET Success [root@moros restore]# [root@moros app]# odacli describe-component System Version --------------- 19.21.0.0.0 System node Name --------------- moros Local System Version --------------- 19.21.0.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- OAK 19.21.0.0.0 up-to-date GI 19.21.0.0.231017 up-to-date DB { [OraDB19000_home5] 19.20.0.0.230718 19.21.0.0.231017 [OraDB19000_home4 [REPOCDB]] 19.20.0.0.230718 19.21.0.0.231017 } DCSCONTROLLER 19.21.0.0.0 up-to-date DCSCLI 19.21.0.0.0 up-to-date DCSAGENT 19.21.0.0.0 up-to-date DCSADMIN 19.21.0.0.0 up-to-date OS 8.8 up-to-date ILOM 5.1.3.20.r153596 up-to-date BIOS 52110200 up-to-date LOCAL CONTROLLER FIRMWARE 214.2.271.9 up-to-date SHARED CONTROLLER FIRMWARE VDV1RL06 up-to-date LOCAL DISK FIRMWARE D3MU001 up-to-date HMP 2.4.9.1.601 up-to-date [root@moros app]#
Step 4 : Update Existing dbhomes
- 4.1 Update Repository
[root@moros ~]# odacli update-repository -f /u01/Download/odacli-dcs-19.21.0.0.0-231211-DB-19.21.0.0.zip [root@moros ~]# odacli describe-job -i 5362ce43-6ccb-4ea9-b05d-df5a3e791a71 Job details ---------------------------------------------------------------- ID: 5362ce43-6ccb-4ea9-b05d-df5a3e791a71 Description: Repository Update Status: Success Created: January 17, 2024 1:09:10 AM CET Message: /u01/Download/odacli-dcs-19.21.0.0.0-231211-DB-19.21.0.0.zip Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Unzip bundle January 17, 2024 1:09:11 AM CET January 17, 2024 1:09:43 AM CET Success [root@moros ~]#
- 4.2 List databases
[root@moros ~]# odacli list-dbhomes ID Name DB Version DB Edition Home Location Status ---------------------------------------- -------------------- ------------------------------ ---------- ------------------------------------------------------- ---------- b81b51d5-f407-4ca1-80d6-46f426d12d1f OraDB19000_home5 19.20.0.0.230718 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5 CONFIGURED 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe OraDB19000_home4 19.20.0.0.230718 EE /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_4 CONFIGURED [root@moros ~]# 4.3 Run Prepatch report [root@moros ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport --dbhome --dbhomeid 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0 Job details ---------------------------------------------------------------- ID: a397dc6a-9bac-432a-a676-2206133c8122 Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home4 Status: Created Created: January 30, 2024 11:06:44 AM CET Message: Use 'odacli describe-prepatchreport -i a397dc6a-9bac-432a-a676-2206133c8122' to check details of results Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- [root@moros ~]# [root@moros ~]# odacli describe-prepatchreport -i a397dc6a-9bac-432a-a676-2206133c8122 Patch pre-check report ------------------------------------------------------------------------ Job ID: a397dc6a-9bac-432a-a676-2206133c8122 Description: Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home4 Status: SUCCESS Created: January 30, 2024 11:06:44 AM CET Result: All pre-checks succeeded Node Name --------------- moros Pre-Check Status Comments ------------------------------ -------- -------------------------------------- __DB__ Validate DB Home ID Success Validated DB Home ID: 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe Validate patching tag Success Validated patching tag: 19.21.0.0.0. Is system provisioned Success Verified system is provisioned Validate minimum agent version Success Validated minimum agent version Is GI upgraded Success Validated GI is upgraded Validate available space for Success Validated free space required under db /u01 Validate dbHomesOnACFS Success User has configured disk group for configured Database homes on ACFS Validate Oracle base Success Successfully validated Oracle Base Is DB clone available Success Successfully validated clone file exists Evaluate DBHome patching with Success Successfully validated updating RHP dbhome with RHP. and local patching is possible Validate command execution Success Validated command execution __ORACHK__ Running orachk Success Successfully ran Orachk Validate command execution Success Validated command execution
- 4.4 Patch the dbhomes
[root@moros ~]# /opt/oracle/dcs/bin/odacli update-dbhome --id 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0 { "jobId" : "b38e8ed2-f1d6-4c82-be52-554e9cb6e116", "status" : "Created", "message" : null, "reports" : [ ], "createTimestamp" : "January 30, 2024 11:21:24 AM CET", "resourceList" : [ ], "description" : "DB Home Patching: Home ID is 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe", "updatedTime" : "January 30, 2024 11:21:24 AM CET", "jobType" : null } [root@moros ~]# [root@moros ~]# odacli describe-job -i "b38e8ed2-f1d6-4c82-be52-554e9cb6e116" Job details ---------------------------------------------------------------- ID: b38e8ed2-f1d6-4c82-be52-554e9cb6e116 Description: DB Home Patching: Home ID is 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe Status: Success Created: January 30, 2024 11:21:24 AM CET Message: Task Name Start Time End Time Status ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------- Creating wallet for DB Client January 30, 2024 11:22:20 AM CET January 30, 2024 11:22:20 AM CET Success Patch databases by RHP - [SITNECDB] January 30, 2024 11:22:20 AM CET January 30, 2024 11:25:03 AM CET Success Updating database metadata January 30, 2024 11:25:03 AM CET January 30, 2024 11:25:03 AM CET Success Set log_archive_dest for Database January 30, 2024 11:25:03 AM CET January 30, 2024 11:25:07 AM CET Success Patch databases by RHP - [REPOCDB] January 30, 2024 11:25:07 AM CET January 30, 2024 11:30:54 AM CET Success Updating database metadata January 30, 2024 11:30:54 AM CET January 30, 2024 11:30:54 AM CET Success Set log_archive_dest for Database January 30, 2024 11:30:54 AM CET January 30, 2024 11:30:57 AM CET Success Set target_pdbs parameter January 30, 2024 11:30:57 AM CET January 30, 2024 11:32:22 AM CET Success Patch databases by RHP - [C1COE02] January 30, 2024 11:32:22 AM CET January 30, 2024 11:34:15 AM CET Success Updating database metadata January 30, 2024 11:34:15 AM CET January 30, 2024 11:34:15 AM CET Success Set log_archive_dest for Database January 30, 2024 11:34:15 AM CET January 30, 2024 11:34:19 AM CET Success Patch databases by RHP - [C1COE01] January 30, 2024 11:34:19 AM CET January 30, 2024 11:36:15 AM CET Success Updating database metadata January 30, 2024 11:36:15 AM CET January 30, 2024 11:36:15 AM CET Success Set log_archive_dest for Database January 30, 2024 11:36:15 AM CET January 30, 2024 11:36:19 AM CET Success Update System version January 30, 2024 11:36:19 AM CET January 30, 2024 11:36:19 AM CET Success Generating and saving BOM January 30, 2024 11:36:19 AM CET January 30, 2024 11:37:22 AM CET Success TDE parameter update January 30, 2024 11:38:37 AM CET January 30, 2024 11:38:37 AM CET Success