This articles explains the steps to upgrade the Oracle Database Home 19c just software only from 19.3 to 19.18 within Oracle Linux 8.2
Database Release Update 19.18 : patch 34765931
Download this patch from https://support.oracle.com/portal/
Steps:
- Step 1: Upgrade the Opatch utility
- Step 2: Check the conflict of the latest patch
- Step 3: Apply the patch
Step 1: Upgrade OPatch Utility
Before applying patch, make sur that Opatch utlity 6880880must be at least the version 12.2.0.1.34 or later to apply this patch, download it from MOS:
Link: http://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6880880
Backup old Opatch directory and unzip the new Opatch
$ mv u01/app/oracle/product/19c/dbhome_1/OPatch/ u01/app/oracle/product/19c/dbhome_1/OPatch_BKP
$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19c/dbhome_1
$ u01/app/oracle/product/19c/dbhome_1/OPatch/opatch version
OPatch Version: 12.2.0.1.36
OPatch succeeded.
Step 2: Check the conflict of this patch:
$ unzip p34765931_19.18_190000_Linux-x86-64.zip -d /home/oracle/34765931/
$ /u01/app/oracle/product/19c/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34765931/
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /opt/oracle/product/23c/dbhomeFree
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/23c/dbhomeFree/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.9.0
Log file location : /opt/oracle/product/23c/dbhomeFree/cfgtoollogs/opatch/opatch2023-04-11_02-17-00AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Note: The verification of conflict of is succeed.
Step 3: Apply the patch 34765931
$ cd /home/oracle/34765931/
$ /u01/app/oracle/product/19c/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19c/dbhome_1
Central Inventory : /opt/oracle/oraInventory
from : /u01/app/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2023-04-11_02-18-19AM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34765931
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19c/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch '34765931' to OH '/u01/app/oracle/product/19c/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.slax.rsf, 19.0.0.0.0…
Patching component oracle.ordim.jai, 19.0.0.0.0…
Patching component oracle.bali.jewt, 11.1.1.6.0…
Patching component oracle.bali.ewt, 11.1.1.6.0…
Patching component oracle.help.ohj, 11.1.1.7.0…
Patching component oracle.rdbms.locator, 19.0.0.0.0…
Patching component oracle.perlint.expat, 2.0.1.0.4…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.rdbms.rsf, 19.0.0.0.0…
Patching component oracle.assistants.acf, 19.0.0.0.0…
Patching component oracle.assistants.deconfig, 19.0.0.0.0…
Patching component oracle.assistants.server, 19.0.0.0.0…
Patching component oracle.blaslapack, 19.0.0.0.0…
Patching component oracle.buildtools.rsf, 19.0.0.0.0…
Patching component oracle.ctx, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.javavm.client, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.ldap.rsf, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.marvel, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.odbc.ic, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.ons.ic, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.perlint, 5.28.1.0.0…
Patching component oracle.precomp.common.core, 19.0.0.0.0…
Patching component oracle.precomp.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.crs, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.sdo, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.wwg.plsql, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.rdbms.lbac, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.hs_common, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.drdaas, 19.0.0.0.0…
Patching component oracle.oraolap, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.javavm.server, 19.0.0.0.0…
Patching component oracle.ldap.ssl, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.rdbms.hsodbc, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.mgw.common, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.xdk.xquery, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.oraolap.api, 19.0.0.0.0…
Patching component oracle.rdbms.scheduler, 19.0.0.0.0…
Patching component oracle.rdbms.install.common, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.ldap.client, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.dbtoolslistener, 19.0.0.0.0…
Patching component oracle.precomp.lang, 19.0.0.0.0…
Patching component oracle.precomp.common, 19.0.0.0.0…
Patching component oracle.jdk, 1.8.0.201.0…
Patch 34765931 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [34765931].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2023-04-11_02-18-19AM_1.log
OPatch succeeded
Enjoy the 19.18 patch on Software only installation.
Google+
Facebook
