meta données pour cette page
  •  

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Prochaine révision		Révision précédente
oracle:oda:patch_oda_from_19.20_to_19.21 [15/04/2025 09:12] – créée mdloracle:oda:patch_oda_from_19.20_to_19.21 [15/04/2025 09:45] (Version actuelle) – mdl
Ligne 1: Ligne 1:
-The patch 19.20 to 19.21 will use the Data Preserving method+====== Patch ODA from 19.20 to 19.21 ====== 
 +<color #ed1c24>This procedure includes  ODA reimaging</color> 
 + \\ 
 +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  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  
  
-1- Detach resources and software from the source version of the appliance +  * **Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning** 
-2- Reimage nodes using the Oracle Database Appliance ISO image +  - Download the Oracle Database Appliance release 19.21 bare metal ISO image and reimage the appliance (Patch 30403643) 
-3- Restore nodes using the Data Preserving Reprovisioning method+  - Plumb the network as described in the topic Plumbing the Network 
 +  - configure-firstnet.rsp ( in the zip file saved)
  
-4-Update Existing dbhomes+  * **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) 
-Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning +  * 1-2 Unzip the patch 
-1- Download the Oracle Database Appliance Server Patch  (patch 35938481) +<code BASH>
-2- Unzip the software +
-3- Update the repository with the server software +
-4- Update DCS admin +
-5- Update the DCS components +
-6- Update the DCS agent +
-7- Create the pre-upgrade report to run upgrade pre-checks +
-8- Detach the system for an operating system upgrade +
-9- Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance system   +
- +
-Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning +
-1- Download the Oracle Database Appliance release 19.21 bare metal ISO image and reimage the appliance +
---Patch 30403643 +
- +
-2- Plumb the network as described in the topic Plumbing the Network +
-configure-firstnet.rsp ( in the zip file saved) +
- +
-Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method +
-1- Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch (patch 35938481) +
-2- Create the pre-patch report  +
-3- Apply the server update +
-4- Run Prepatch report for the storage +
-5- Update the storage components +
-6- Update the storage components patch 30403673 +
-7- Restore Oracle Grid Infrastructure +
-8- Restore the database +
- +
-Below the detailled steps for the patching +
- +
-Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning +
-1.1 Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 35938481) +
-1-2 Unzip the patch+
 [root@moros patch_1921]# unzip p35938481_1921000_Linux-x86-64.zip [root@moros patch_1921]# unzip p35938481_1921000_Linux-x86-64.zip
 Archive:  p35938481_1921000_Linux-x86-64.zip Archive:  p35938481_1921000_Linux-x86-64.zip
Ligne 48: Ligne 42:
   inflating: README.txt   inflating: README.txt
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-1.3 Update the repository with the server software file+  * 1.3 Update the repository with the server software file 
 +<code BASH>
 [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 [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
 { {
Ligne 63: Ligne 58:
 } }
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-Validate the job status +  * Validate the job status 
- +<code BASH>
 [root@moros patch_1921]# odacli describe-job -i "187e6c62-c356-4327-b7df-0a9e3d5f084e" [root@moros patch_1921]# odacli describe-job -i "187e6c62-c356-4327-b7df-0a9e3d5f084e"
  
Ligne 82: Ligne 76:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-1.4 Update DCS admin+  * 1.4 Update DCS admin 
 +<code BASH>
 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.21.0.0.0 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsadmin -v 19.21.0.0.0
 { {
Ligne 97: Ligne 92:
 } }
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@moros patch_1921]# odacli describe-job -i "f53559f1-8828-482a-8bb7-111e2b75377d" [root@moros patch_1921]# odacli describe-job -i "f53559f1-8828-482a-8bb7-111e2b75377d"
  
Ligne 119: Ligne 112:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
-1.5 Update the DCS components +  * 1.5 Update the DCS components 
- +<code BASH>
 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.21.0.0.0 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcscomponents -v 19.21.0.0.0
 { {
Ligne 134: Ligne 127:
 } }
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-1.6 Update the DCS agent +  * 1.6 Update the DCS agent 
- +<code BASH>
 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.21.0.0.0 [root@moros patch_1921]# /opt/oracle/dcs/bin/odacli update-dcsagent -v 19.21.0.0.0
 { {
Ligne 151: Ligne 143:
 } }
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@moros patch_1921]# odacli describe-job -i "4c5cbf22-0e70-4f80-acef-33f57eb542ff" [root@moros patch_1921]# odacli describe-job -i "4c5cbf22-0e70-4f80-acef-33f57eb542ff"
  
