Oracle DB Patch Installation

1.2 Oracle DB Patch Installation

Perform these steps for applying latest Oracle DB patch.

Note:

This section has been created to ease the patch installation process. Refer to README.html of individual patches for any further information or clarification during patch installation). Do not consider these steps as replacement for official patch README documents.
This patch has to be applied on IDIH Oracle server only.

List current patches applied using the following command:

opatch
                        lspatches

The output must be as follows:

34412250;Database PSU 12.1.0.2.221018,Oracle JavaVM Component
    (OCT2022)

34386266;Database Patch Set Update : 12.1.0.2.221018
    (34386266)

Following are the steps to download October 2023 DB PSU and January 2024 OJVM patches:
1. Log in to support.oracle.com
2. Click Patches and updates tab.
3. Enter 35564645 in patch number search field and click Search.
4. Click DATABASE PATCH SET UPDATE 12.1.0.2.231017 (Patch) for Linux x86-64 platform.
5. Click Download to download the patch to your local machine from the new window.
6. Repeat the same process for 35926723 patch as well.
It is recommended to take a backup of ORACLE_HOME binaries and Central Inventory prior to applying patches. For more information, see 565017.1.
The Central Inventory where the ORACLE_HOME is registered should also be part of the backup and taken at the same time as the ORACLE_HOME backup for consistency. Take a backup of /u01/app/oraInventory and restore it later if necessary.
Use the OPatch utility version 12.2.0.1.37 or later. To apply this patch, Oracle recommends that you use the latest released OPatch version for 12.2, which is available for download from My Oracle Support patch 6880880 (https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6880880) by selecting the 12.2.0.1.0 release.
Install OPatch
To install this patch, extract the "zipped file" directly under the ORACLE_HOME. Perform the following steps for extracting the zip file of OPatch:
1. Take a backup of ORACLE_HOME/OPatch into a dedicated backup location.
  
  Note:
  This step can be ignored if backup is already taken.
2. Ensure that no directory ORACLE_HOME/OPatch exists.
3. Unzip the OPatch downloaded zip into ORACLE_HOME directory.
To check the version of the opatch utility installed in the above step, navigate to the OPatch directory and run opatch version. You can remove the OPatch zip file after verifying the version.
It is required to increase the logical volume of /u01/app to 35 GB from current 25 GB as the zip file is huge and consumes significant space while applying patch. This can be performed using the following commands.
```
sudo lvresize  -L +10G /dev/mapper/vgroot-oracle
sudo resize2fs /dev/mapper/vgroot-oracle
```
This also ensure that there is sufficient space still left for normal DB operations.
Copy the downloaded zip file to /u01/app directory and unzip the file before patching.
Unzip and check conflicts before applying patch by using the following commands:
```
unzip p35564645_121020_Linux-x86-64.zipcd 35564645
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
```
Ensure that there are no conflicts before proceeding to next step. Also, remove the zip file from /u01/app to reclaim space.
Apply the patch
```
opatch apply
```
Note:
- Ensure that you have logged in to 35564645 directory before applying patch.
- You will be prompted with "Do you want to proceed? [y|n]" twice during the process. Type y when prompted on both the occassions.
Patch successfully applied. Composite patch 35564645 successfully applied. Log file location: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch<time-stamp>.log OPatch succeeded.
You can remove both zip and unzipped folder from /u01/app after the patch installation is successful.
Copy the downloaded p35926723_121020_Linux-x86-64.zip to /u01/app to /u01/app
Unzip p35926723_121020_Linux-x86-64.zip and check for conflicts by performing the following commands:
```
cd 35926723
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
```
Note:
Ensure there are no conflicts before proceeding to next step.
Apply the patch
```
opatch apply
```
Note:
- Ensure that you have logged in to 35926723 directory before applying patch.
- You will be prompted with "Do you want to proceed? [y|n]" twice during the process. Type y when prompted on both the occassions.
Patch 35926723 successfully applied. Sub-set patch [27923320] has become inactive due to the application of a super-set patch [35926723].
For more information, refer to Doc ID 2161861.1
Log file location: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch<time-stamp>.log OPatch succeeded.

opatch lspatches lists the following patches:

35926723;Database PSU 12.1.0.2.240116,Oracle JavaVM Component
    (JAN2024)
35564645;Database Patch Set Update : 12.1.0.2.231017 (35564645)

OPatch succeeded.

You can further verify the details using the following command:
```
opatch lsinventory
```
It is recommended to delete the zip and unzipped directories from /u01/app to reclaim space.

Note:
The latest available patch at the time of consolidating these steps was OCT DB PSU 2023 and JAN OJVM 2024. It is always advisable to pick any superseded patch at the time of applying this patch so that we always patch the system with the latest available patch for our database server.