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

Les deux révisions précédentesRévision précédente
Prochaine révision
Révision précédente
oracle:oda:patch_oda_from_19.20_to_19.21 [15/04/2025 09:20] mdloracle:oda:patch_oda_from_19.20_to_19.21 [15/04/2025 09:45] (Version actuelle) mdl
Ligne 1: Ligne 1:
 ====== Patch ODA from 19.20 to 19.21 ====== ====== Patch ODA from 19.20 to 19.21 ======
 +<color #ed1c24>This procedure includes  ODA reimaging</color>
  \\  \\
-The patch 19.20 to 19.21 will use the Data Preserving method+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**   *** Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning**
- 
   - Download the Oracle Database Appliance Server Patch  (patch 35938481)   - Download the Oracle Database Appliance Server Patch  (patch 35938481)
   - Unzip the software   - Unzip the software
Ligne 17: Ligne 17:
   - Save the files generated by the system deconfiguration and store them outside of the Oracle Database Appliance system     - 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**
-== 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)   - 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   - Plumb the network as described in the topic Plumbing the Network
   - configure-firstnet.rsp ( in the zip file saved)   - configure-firstnet.rsp ( in the zip file saved)
  
- \\ +  * **Step 3: Reprovisioning Nodes Using Data Preserving Reprovisioning Method**
-== 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)   - Update the repository with the Oracle Database Appliance release 19.21.0.0.0 Server Patch (patch 35938481)
   - Create the pre-patch report    - Create the pre-patch report 
Ligne 34: Ligne 31:
   - Restore Oracle Grid Infrastructure   - Restore Oracle Grid Infrastructure
   - Restore the database   - Restore the database
 + \\
 +===  Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning  ===
  
-Below the detailed steps for the patching +  * 1.1 Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 35938481) 
- +  1-2 Unzip the patch 
-Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning +<code BASH>
-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 45: 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 60: 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 79: 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 94: 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 116: 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 131: 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 148: 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 171: 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 187: 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 330: 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 358: 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 422: 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 454: 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 501: 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 509: 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 528: 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 549: 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 566: 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 616: 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 633: 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 681: 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 726: 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 772: 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 787: 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 807: 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 845: 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 877: 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 968: 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 985: 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 1031: 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 1048: 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 1140: 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 1159: 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 1217: 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 1261: 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>