Ligne 174: Ligne 164:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-1.7 Run upgrade pre-checks+  * 1.7 Run upgrade pre-checks 
 +<code BASH>
 [root@moros patch_1921]# odacli create-preupgradereport -bm [root@moros patch_1921]# odacli create-preupgradereport -bm
  
Ligne 190: Ligne 181:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
- +  * Check the report, any error should be corrected 
-Check the report, any error should be corrected +<code BASH>
- +
- +
 [root@moros patch_1921]# odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905 [root@moros patch_1921]# odacli describe-preupgradereport -i 61a34d7c-1656-47ec-aeb6-c3bbd1a4f905
  
Ligne 333: Ligne 322:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
- +</code> 
-1.8 detach the system for an operating system upgrade+  * 1.8 detach the system for an operating system upgrade 
 +<code BASH>
 [root@moros patch_1921]# odacli detach-node -all [root@moros patch_1921]# odacli detach-node -all
 ******************************************************************************** ********************************************************************************
Ligne 361: Ligne 351:
 } }
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@moros patch_1921]# odacli describe-job -i "36428cf3-16a3-4ad2-aa2a-48d772c73eee" [root@moros patch_1921]# odacli describe-job -i "36428cf3-16a3-4ad2-aa2a-48d772c73eee"
  
Ligne 425: Ligne 413:
  
 [root@moros patch_1921]# [root@moros patch_1921]#
 +</code>
  
-1.9 Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance+  * 1.9 Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance 
 +<code BASH>
 [root@phanes out_oda_moros_patch]# ls [root@phanes out_oda_moros_patch]# ls
 files  serverarchive_moros.zip  serverarchive_moros.zip.sha256 files  serverarchive_moros.zip  serverarchive_moros.zip.sha256
 [root@phanes out_oda_moros_patch]# [root@phanes out_oda_moros_patch]#
 +</code>
 +=== Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning ===
  
-Step 2: Reimaging Nodes for Upgrading Using Data Preserving Reprovisioning +  * 2.1  Reimage
-2.1  Reimage +
  
 Do the reimage according the documentation 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]]
  
-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
- +
-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. 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.
 +<code BASH>
 localhost login: root localhost login: root
 Password: Password:
Ligne 457: Ligne 446:
 WARNING: Cannot ping the default gateway, please check the network information manually WARNING: Cannot ping the default gateway, please check the network information manually
 [root@oak ~]# [root@oak ~]#
 +</code>
  
- +  * We can check the status of the components 
-We can check the status of the components +<code BASH>
- +
- +
 [root@oak ~]# odacli describe-component [root@oak ~]# odacli describe-component
 System Version System Version
Ligne 504: Ligne 491:
  
 [root@oak ~]# [root@oak ~]#
 +</code>
 +=== Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method ===
  
-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 
-3.1 Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch+<code BASH>
 [root@oak Download]# unzip p35938481_1921000_Linux-x86-64.zip [root@oak Download]# unzip p35938481_1921000_Linux-x86-64.zip
 Archive:  p35938481_1921000_Linux-x86-64.zip Archive:  p35938481_1921000_Linux-x86-64.zip
Ligne 512: Ligne 501:
   inflating: README.txt   inflating: README.txt
 [root@oak Download]# [root@oak Download]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip [root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/oda-sm-19.21.0.0.0-231220-server.zip
 { {
Ligne 531: Ligne 518:
 } }
 [root@oak Download]# [root@oak Download]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@oak Download]# odacli describe-job -i "d74fc503-3007-4774-bc63-3f938179d2a8" [root@oak Download]# odacli describe-job -i "d74fc503-3007-4774-bc63-3f938179d2a8"
  
Ligne 552: Ligne 537:
  
 [root@oak Download]# [root@oak Download]#
