Differences

This shows you the differences between two versions of the page.

--- wiki:how_to_cleanup_old_updates [2024/01/05 16:34] – created wagner.jer
+++ wiki:how_to_cleanup_old_updates [2024/10/15 11:48] (current) – wagner.jer
@@ Line 1: / Line 1: @@
 Old patches are stored in %ORACLE_HOME%\.patch_store\\
 \\
-Make sure that the %ORACLE_HOME% variable is defined using following command:
+- Run CMD.exe as administrator
+- Make sure that the %ORACLE_HOME% variable is defined using following command:
 <cli type=dos>echo %ORACLE_HOME%
 %ORACLE_HOME%</cli>
-When not defined (as above), use following command to define it:
+- When not defined (as above), use following command to define it:
-<cli>set ORACLE_HOME=C:\oracle\product\19.3.0\dbhome_1
+<cli type=dos>set ORACLE_HOME=C:\oracle\product\19.3.0\dbhome_1
 echo %ORACLE_HOME%
 C:\oracle\product\19.3.0\dbhome_1</cli>
-Make sure that the %PATH% variable contains %ORACLE_HOME%\perl\bin using following command:
+- Make sure that the %PATH% variable contains %ORACLE_HOME%\perl\bin using following command:
 <cli type=dos>echo %PATH%
 %PATH%</cli>
