Oracle Patch Installation (Optional)
To install the Oracle patch:
Before you begin
Note |
This is an illustration of the Oracle 19c patch installation (from 19.3.0.0.0 to 19.18.0.0.0). |
-
Check the current Oracle version.
[root@iot-fnd-oracle ~]# su - oracle
[oracle@iot-fnd-oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 29 20:59:44 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> exit;
-
Stop the FND application (if running).
service cgms stop
-
Log into Oracle.
su - oracle
-
Stop the Oracle service (if running).
cd /opt/cgms-oracle/scripts ./stopOracle.sh
-
Apply the patch file: p34765931_190000_Linux-x86-64.zip.
Procedure
Step 1 |
Create a patches directory under the /home/oracle folder to place the patch zip files.
|
Step 2 |
Download the database patch zip file (p34765931_190000_Linux-x86-64.zip) from Oracle Database 19c Release Update & Release Update Revision January 2023 Known Issues. |
Step 3 |
Copy the patch zip files to the /home/oracle/patches folder. |
Step 4 |
Unzip the patch files (p34765931_190000_Linux-x86-64.zip) in the /home/oracle/patches folder.
|
Step 5 |
Go to the patch directory
The minimum OPatch version required is 12.2.0.1.34. The patch installation FAILS if the OPatch version is below 12.2.0.1.34. For more information on applying the minimum OPatch version, see Upgrading OPatch. |
Step 6 |
Run the following command to apply the patch.
|
Step 7 |
Check if the upgraded patch version is 19.18.0 in the interim patches.
|
Step 8 |
Confirm the upgraded patch.
|
What to do next
su - oracle
cd /opt/cgms-oracle/scripts
./startOracle.sh
Upgrading OPatch
[oracle@iot-fnd-oracle 34765931]$
/home/oracle/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/19.0.0/dbhome_1
Central Inventory : /home/oracle/app/oraInventory
from : /home/oracle/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location :
/home/oracle/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-02-10_07-16-05AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckMinimumOPatchVersion" failed.
The details are:
The OPatch being used has version 12.2.0.1.17 while the following patch(es) require higher versions:
Patch 34765931 requires OPatch version 12.2.0.1.34.
Please download latest OPatch from My Oracle Support.
UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.
Log file location:
/home/oracle/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-02-10_07-16-05AM_1.log
OPatch failed with error code 73
The steps are an illustration for requesting the minimum OPatch version 12.2.0.1.34 to apply the 19.18 patch on an old OPatch version 12.2.0.1.17.
Procedure
Step 1 |
To upgrade the OPatch version, download the 12.2.0.1.36 OPatch version from the Oracle support Patch 6880880 (oracle.com) . |
Step 2 |
Place the zip file in the $ORACLE_HOME directory and follow the steps that are given below. The OPatch file is: p6880880_190000_Linux-x86-64.zip |