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:23] 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 
Ligne 16: 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)
Ligne 32: Ligne 32:
   - Restore the database   - Restore the database
  \\  \\
-=== __Step 1: Detaching Nodes for Upgrade Using Data Preserving Reprovisioning__ ===+===  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.1 Download the Oracle Database Appliance Server Patch for the ODACLI/DCS stack (patch 35938481) 
-1-2 Unzip the patch+  1-2 Unzip the patch 
 +<code BASH>
 [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 41: 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 56: 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 75: 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 90: 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 112: 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 127: 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 144: 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 167: 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 183: 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 326: 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 354: 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 418: 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 450: 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 497: 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 505: 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 524: 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 545: 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 562: 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 612: 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 629: 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 677: 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 722: 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 768: 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 783: 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 803: 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 841: 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 873: 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 964: 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 981: 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 1027: 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 1044: 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 1136: 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 1155: 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 1213: 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 1257: 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>