-When not containing the %ORACLE_HOME%\perl\bin (as above), use following command to define it (Make sure you include the %PATH% or you will overwrite your current variable with wrong setting:
+- When not containing the %ORACLE_HOME%\perl\bin (as above), use following command to define it (Make sure you include the %PATH% or you will overwrite your current variable with wrong setting):
-<cli type=dos>set PATH=%ORACLE_HOME%\perl\bin;%PATH%</cli>
+<cli type=dos>set PATH=%ORACLE_HOME%\perl\bin;%PATH%
+echo %PATH%
+C:\oracle\product\19.3.0\dbhome_1\perl\bin;C:\oracle\product\19.3.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Users\admjwa\AppData\Local\Microsoft\WindowsApps</cli>
+- Navigate to the OPatch folder
+<cli>cd %ORACLE_HOME%\opatch</cli>
+- Check that OPatch version is above 12.2.0.1.37 (April 2023)
+<cli type=dos>opatch version
+OPatch Version: 12.2.0.1.40
+OPatch succeeded.</cli>
+- List the patches that can be deleted using OPatch
+<cli type=dos>opatch util listorderedinactivepatches
+Oracle Interim Patch Installer version 12.2.0.1.40
+Copyright (c) 2024, Oracle Corporation.  All rights reserved.
+Oracle Home       : C:\oracle\product\19.3.0\dbhome_1
+Central Inventory : C:\Program Files\Oracle\Inventory
+from           :
+OPatch version    : 12.2.0.1.40
+OUI version       : 12.2.0.7.0
+Log file location : C:\oracle\product\19.3.0\dbhome_1\cfgtoollogs\opatch\opatch2024-01-04_11-03-24AM_1.log
+Invoking utility "listorderedinactivepatches"
+List Inactive patches option provided
+The oracle home has the following inactive patch(es) and their respective overlay patches:
+The number of RU chains is  1
+***** There are 9 inactive RU patches in chain 1
+-Inactive RU/BP 31719903:Windows Database Bundle Patch : 19.9.0.0.201020 (31719903), installed on: Thu Feb 18 10:54:04 CET 2021, with no overlays
+-Inactive RU/BP 32062765:Windows Database Bundle Patch : 19.10.0.0.210119 (32062765), installed on: Wed Apr 21 10:03:31 CEST 2021, with no overlays
+-Inactive RU/BP 32409154:Windows Database Bundle Patch : 19.11.0.0.210420 (32409154), installed on: Wed May 19 11:16:49 CEST 2021, with no overlays
+-Inactive RU/BP 32832237:Windows Database Bundle Patch : 19.12.0.0.210720 (32832237), installed on: Tue Sep 28 13:41:01 CEST 2021, with no overlays
+-Inactive RU/BP 33155330:Windows Database Bundle Patch : 19.13.0.0.211019 (33155330), installed on: Thu Dec 02 12:51:24 CET 2021, with no overlays
+-Inactive RU/BP 33575656:Windows Database Bundle Patch : 19.14.0.0.220118 (33575656), installed on: Thu Mar 10 11:46:14 CET 2022, with no overlays
+-Inactive RU/BP 34110685:Windows Database Bundle Patch : 19.16.0.0.220719 (34110685), installed on: Tue Sep 20 15:45:36 CEST 2022, with no overlays
+-Inactive RU/BP 34468114:Windows Database Bundle Patch : 19.17.0.0.221018 (34468114), installed on: Tue May 30 20:02:30 CEST 2023, with no overlays
+-Inactive RU/BP 35046439:Windows Database Bundle Patch : 19.19.0.0.230418 (35046439), installed on: Thu Aug 17 19:01:51 CEST 2023, with no overlays
+-Active RU/BP 35681552:Windows Database Bundle Patch : 19.21.0.0.231017 (35681552), installed on: Tue Nov 28 10:05:15 CET 2023, with no overlays
+OPatch succeeded.</cli>
+- Delete inactive patches except the latest inactive patche using following command (Last one will be kept in case you need to rollback):
+<cli type=dos>opatch util deleteinactivepatches
+Oracle Interim Patch Installer version 12.2.0.1.40
+Copyright (c) 2024, Oracle Corporation.  All rights reserved.
+Oracle Home       : C:\oracle\product\19.3.0\dbhome_1
+Central Inventory : C:\Program Files\Oracle\Inventory
+   from           :
+OPatch version    : 12.2.0.1.40
+OUI version       : 12.2.0.7.0
+Log file location : C:\oracle\product\19.3.0\dbhome_1\cfgtoollogs\opatch\opatch2024-01-04_11-07-25AM_1.log
+Invoking utility "deleteinactivepatches"
+Inactive Patches Cleanup option provided
+Delete Inactive Patches .......
+***** There are 9 inactive RU patches in chain 1
+***** 8 inactive patches will be deleted
+-To be deleted inactive RU/BP 31719903:Windows Database Bundle Patch : 19.9.0.0.201020 (31719903), installed on: Thu Feb 18 10:54:04 CET 2021, with no overlays
+-To be deleted inactive RU/BP 32062765:Windows Database Bundle Patch : 19.10.0.0.210119 (32062765), installed on: Wed Apr 21 10:03:31 CEST 2021, with no overlays
+-To be deleted inactive RU/BP 32409154:Windows Database Bundle Patch : 19.11.0.0.210420 (32409154), installed on: Wed May 19 11:16:49 CEST 2021, with no overlays
+-To be deleted inactive RU/BP 32832237:Windows Database Bundle Patch : 19.12.0.0.210720 (32832237), installed on: Tue Sep 28 13:41:01 CEST 2021, with no overlays
+-To be deleted inactive RU/BP 33155330:Windows Database Bundle Patch : 19.13.0.0.211019 (33155330), installed on: Thu Dec 02 12:51:24 CET 2021, with no overlays
+-To be deleted inactive RU/BP 33575656:Windows Database Bundle Patch : 19.14.0.0.220118 (33575656), installed on: Thu Mar 10 11:46:14 CET 2022, with no overlays
+-To be deleted inactive RU/BP 34110685:Windows Database Bundle Patch : 19.16.0.0.220719 (34110685), installed on: Tue Sep 20 15:45:36 CEST 2022, with no overlays
+-To be deleted inactive RU/BP 34468114:Windows Database Bundle Patch : 19.17.0.0.221018 (34468114), installed on: Tue May 30 20:02:30 CEST 2023, with no overlays
+-To be retained inactive RU/BP 35046439:Windows Database Bundle Patch : 19.19.0.0.230418 (35046439), installed on: Thu Aug 17 19:01:51 CEST 2023, with no overlays
+-Active RU/BP 35681552:Windows Database Bundle Patch : 19.21.0.0.231017 (35681552), installed on: Tue Nov 28 10:05:15 CET 2023, with no overlays
+Do you want to proceed? [y|n]</cli>
+- Confirm typing "y" + Enter
+<cli type=dos>y
+User Responded with: Y
+Deleted RU/BP patch: 31719903
+Deleted RU/BP patch: 32062765
+Deleted RU/BP patch: 32409154
+Deleted RU/BP patch: 32832237
+Deleted RU/BP patch: 33155330
+Deleted RU/BP patch: 33575656
+Deleted RU/BP patch: 34110685
+Deleted RU/BP patch: 34468114
+OPatch succeeded.</cli>