- +</code> 
-3.2  Apply the Server Patch  +  * 3.2  Apply the Server Patch  
-3.1.1 Run Prepatch Report+  * Run Prepatch Report 
 +<code BASH>
 [root@oak Download]# odacli create-prepatchreport -s -v 19.21.0.0.0 [root@oak Download]# odacli create-prepatchreport -s -v 19.21.0.0.0
  
Ligne 569: Ligne 555:
  
 [root@oak Download]# [root@oak Download]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@oak Download]# odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e [root@oak Download]# odacli describe-prepatchreport -i b3745161-b18f-48bd-8b79-1f2d8d46770e
  
Ligne 619: Ligne 603:
  
 [root@oak Download]# [root@oak Download]#
 +</code>
  
- +  * 3.1.2 Apply the server patch 
-3.1.2 Apply the server patch +<code BASH>
 [root@oak Download]#  /opt/oracle/dcs/bin/odacli update-server -v 19.21.0.0.0 [root@oak Download]#  /opt/oracle/dcs/bin/odacli update-server -v 19.21.0.0.0
 { {
Ligne 636: Ligne 620:
 } }
 [root@oak Download]# [root@oak Download]#
 +</code>
  
- +  * Validate the job 
-Validate the job +<code BASH>
- +
- +
 [root@oak ~]#  odacli describe-job -i "808035e1-39b0-472a-b668-74beeada3cfa" [root@oak ~]#  odacli describe-job -i "808035e1-39b0-472a-b668-74beeada3cfa"
  
Ligne 684: Ligne 666:
  
 [root@oak ~]# [root@oak ~]#
 +</code>
  
- +  * Now the component status 
-Now the component status +<code BASH>
 [root@oak ~]# odacli describe-component [root@oak ~]# odacli describe-component
 System Version System Version
Ligne 729: Ligne 711:
  
 [root@oak ~]# [root@oak ~]#
