{"id":18837,"date":"2022-09-07T16:52:06","date_gmt":"2022-09-07T14:52:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=18837"},"modified":"2023-06-20T10:17:37","modified_gmt":"2023-06-20T08:17:37","slug":"patch-oda-x8-19-9-to-19-11","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/","title":{"rendered":"Patch ODA X8 : 19.9 to 19.11"},"content":{"rendered":"\n

By Mouhamadou Diaw<\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches<\/p>\n\n\n\n

p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI\/DCS Stack
p30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI\/DCS stack
p30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI\/DCS stack<\/p>\n\n\n\n

Patching the Oracle Database Appliance Server<\/h2>\n\n\n\n

Before starting the process we first take a backup of the system with odabr ( ODA (Oracle Database Appliance): ODABR a System Backup\/Restore Utility (Doc ID 2466177.1)<\/em>)<\/p>\n\n\n\n

After dowloading the latest version, we do install odabr<\/p>\n\n\n\n

[root@oda-prod software]# rpm -ivh odabr-2.0.1-70.noarch.rpm\nwarning: odabr-2.0.1-70.noarch.rpm: Header V4 RSA\/SHA1 Signature, key ID 939112d6: NOKEY\nPreparing...                          ################################# [100%]\nUpdating \/ installing...\n   1:odabr-2.0.1-70                   ################################# [100%]\n\nodabr-2.0.1.70 has been installed on \/opt\/odabr succesfully!\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We can verify that there is actually no snapshots <\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/odabr\/odabr infosnap\n\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n odabr - ODA node Backup Restore - Version: 2.0.1-70\n Copyright 2013, 2021, Oracle and\/or its affiliates.\n --------------------------------------------------------\n Author: Ruggero Citton <ruggero.citton@oracle.com>\n RAC Pack, Cloud Innovation and Solution Engineering Team\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n\n\nLVM snap name         Status                COW Size              Data%\n-------------         ----------            ----------            ------\nWARNING: 2022-08-30 09:07:58: LVM snapshot for 'root' does not exist\nWARNING: 2022-08-30 09:07:58: LVM snapshot for 'opt' does not exist\nWARNING: 2022-08-30 09:07:58: LVM snapshot for 'u01' does not exist\n<\/code><\/pre>\n\n\n\n
Let’s do a backup with odabr<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/odabr\/odabr backup -snap -rsize 15 -usize 90 -osize 60\nINFO: 2022-08-30 09:08:51: Please check the logfile '\/opt\/odabr\/out\/log\/odabr_35684.log' for more details\n\n\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n odabr - ODA node Backup Restore - Version: 2.0.1-70\n Copyright 2013, 2021, Oracle and\/or its affiliates.\n --------------------------------------------------------\n Author: Ruggero Citton <ruggero.citton@oracle.com>\n RAC Pack, Cloud Innovation and Solution Engineering Team\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n\nINFO: 2022-08-30 09:08:51: Checking superuser\nINFO: 2022-08-30 09:08:51: Checking Bare Metal\n\nINFO: 2022-08-30 09:08:51: Removing existing LVM snapshots\nWARNING: 2022-08-30 09:08:51: LVM snapshot for 'opt' does not exist\nWARNING: 2022-08-30 09:08:51: LVM snapshot for 'u01' does not exist\nWARNING: 2022-08-30 09:08:51: LVM snapshot for 'root' does not exist\n\nINFO: 2022-08-30 09:08:51: Checking current OS version\nINFO: 2022-08-30 09:08:51: Checking LVM restore backgroud process\nINFO: 2022-08-30 09:08:51: Checking LVM size\n\nINFO: 2022-08-30 09:08:51: Boot device backup\nINFO: 2022-08-30 09:08:51: Getting EFI device\nINFO: 2022-08-30 09:08:51: ...step1 - unmounting EFI\nINFO: 2022-08-30 09:08:51: ...step2 - making efi device backup\nSUCCESS: 2022-08-30 09:08:52: ...EFI device backup saved as '\/opt\/odabr\/out\/hbi\/efi.img'\nINFO: 2022-08-30 09:08:52: ...step3 - checking EFI device backup\nINFO: 2022-08-30 09:08:52: Getting boot device\nINFO: 2022-08-30 09:08:52: ...step1 - making boot device backup using tar\nSUCCESS: 2022-08-30 09:08:57: ...boot content saved as '\/opt\/odabr\/out\/hbi\/boot.tar.gz'\nINFO: 2022-08-30 09:08:57: ...step2 - unmounting boot\nINFO: 2022-08-30 09:08:57: ...step3 - making boot device backup using dd\nSUCCESS: 2022-08-30 09:08:59: ...boot device backup saved as '\/opt\/odabr\/out\/hbi\/boot.img'\nINFO: 2022-08-30 09:08:59: ...step4 - mounting boot\nINFO: 2022-08-30 09:08:59: ...step5 - mounting EFI\nINFO: 2022-08-30 09:08:59: ...step6 - checking boot device backup\n\nINFO: 2022-08-30 09:08:59: Making OCR physical backup\nINFO: 2022-08-30 09:09:02: ...ocr backup saved as '\/opt\/odabr\/out\/hbi\/ocrbackup_35684.bck'\nSUCCESS: 2022-08-30 09:09:02: OCR physical backup created successfully\nINFO: 2022-08-30 09:09:02: OCR export backup\nINFO: 2022-08-30 09:09:03: ...ocr export saved as '\/opt\/odabr\/out\/hbi\/ocrexport_35684.bck'\nSUCCESS: 2022-08-30 09:09:03: OCR export backup created successfully\n\nINFO: 2022-08-30 09:09:03: Making LVM snapshot backup\nSUCCESS: 2022-08-30 09:09:04: ...snapshot backup for 'opt' created successfully\nSUCCESS: 2022-08-30 09:09:05: ...snapshot backup for 'u01' created successfully\nSUCCESS: 2022-08-30 09:09:05: ...snapshot backup for 'root' created successfully\nSUCCESS: 2022-08-30 09:09:05: LVM snapshots backup done successfully\n<\/code><\/pre>\n\n\n\n
We should now have snapshots<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/odabr\/odabr infosnap\n\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n odabr - ODA node Backup Restore - Version: 2.0.1-70\n Copyright 2013, 2021, Oracle and\/or its affiliates.\n --------------------------------------------------------\n Author: Ruggero Citton <ruggero.citton@oracle.com>\n RAC Pack, Cloud Innovation and Solution Engineering Team\n\u2502\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2592\u2502\n\n\nLVM snap name         Status                COW Size              Data%\n-------------         ----------            ----------            ------\nroot_snap             active                15.00 GiB             0.01%\nopt_snap              active                60.00 GiB             0.01%\nu01_snap              active                90.00 GiB             0.01%\n\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Now we can start the patching . First let’s unpack the patch p32790643_1911000_Linux-x86-64.zip<\/p>\n\n\n\n
[root@oda-prod software]# unzip p32790643_1911000_Linux-x86-64.zip\nArchive:  p32790643_1911000_Linux-x86-64.zip\n extracting: oda-sm-19.11.0.0.0-210530-server.zip\n  inflating: README.txt\n[root@x0042db02 local_dumps]#\n<\/code><\/pre>\n\n\n\n
Then update the repository with the patch<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"832fbb4d-2186-4b85-9978-7f642e04f3a9\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  832fbb4d-2186-4b85-9978-7f642e04f3a9\n            Description:  Repository Update\n                 Status:  Success\n                Created:  August 30, 2022 8:56:54 AM CEST\n                Message:  \/software\/oda-sm-19.11.0.0.0-210530-server.zip\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nUnzip bundle                             August 30, 2022 8:56:54 AM CEST     August 30, 2022 8:57:18 AM CEST     Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Validate that the job is successful<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"832fbb4d-2186-4b85-9978-7f642e04f3a9\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  832fbb4d-2186-4b85-9978-7f642e04f3a9\n            Description:  Repository Update\n                 Status:  Success\n                Created:  August 30, 2022 8:56:54 AM CEST\n                Message:  \/software\/oda-sm-19.11.0.0.0-210530-server.zip\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nUnzip bundle                             August 30, 2022 8:56:54 AM CEST     August 30, 2022 8:57:18 AM CEST     Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Then we update the DCS_ADMIN<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-dcsadmin -v 19.11.0.0.0\n{\n  \"jobId\" : \"fb14a1d0-52ce-43c3-871d-c93fdaff75b9\",\n  \"status\" : \"Created\",\n  \"message\" : null,\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 09:11:57 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"DcsAdmin patching\",\n  \"updatedTime\" : \"August 30, 2022 09:11:57 AM CEST\"\n}\n<\/code><\/pre>\n\n\n\n
The job should return SUCCESS<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"fb14a1d0-52ce-43c3-871d-c93fdaff75b9\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  fb14a1d0-52ce-43c3-871d-c93fdaff75b9\n            Description:  DcsAdmin patching\n                 Status:  Success\n                Created:  August 30, 2022 9:11:57 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nPatch location validation                August 30, 2022 9:11:57 AM CEST     August 30, 2022 9:11:57 AM CEST     Success\ndcs-admin upgrade                        August 30, 2022 9:11:57 AM CEST     August 30, 2022 9:12:03 AM CEST     Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Let’s update the DCS components<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-dcscomponents -v 19.11.0.0.                        0\n{\n  \"jobId\" : \"a274b632-92a8-4f8f-b05d-b3c5d7c67dae\",\n  \"status\" : \"Success\",\n  \"message\" : \"Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL installation is successful. Metadata migration is successful. Metadata schema update is done. dcsagent RPM upgrade is successful.  dcscli RPM upgrade is successful.  dcscontroller RPM upgrade is successful.  Successfully ran setupAgentAuth.sh zookeeper RPM upgrade is successful.  DCS-Agent restart is successful. \",\n  \"reports\" : null,\n  \"createTimestamp\" : \"August 30, 2022 09:13:37 AM CEST\",\n  \"description\" : \"Update-dcscomponents job completed and is not part of Agent job list\",\n  \"updatedTime\" : \"August 30, 2022 09:15:41 AM CEST\"\n}\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
The describe-job for this job  doesn’t return anything. It’s normal, don’t worry<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"a274b632-92a8-4f8f-b05d-b3c5d7c67dae\"\nDCS-10000:Resource Job with ID a274b632-92a8-4f8f-b05d-b3c5d7c67dae is not found.\n<\/code><\/pre>\n\n\n\n
We can see the status of our components at this point<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-component\nSystem Version\n---------------\n19.11.0.0.0\n\nSystem node Name\n---------------\noda-prod\n\nLocal System Version\n---------------\n19.11.0.0.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       19.9.0.0.0            19.11.0.0.0\n\nGI                                        19.9.0.0.201020       19.11.0.0.210420\n\nDB {\n[ OraDB19000_home1 ]                      19.9.0.0.201020       19.11.0.0.210420\n[ OraDB11204_home1 ]                      11.2.0.4.201020       not-available\n}\n\nDCSAGENT                                  19.11.0.0.0           up-to-date\n\nOS                                        7.8                   7.9\n\nILOM                                      5.0.1.21.r136383      5.0.1.21.a.r138015\n\nBIOS                                      52030400              up-to-date\n\nFIRMWARECONTROLLER                        VDV1RL04              up-to-date\n\nFIRMWAREDISK                              1102                  up-to-date\n\nASR                                       20.3.0                up-to-date\n\nHMP                                       2.4.7.0.1             2.4.8.0.600\n\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We can now update the DCS agent<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-dcsagent -v 19.11.0.0.0\n{\n  \"jobId\" : \"0ea4fc54-4797-47a0-966d-de1f3d14bda4\",\n  \"status\" : \"Created\",\n  \"message\" : \"Dcs agent will be restarted after the update. Please wait for 2-3 mins before executing the other commands\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 09:21:11 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"DcsAgent patching\",\n  \"updatedTime\" : \"August 30, 2022 09:21:11 AM CEST\"\n}\n[root@oda-prod software]# \n<\/code><\/pre>\n\n\n\n
The job status should return SUCCESS<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"0ea4fc54-4797-47a0-966d-de1f3d14bda4\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  0ea4fc54-4797-47a0-966d-de1f3d14bda4\n            Description:  DcsAgent patching\n                 Status:  Success\n                Created:  August 30, 2022 9:21:11 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\ndcs-agent upgrade  to version 19.11.0.0.0 August 30, 2022 9:21:12 AM CEST     August 30, 2022 9:23:32 AM CEST     Success\nUpdate System version                    August 30, 2022 9:23:32 AM CEST     August 30, 2022 9:23:32 AM CEST     Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Now it\u2019s time to update the repository with grid patch<\/p>\n\n\n\n
We unpack the corresponding patch<\/p>\n\n\n\n
[root@oda-prod software]# unzip p30403673_1911000_Linux-x86-64.zip\nArchive:  p30403673_1911000_Linux-x86-64.zip\n extracting: odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\nreplace README.txt? [y]es, [n]o, [A]ll, [N]one, [r]ename: y\n  inflating: README.txt\n[root@oda-prod software]# ls -l odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\n-rwxrwxrwx 1 root root 5550326480 May 31  2021 odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We update the repository with the patch<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-repository -f \/software\/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\n{\n  \"jobId\" : \"17adc146-c10f-418a-b08b-f7d4c9390cbc\",\n  \"status\" : \"Created\",\n  \"message\" : \"\/software\/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 09:27:17 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Repository Update\",\n  \"updatedTime\" : \"August 30, 2022 09:27:17 AM CEST\"\n}\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Be sure that the job was fine<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"17adc146-c10f-418a-b08b-f7d4c9390cbc\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  17adc146-c10f-418a-b08b-f7d4c9390cbc\n            Description:  Repository Update\n                 Status:  Success\n                Created:  August 30, 2022 9:27:17 AM CEST\n                Message:  \/software\/odacli-dcs-19.11.0.0.0-210530-GI-19.11.0.0.zip\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nUnzip bundle                             August 30, 2022 9:27:20 AM CEST     August 30, 2022 9:27:58 AM CEST     Success\nregistering image                        August 30, 2022 9:27:58 AM CEST     August 30, 2022 9:27:58 AM CEST     Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Before applying the patch, we can run the prepatch checks<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli create-prepatchreport -s -v 19.11.0.0.0\n\nJob details\n----------------------------------------------------------------\n                     ID:  09ff843d-1b4c-4a90-91ec-61004684903e\n            Description:  Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]\n                 Status:  Created\n                Created:  August 30, 2022 9:30:58 AM CEST\n                Message:  Use 'odacli describe-prepatchreport -i 09ff843d-1b4c-4a90-91ec-61004684903e' to check details of results\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
The results can be found below<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-prepatchreport -i 09ff843d-1b4c-4a90-91ec-61004684903e\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  09ff843d-1b4c-4a90-91ec-61004684903e\n            Description:  Patch pre-checks for [OS, ILOM, GI, ORACHKSERVER]\n                 Status:  SUCCESS\n                Created:  August 30, 2022 9:30:58 AM CEST\n                 Result:  All pre-checks succeeded\n\nNode Name\n---------------\noda-prod\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__OS__\nValidate supported versions     Success   Validated minimum supported versions.\nValidate patching tag           Success   Validated patching tag: 19.11.0.0.0.\nIs patch location available     Success   Patch location is available.\nVerify OS patch                 Success   Verified OS patch\nValidate command execution      Success   Validated command execution\n\n__ILOM__\nValidate supported versions     Success   Validated minimum supported versions.\nValidate patching tag           Success   Validated patching tag: 19.11.0.0.0.\nIs patch location available     Success   Patch location is available.\nChecking Ilom patch Version     Success   Successfully verified the versions\nPatch location validation       Success   Successfully validated location\nValidate command execution      Success   Validated command execution\n\n__GI__\nValidate supported GI versions  Success   Validated minimum supported versions.\nValidate available space        Success   Validated free space under \/u01\nIs clusterware running          Success   Clusterware is running\nValidate patching tag           Success   Validated patching tag: 19.11.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate ASM in online          Success   ASM is online\nValidate minimum agent version  Success   GI patching enabled in current\n                                          DCSAGENT version\nValidate clones location exist  Success   Validated clones location\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\n\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
As everything is fine, we can apply the patch. We just ensure that we have at least 20G of free space for \/ \/opt and \/u01<\/p>\n\n\n\n
[root@oda-prod software]# df -h \/ \/opt \/u01\nFilesystem                          Size  Used Avail Use% Mounted on\n\/dev\/mapper\/VolGroupSys-LogVolRoot   30G  6.5G   22G  24% \/\n\/dev\/mapper\/VolGroupSys-LogVolOpt    99G   33G   61G  36% \/opt\n\/dev\/mapper\/VolGroupSys-LogVolU01    99G   65G   29G  70% \/u01\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
And we apply the patch for the server<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-server -v 19.11.0.0.0\n{\n  \"jobId\" : \"5d3a7493-4426-4272-8ffc-59fad66a1eab\",\n  \"status\" : \"Created\",\n  \"message\" : \"Success of server update will trigger reboot of the node after 4-5 minutes. Please wait until the node reboots.\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 09:37:06 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Server Patching\",\n  \"updatedTime\" : \"August 30, 2022 09:37:06 AM CEST\"\n}\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
A few moments later we verify that the patch was fine<\/p>\n\n\n\n
[root@oda-prod log]# odacli describe-job -i 5d3a7493-4426-4272-8ffc-59fad66a1eab\n\nJob details\n----------------------------------------------------------------\n                     ID:  5d3a7493-4426-4272-8ffc-59fad66a1eab\n            Description:  Server Patching\n                 Status:  Success\n                Created:  August 30, 2022 9:37:06 AM CEST\n                Message:  Successfully patched GI with RHP\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nPatch location validation                August 30, 2022 9:37:14 AM CEST     August 30, 2022 9:37:14 AM CEST     Success\ndcs-controller upgrade                   August 30, 2022 9:37:17 AM CEST     August 30, 2022 9:37:17 AM CEST     Success\nCreating repositories using yum          August 30, 2022 9:37:17 AM CEST     August 30, 2022 9:37:19 AM CEST     Success\nUpdating YumPluginVersionLock rpm        August 30, 2022 9:37:19 AM CEST     August 30, 2022 9:37:19 AM CEST     Success\nApplying OS Patches                      August 30, 2022 9:37:19 AM CEST     August 30, 2022 9:46:49 AM CEST     Success\nCreating repositories using yum          August 30, 2022 9:46:49 AM CEST     August 30, 2022 9:46:49 AM CEST     Success\nApplying HMP Patches                     August 30, 2022 9:46:49 AM CEST     August 30, 2022 9:47:05 AM CEST     Success\nPatch location validation                August 30, 2022 9:47:05 AM CEST     August 30, 2022 9:47:05 AM CEST     Success\noda-hw-mgmt upgrade                      August 30, 2022 9:47:05 AM CEST     August 30, 2022 9:47:33 AM CEST     Success\nOSS Patching                             August 30, 2022 9:47:33 AM CEST     August 30, 2022 9:47:33 AM CEST     Success\nApplying Firmware Disk Patches           August 30, 2022 9:47:34 AM CEST     August 30, 2022 9:47:40 AM CEST     Success\nApplying Firmware Controller Patches     August 30, 2022 9:47:40 AM CEST     August 30, 2022 9:47:44 AM CEST     Success\nChecking Ilom patch Version              August 30, 2022 9:47:44 AM CEST     August 30, 2022 9:47:45 AM CEST     Success\nPatch location validation                August 30, 2022 9:47:45 AM CEST     August 30, 2022 9:47:45 AM CEST     Success\nSave password in Wallet                  August 30, 2022 9:47:45 AM CEST     August 30, 2022 9:47:45 AM CEST     Success\nApply Ilom patch                         August 30, 2022 9:47:45 AM CEST     August 30, 2022 9:56:18 AM CEST     Success\nCopying Flash Bios to Temp location      August 30, 2022 9:56:18 AM CEST     August 30, 2022 9:56:18 AM CEST     Success\nPatch location validation                August 30, 2022 9:56:18 AM CEST     August 30, 2022 9:56:18 AM CEST     Success\nASR Manager RPM update                   August 30, 2022 9:56:19 AM CEST     August 30, 2022 9:56:19 AM CEST     Success\nModify JavaExec Path                     August 30, 2022 9:56:19 AM CEST     August 30, 2022 9:56:19 AM CEST     Success\nRemove AsrConfBackup File                August 30, 2022 9:56:19 AM CEST     August 30, 2022 9:56:19 AM CEST     Success\nStarting the clusterware                 August 30, 2022 9:56:19 AM CEST     August 30, 2022 9:58:23 AM CEST     Success\ncreate ASM priv network                  August 30, 2022 9:58:23 AM CEST     August 30, 2022 9:58:27 AM CEST     Success\nconfigure ASM priv network               August 30, 2022 9:58:27 AM CEST     August 30, 2022 9:58:29 AM CEST     Success\nStarting the clusterware                 August 30, 2022 9:58:29 AM CEST     August 30, 2022 9:58:29 AM CEST     Success\nregistering image                        August 30, 2022 9:58:29 AM CEST     August 30, 2022 9:58:29 AM CEST     Success\nregistering working copy                 August 30, 2022 9:58:29 AM CEST     August 30, 2022 9:58:30 AM CEST     Success\nregistering image                        August 30, 2022 9:58:30 AM CEST     August 30, 2022 9:58:30 AM CEST     Success\nCreating GI home directories             August 30, 2022 9:58:30 AM CEST     August 30, 2022 9:58:30 AM CEST     Success\nExtract Gi clone                         August 30, 2022 9:58:30 AM CEST     August 30, 2022 9:59:55 AM CEST     Success\nProvisioning Software Only GI with RHP   August 30, 2022 9:59:55 AM CEST     August 30, 2022 10:00:56 AM CEST    Success\nPatch GI with RHP                        August 30, 2022 10:00:56 AM CEST    August 30, 2022 10:09:13 AM CEST    Success\nUpdating GiHome version                  August 30, 2022 10:09:13 AM CEST    August 30, 2022 10:09:15 AM CEST    Success\nStarting the clusterware                 August 30, 2022 10:09:19 AM CEST    August 30, 2022 10:09:19 AM CEST    Success\nremove network public interface          August 30, 2022 10:09:19 AM CEST    August 30, 2022 10:09:22 AM CEST    Success\ncreate bridge network                    August 30, 2022 10:09:22 AM CEST    August 30, 2022 10:09:27 AM CEST    Success\nmodify network public interface          August 30, 2022 10:09:27 AM CEST    August 30, 2022 10:09:28 AM CEST    Success\nUpdate System version                    August 30, 2022 10:09:28 AM CEST    August 30, 2022 10:09:28 AM CEST    Success\nCleanup JRE Home                         August 30, 2022 10:09:28 AM CEST    August 30, 2022 10:09:28 AM CEST    Success\nAdd SYSNAME in Env                       August 30, 2022 10:09:28 AM CEST    August 30, 2022 10:09:28 AM CEST    Success\nSetting ACL for disk groups              August 30, 2022 10:09:28 AM CEST    August 30, 2022 10:09:31 AM CEST    Success\npreRebootNode Actions                    August 30, 2022 10:10:39 AM CEST    August 30, 2022 10:11:30 AM CEST    Success\nReboot Ilom                              August 30, 2022 10:11:30 AM CEST    August 30, 2022 10:11:30 AM CEST    Success\n\n[root@oda-prod log]#\n\n<\/code><\/pre>\n\n\n\n
Below the component version. We can see that all components are up-to-date except the Oracle databases 19c. We will path the database later<\/p>\n\n\n\n
[root@oda-prod ~]# odacli describe-component\nSystem Version\n---------------\n19.11.0.0.0\n\nSystem node Name\n---------------\noda-prod\n\nLocal System Version\n---------------\n19.11.0.0.0\n\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK                                       19.11.0.0.0           up-to-date\n\nGI                                        19.11.0.0.210420      up-to-date\n\nDB {\n[ OraDB19000_home1 ]                      19.9.0.0.201020       19.11.0.0.210420\n[ OraDB11204_home1 ]                      11.2.0.4.201020       not-available\n}\n\nDCSAGENT                                  19.11.0.0.0           up-to-date\n\nOS                                        7.9                   up-to-date\n\nILOM                                      5.0.1.21.a.r138015    up-to-date\n\nBIOS                                      52030400              up-to-date\n\nFIRMWARECONTROLLER                        VDV1RL04              up-to-date\n\nFIRMWAREDISK                              1102                  up-to-date\n\nASR                                       20.3.0                up-to-date\n\nHMP                                       2.4.8.0.600           up-to-date\n\n\n[root@oda-prod ~]#\n<\/code><\/pre>\n\n\n\n
To patch the storage, we run the following command<\/p>\n\n\n\n
[root@oda-prod ~]# \/opt\/oracle\/dcs\/bin\/odacli update-storage -v 19.11.0.0.0\n{\n  \"jobId\" : \"eea8b12b-76d1-4695-9b29-f0102a8a67da\",\n  \"status\" : \"Created\",\n  \"message\" : \"Success of Storage Update may trigger reboot of node after 4-5 minutes. Please wait till node restart\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 10:16:38 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Storage Firmware Patching\",\n  \"updatedTime\" : \"August 30, 2022 10:16:38 AM CEST\"\n}\n[root@oda-prod ~]#\n<\/code><\/pre>\n\n\n\n
The Job returns SUCCESS<\/p>\n\n\n\n
[root@oda-prod ~]# odacli describe-job -i \"eea8b12b-76d1-4695-9b29-f0102a8a67da\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  eea8b12b-76d1-4695-9b29-f0102a8a67da\n            Description:  Storage Firmware Patching\n                 Status:  Success\n                Created:  August 30, 2022 10:16:38 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nApplying Firmware Disk Patches           August 30, 2022 10:16:45 AM CEST    August 30, 2022 10:16:49 AM CEST    Success\npreRebootNode Actions                    August 30, 2022 10:16:50 AM CEST    August 30, 2022 10:16:50 AM CEST    Success\nReboot Ilom                              August 30, 2022 10:16:50 AM CEST    August 30, 2022 10:16:50 AM CEST    Success\n\n[root@oda-prod ~]#\n<\/code><\/pre>\n\n\n\n
As the patch went fine, we can remove the odabr snapshots now<\/p>\n\n\n\n
<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/odabr\/odabr  delsnap\nINFO: 2022-08-30 10:22:10: Please check the logfile '\/opt\/odabr\/out\/log\/odabr_64634.log' for more details\n\nINFO: 2022-08-30 10:22:10: Removing LVM snapshots\nINFO: 2022-08-30 10:22:10: ...removing LVM snapshot for 'opt'\nSUCCESS: 2022-08-30 10:22:11: ...snapshot for 'opt' removed successfully\nINFO: 2022-08-30 10:22:11: ...removing LVM snapshot for 'u01'\nSUCCESS: 2022-08-30 10:22:11: ...snapshot for 'u01' removed successfully\nINFO: 2022-08-30 10:22:11: ...removing LVM snapshot for 'root'\nSUCCESS: 2022-08-30 10:22:11: ...snapshot for 'root' removed successfully\nSUCCESS: 2022-08-30 10:22:11: Remove LVM snapshots done successfully\n[root@oda-prod software]# \n<\/code><\/pre>\n\n\n\n
Patching existing databases<\/h2>\n\n\n\n
In my case only 19c databases are updated. Oracle 11g is not supported for the update.<\/p>\n\n\n\n
The first step is to unpack the corresponding file<\/p>\n\n\n\n
[root@oda-prod software]# unzip p30403662_1911000_Linux-x86-64.zip\nArchive:  p30403662_1911000_Linux-x86-64.zip\n extracting: odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\n  inflating: README.txt\n[root@oda-prod software]#\n[root@oda-prod software]# ls -l odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\n-rwxrwxrwx 1 root root 4953108233 May 31  2021 odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We load the DB 19c clone on the repository<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli update-repository -f \/software\/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\n{\n  \"jobId\" : \"87445cac-e643-474c-87ec-93b7811caa17\",\n  \"status\" : \"Created\",\n  \"message\" : \"\/software\/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\",\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 10:47:07 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Repository Update\",\n  \"updatedTime\" : \"August 30, 2022 10:47:07 AM CEST\"\n}\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We validate the status of the job<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"87445cac-e643-474c-87ec-93b7811caa17\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  87445cac-e643-474c-87ec-93b7811caa17\n            Description:  Repository Update\n                 Status:  Success\n                Created:  August 30, 2022 10:47:07 AM CEST\n                Message:  \/software\/odacli-dcs-19.11.0.0.0-210530-DB-19.11.0.0.zip\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nUnzip bundle                             August 30, 2022 10:47:09 AM CEST    August 30, 2022 10:47:44 AM CEST    Success\nregistering image                        August 30, 2022 10:47:44 AM CEST    August 30, 2022 10:47:45 AM CEST    Success\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
In the documentation<\/a> we can fine following lines<\/p>\n\n\n\n
 Starting with Oracle Database Appliance release 19.11, Oracle Database homes are not created on the local disk. Oracle Database homes are created on an Oracle ACFS-managed file system. For a database user oracle, the new database homes are created under \/u01\/app\/odaorahome\/oracle\/.<\/em><\/p>\n\n\n\n
 Before patching the database home, configure the database home storage with the odacli configure-dbhome-storage command:<\/em><\/p>\n\n\n\n
Then we create the storage for the Dbhome<\/p>\n\n\n\n
[root@oda-prod software]# odacli configure-dbhome-storage -dg DATA\n{\n  \"jobId\" : \"c82c5d33-fe67-4092-86d8-5746db2ac447\",\n  \"status\" : \"Created\",\n  \"message\" : null,\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 10:50:07 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Configure database home storage\",\n  \"updatedTime\" : \"August 30, 2022 10:50:07 AM CEST\"\n}\nYou have new mail in \/var\/spool\/mail\/root\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
The status was fine<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-job -i \"c82c5d33-fe67-4092-86d8-5746db2ac447\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  c82c5d33-fe67-4092-86d8-5746db2ac447\n            Description:  Configure database home storage\n                 Status:  Success\n                Created:  August 30, 2022 10:50:07 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nConfiguring database home storage        August 30, 2022 10:50:07 AM CEST    August 30, 2022 10:50:07 AM CEST    Success\n\n[root@oda-prod software]#\n\n\n\nrun the prepatch\n[root@oda-prod software]# odacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n2a82f095-5952-42fa-b22c-a81ca6da5f30     OraDB19000_home1     19.9.0.0.201020                          \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1     CONFIGURED\n100c93b2-0f50-43e6-a04f-bb4a78c41aeb     OraDB11204_home1     11.2.0.4.201020                          \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1     CONFIGURED\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Before patching the HOMES, we do a precheck.<\/p>\n\n\n\n
[root@oda-prod software]# \/opt\/oracle\/dcs\/bin\/odacli create-prepatchreport --dbhome --dbhomeid 2a82f095-5952-42fa-b22c-a81ca6da5f30 -v 19.11.0.0.0\n\nJob details\n----------------------------------------------------------------\n                     ID:  8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139\n            Description:  Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1\n                 Status:  Created\n                Created:  August 30, 2022 10:52:56 AM CEST\n                Message:  Use 'odacli describe-prepatchreport -i 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139' to check details of results\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
Below the results<\/p>\n\n\n\n
[root@oda-prod software]# odacli describe-prepatchreport -i 8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  8ac2998e-ce0e-47e5-b9c3-6e5fd0c49139\n            Description:  Patch pre-checks for [DB, ORACHKDB]: DbHome is OraDB19000_home1\n                 Status:  FAILED\n                Created:  August 30, 2022 10:52:56 AM CEST\n                 Result:  One or more pre-checks failed for [ORACHK]\n\nNode Name\n---------------\noda-prod\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          2a82f095-5952-42fa-b22c-a81ca6da5f30\nValidate patching tag           Success   Validated patching tag: 19.11.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\nIs DB clone registered          Success   Successfully validated clone\n                                          registered\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Failed    Orachk validation failed: .\nValidate command execution      Success   Validated command execution\nVerify the Alternate Archive    Failed    AHF-4940: One or more log archive\nDestination is Configured to              destination and alternate log archive\nPrevent Database Hangs                    destination settings are not as\n                                          recommended\nVerify the Alternate Archive    Failed    AHF-4940: One or more log archive\nDestination is Configured to              destination and alternate log archive\nPrevent Database Hangs                    destination settings are not as\n                                          recommended\nVerify the Alternate Archive    Failed    AHF-4940: One or more log archive\nDestination is Configured to              destination and alternate log archive\nPrevent Database Hangs                    destination settings are not as\n                                          recommended\nVerify the Alternate Archive    Failed    AHF-4940: One or more log archive\nDestination is Configured to              destination and alternate log archive\nPrevent Database Hangs                    destination settings are not as\n                                          recommended\nCheck for parameter             Failed    AHF-3744: Database parameter\nglobal_names                              GLOBAL_NAMES is not set to\n                                          recommended value\nCheck for parameter             Failed    AHF-3744: Database parameter\nglobal_names                              GLOBAL_NAMES is not set to\n                                          recommended value\nCheck for parameter             Failed    AHF-3744: Database parameter\nglobal_names                              GLOBAL_NAMES is not set to\n                                          recommended value\nVerify the Fast Recovery Area   Failed    AHF-2929: FRA space management\n(FRA) has reclaimable space               problem file types are present\n                                          without an RMAN backup completion\n                                          within the last 7 days\n\n\n\n[root@oda-prod software]#\n<\/code><\/pre>\n\n\n\n
We got some oracheck errors. After a look on Oracle  documentation<\/a> of the known Issues we found following lines<\/p>\n\n\n\n
AHF error in prepatch report for the update-dbhome command<\/em><\/p>\n\n\n\n
When you patch server to Oracle Database Appliance release 19.13, the odacli update-dbhome command may fail.<\/em><\/p>\n\n\n\n
The following error message is displayed in the pre-patch report:<\/em><\/p>\n\n\n\n
Verify the Alternate Archive    Failed    AHF-4940: One or more log archive<\/em><\/p>\n\n\n\n
Destination is Configured to              destination and alternate log archive<\/em><\/p>\n\n\n\n
Prevent Database Hangs                    destination settings are not as recommended          <\/em><\/p>\n\n\n\n
Hardware Models<\/em><\/p>\n\n\n\n
All Oracle Database Appliance hardware models<\/em><\/p>\n\n\n\n
Workaround<\/em><\/p>\n\n\n\n
Follow these steps:<\/em><\/p>\n\n\n\n
    Run the odacli update-dbhome command with the -f option.<\/em><\/p>\n\n\n\n
    \/opt\/oracle\/dcs\/bin\/odacli update-dbhome –dbhomeid 7c67c5b4-f585-4ba9-865f-c719c63c0a6e -v 19.13.0.0.0 -f<\/em><\/p>\n\n\n\n
This issue is tracked with Oracle bug 33144170.<\/em><\/p>\n\n\n\n
For the error relative to the global_name, we change the value to true and will set it back to false after the patch<\/p>\n\n\n\n
And then we run the patch with the option -f <\/p>\n\n\n\n
[root@oda-prod archivelog]# \/opt\/oracle\/dcs\/bin\/odacli update-dbhome --dbhomeid 2a82f095-5952-42fa-b22c-a81ca6da5f30 -v 19.11.0.0.0 -f\n\n{\n  \"jobId\" : \"4b499623-9ca9-4089-b18b-5c13af1d9067\",\n  \"status\" : \"Created\",\n  \"message\" : null,\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 30, 2022 11:15:58 AM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"DB Home Patching: Home Id is 2a82f095-5952-42fa-b22c-a81ca6da5f30\",\n  \"updatedTime\" : \"August 30, 2022 11:15:58 AM CEST\"\n}\n[root@oda-prod archivelog]#\n<\/code><\/pre>\n\n\n\n
A few moments after the patch was fine<\/p>\n\n\n\n
[root@oda-prod ~]# odacli describe-job -i \"4b499623-9ca9-4089-b18b-5c13af1d9067\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  4b499623-9ca9-4089-b18b-5c13af1d9067\n            Description:  DB Home Patching: Home Id is 2a82f095-5952-42fa-b22c-a81ca6da5f30\n                 Status:  Success\n                Created:  August 30, 2022 11:15:58 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nCreating ACFS database home              August 30, 2022 11:16:11 AM CEST    August 30, 2022 11:17:01 AM CEST    Success\nValidating dbHome available space        August 30, 2022 11:17:01 AM CEST    August 30, 2022 11:17:01 AM CEST    Success\nCreating DbHome Directory                August 30, 2022 11:17:01 AM CEST    August 30, 2022 11:17:01 AM CEST    Success\nCreate required directories              August 30, 2022 11:17:01 AM CEST    August 30, 2022 11:17:01 AM CEST    Success\nExtract DB clones                        August 30, 2022 11:17:01 AM CEST    August 30, 2022 11:18:09 AM CEST    Success\nProvDbHome by using RHP                  August 30, 2022 11:18:09 AM CEST    August 30, 2022 11:19:11 AM CEST    Success\nEnable DB options                        August 30, 2022 11:19:11 AM CEST    August 30, 2022 11:19:26 AM CEST    Success\nCreating wallet for DB Client            August 30, 2022 11:19:29 AM CEST    August 30, 2022 11:19:29 AM CEST    Success\nCreating wallet for DB Client            August 30, 2022 11:19:53 AM CEST    August 30, 2022 11:19:53 AM CEST    Success\nPatch databases by RHP                   August 30, 2022 11:19:53 AM CEST    August 30, 2022 11:24:11 AM CEST    Success\nupdating database metadata               August 30, 2022 11:24:54 AM CEST    August 30, 2022 11:24:54 AM CEST    Success\nPatch databases by RHP                   August 30, 2022 11:24:54 AM CEST    August 30, 2022 11:29:01 AM CEST    Success\nupdating database metadata               August 30, 2022 11:29:41 AM CEST    August 30, 2022 11:29:41 AM CEST    Success\nUpdate System version                    August 30, 2022 11:29:41 AM CEST    August 30, 2022 11:29:41 AM CEST    Success\nUpdating metadata for database           August 30, 2022 11:30:09 AM CEST    August 30, 2022 11:30:09 AM CEST    Success\nUpdating metadata for database           August 30, 2022 11:30:09 AM CEST    August 30, 2022 11:30:09 AM CEST    Success\n\n[root@oda-prod ~]#\n<\/code><\/pre>\n\n\n\n
Connecting to the 19c database we can verify that the RU is now 19.11<\/p>\n\n\n\n
SQL> select description from dba_registry_sqlpatch;\n\nDESCRIPTION\n--------------------------------------------------------------------------------\nOJVM RELEASE UPDATE: 19.9.0.0.201020 (31668882)\nDatabase Release Update : 19.9.0.0.201020 (31771877)\nOJVM RELEASE UPDATE: 19.9.0.0.201020 (31668882)\nOJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)\nDatabase Release Update : 19.11.0.0.210420 (32545013)\n\nSQL>\n<\/code><\/pre>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Hope this blog help<\/p>\n","protected":false},"excerpt":{"rendered":"
By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI\/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI\/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI\/DCS stack Patching the Oracle Database […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,42,59],"tags":[2567,1327,2098,2687],"type_dbi":[],"class_list":["post-18837","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-operating-systems","category-oracle","tag-oda-2","tag-odacli","tag-oracle-appliance","tag-patch-oda"],"acf":[],"yoast_head":"\nPatch ODA X8 : 19.9 to 19.11 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Patch ODA X8 : 19.9 to 19.11\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI\/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI\/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI\/DCS stack Patching the Oracle Database […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-07T14:52:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:17:37+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Patch ODA X8 : 19.9 to 19.11\",\"datePublished\":\"2022-09-07T14:52:06+00:00\",\"dateModified\":\"2023-06-20T08:17:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\"},\"wordCount\":725,\"commentCount\":0,\"keywords\":[\"oda\",\"odacli\",\"Oracle appliance\",\"Patch ODA\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\",\"name\":\"Patch ODA X8 : 19.9 to 19.11 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-09-07T14:52:06+00:00\",\"dateModified\":\"2023-06-20T08:17:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Patch ODA X8 : 19.9 to 19.11\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Patch ODA X8 : 19.9 to 19.11 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/","og_locale":"en_US","og_type":"article","og_title":"Patch ODA X8 : 19.9 to 19.11","og_description":"By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI\/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI\/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI\/DCS stack Patching the Oracle Database […]","og_url":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/","og_site_name":"dbi Blog","article_published_time":"2022-09-07T14:52:06+00:00","article_modified_time":"2023-06-20T08:17:37+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Patch ODA X8 : 19.9 to 19.11","datePublished":"2022-09-07T14:52:06+00:00","dateModified":"2023-06-20T08:17:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/"},"wordCount":725,"commentCount":0,"keywords":["oda","odacli","Oracle appliance","Patch ODA"],"articleSection":["Database Administration & Monitoring","Database management","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/","url":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/","name":"Patch ODA X8 : 19.9 to 19.11 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-09-07T14:52:06+00:00","dateModified":"2023-06-20T08:17:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/patch-oda-x8-19-9-to-19-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Patch ODA X8 : 19.9 to 19.11"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=18837"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18837\/revisions"}],"predecessor-version":[{"id":26143,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18837\/revisions\/26143"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=18837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=18837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=18837"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=18837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}