- +</code> 
-3.3 Update the storage components +  * 3.3 Update the storage components 
-3.3.1  Run prepatch storage report+  * Run prepatch storage report 
 +<code BASH>
 [root@oak ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.21.0.0.0 [root@oak ~]# /opt/oracle/dcs/bin/odacli create-prepatchreport -st -v 19.21.0.0.0
  
Ligne 775: Ligne 758:
  
 [root@oak ~]# [root@oak ~]#
 +</code>
  
-3.3.2  Patch the storage+  * Patch the storage 
 +<code BASH>
 [root@oak ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.21.0.0.0 [root@oak ~]# /opt/oracle/dcs/bin/odacli update-storage -v 19.21.0.0.0
 { {
Ligne 790: Ligne 775:
 } }
 [root@oak ~]# [root@oak ~]#
- 
  
 [root@oak ~]# odacli describe-job -i "3b3ec526-da19-4a86-bf59-80e029fe7bd6" [root@oak ~]# odacli describe-job -i "3b3ec526-da19-4a86-bf59-80e029fe7bd6"
Ligne 810: Ligne 794:
  
 [root@oak ~]# [root@oak ~]#
- +</code> 
-3.4 Update the repository with the 19.21 Oracle Grid Infrastructure : p30403673_1921000_Linux-x86-64.zip+  * 3.4 Update the repository with the 19.21 Oracle Grid Infrastructure : p30403673_1921000_Linux-x86-64.zip 
 +<code BASH>
 [root@oak Download]# unzip p30403673_1921000_Linux-x86-64.zip [root@oak Download]# unzip p30403673_1921000_Linux-x86-64.zip
 Archive:  p30403673_1921000_Linux-x86-64.zip Archive:  p30403673_1921000_Linux-x86-64.zip
Ligne 848: Ligne 833:
  
 [root@oak Download]# [root@oak Download]#
- +</code> 
-3.5  Update the repository with the server data archive files generated in Step 1+  * 3.5  Update the repository with the server data archive files generated in Step 1 
 +<code BASH>
 [root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/serverarchive_moros.zip [root@oak Download]# /opt/oracle/dcs/bin/odacli update-repository -f /u01/Download/serverarchive_moros.zip
 { {
Ligne 880: Ligne 866:
  
 [root@oak Download]# [root@oak Download]#
 +</code>
  
-3.6 Restore Oracle Grid Infrastructure+  * 3.6 Restore Oracle Grid Infrastructure 
 +<code BASH>
 [root@oak Download]# odacli restore-node -g [root@oak Download]# odacli restore-node -g
 Enter New system password: Enter New system password:
Ligne 971: Ligne 959:
  
 [root@moros ~]# [root@moros ~]#
 +</code>
  
-3.7 Restore the database +  * 3.7 Restore the database 
- +<code BASH>
 [root@moros ~]#  odacli restore-node -d [root@moros ~]#  odacli restore-node -d
 { {
Ligne 988: Ligne 976:
 } }
 [root@moros ~]# [root@moros ~]#
 +</code>
  
- +  * The first time we got some errors due to wallet not saved before the reimage 
-The first time we got some errors due to wallet not saved before the reimage +<code BASH>
- +
 [root@moros ~]# odacli describe-job -i "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98" [root@moros ~]# odacli describe-job -i "3d8bfad0-d2fc-4aa8-bf85-f6f170ed2a98"
  
Ligne 1034: Ligne 1021:
 +-- Adding database instance(s) to GI    January 16, 2024 7:25:09 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 +-- Modifying SPFILE for database        January 16, 2024 7:25:09 PM CET          January 16, 2024 7:25:09 PM CET          Failure
 +</code>
  
- +  * I then decide to restore only database without wallet 
-I then decide to restore only database without wallet +<code BASH>
- +
 [root@moros restore]# odacli restore-node -d [root@moros restore]# odacli restore-node -d
 { {
Ligne 1051: Ligne 1037:
   "jobType" : null   "jobType" : null
 } }
 +</code>
  
- +  * And the job went fine 
-And the job went fine +<code BASH>
- +
 [root@moros restore]# odacli describe-job -i "92406b7e-9803-4cb6-a0b6-b1ba749acd00" [root@moros restore]# odacli describe-job -i "92406b7e-9803-4cb6-a0b6-b1ba749acd00"
  
Ligne 1143: Ligne 1128:
  
 [root@moros app]# [root@moros app]#
 +</code>
  
 +=== Step 4 : Update Existing dbhomes ===
  
-Step 4 : Update Existing dbhomes +  * 4.1 Update Repository 
-4.1 Update Repository+<code BASH>
 [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 update-repository -f /u01/Download/odacli-dcs-19.21.0.0.0-231211-DB-19.21.0.0.zip
  
Ligne 1162: Ligne 1149:
 Unzip bundle                             January 17, 2024 1:09:11 AM CET          January 17, 2024 1:09:43 AM CET          Success Unzip bundle                             January 17, 2024 1:09:11 AM CET          January 17, 2024 1:09:43 AM CET          Success
 [root@moros ~]# [root@moros ~]#
 +</code>
  
-4.2 List databases +  * 4.2 List databases 
- +<code BASH>
 [root@moros ~]# odacli list-dbhomes [root@moros ~]# odacli list-dbhomes
 ID                                       Name                 DB Version                     DB Edition Home Location                                           Status ID                                       Name                 DB Version                     DB Edition Home Location                                           Status
Ligne 1220: Ligne 1207:
 Running orachk                  Success   Successfully ran Orachk Running orachk                  Success   Successfully ran Orachk
 Validate command execution      Success   Validated command execution Validate command execution      Success   Validated command execution
-4.4 Patch the dbhomes+</code> 
 + 
 +  * 4.4 Patch the dbhomes 
 +<code BASH>
 [root@moros ~]# /opt/oracle/dcs/bin/odacli update-dbhome --id 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0 [root@moros ~]# /opt/oracle/dcs/bin/odacli update-dbhome --id 1cbf6d6f-47f9-4a83-8055-36c6212a1ebe -v 19.21.0.0.0
 { {
Ligne 1264: Ligne 1254:
 Generating and saving BOM                January 30, 2024 11:36:19 AM CET         January 30, 2024 11:37:22 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 TDE parameter update                     January 30, 2024 11:38:37 AM CET         January 30, 2024 11:38:37 AM CET         Success
 +</code>