Upgrade Oracle Home 19c Software (19.3 to 19.12)

By | | , ,

This articles explains the steps to upgrade the Oracle Database Home 19c just software only from 19.3 to 19.12 within Oracle Linux 8.4

Database Release Update 19.12.0.0.210720 Patch 32904851

Last Update, September 10, 2021

There are some prerequisites:

“You must use the OPatch utility version 12.2.0.1.25 or later to apply this patch.” from READ ME of the Patch 32904851

Step 1: Upgrade the Opatch:

OPatch 12.2.0.1.27 for DB 19.0.0.0.0

Step 2: Check the Database release update:

$ /u01/app/oracle/product/19.1.0/dbhome_1/OPatch/opatch lspatches
 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
 29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

Step 3: Download the patch 32904851 from MOS.


Step 4: unzip the patch file

$ unzip p32904851_190000_Linux-x86-64.zip

Step 5: Apply the patch 32904851

$ /u01/app/oracle/product/19.1.0/dbhome_1/OPatch/opatch apply
 Oracle Interim Patch Installer version 12.2.0.1.27
 Copyright (c) 2021, Oracle Corporation.  All rights reserved.
 Oracle Home       : /u01/app/oracle/product/19.1.0/dbhome_1
 Central Inventory : /u01/app/oraInventory
    from           : /u01/app/oracle/product/19.1.0/dbhome_1/oraInst.loc
 OPatch version    : 12.2.0.1.27
 OUI version       : 12.2.0.7.0
 Log file location : /u01/app/oracle/product/19.1.0/dbhome_1/cfgtoollogs/opatch/opatch2021-09-15_11-33-39AM_1.log
 Verifying environment and performing prerequisite checks…
 OPatch continues with these patches:   32904851  
 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/19.1.0/dbhome_1')
 Is the local system ready for patching? [y|n]
 y
 User Responded with: Y
 Backing up files…
 Applying interim patch '32904851' to OH '/u01/app/oracle/product/19.1.0/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.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 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.perlint, 5.28.1.0.0…
 Patching component oracle.rdbms.locator, 19.0.0.0.0…
 Patching component oracle.rdbms.rsf, 19.0.0.0.0…
 Patching component oracle.rdbms.util, 19.0.0.0.0…
 Patching component oracle.rdbms, 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.buildtools.rsf, 19.0.0.0.0…
 Patching component oracle.ctx, 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.marvel, 19.0.0.0.0…
 Patching component oracle.network.rsf, 19.0.0.0.0…
 Patching component oracle.oracore.rsf, 19.0.0.0.0…
 Patching component oracle.precomp.common.core, 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.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.odbc, 19.0.0.0.0…
 Patching component oracle.rdbms.drdaas, 19.0.0.0.0…
 Patching component oracle.xdk.parser.java, 19.0.0.0.0…
 Patching component oracle.dbtoolslistener, 19.0.0.0.0…
 Patching component oracle.ctx.atg, 19.0.0.0.0…
 Patching component oracle.javavm.server, 19.0.0.0.0…
 Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
 Patching component oracle.rdbms.hs_common, 19.0.0.0.0…
 Patching component oracle.ons, 19.0.0.0.0…
 Patching component oracle.precomp.rsf, 19.0.0.0.0…
 Patching component oracle.oraolap.api, 19.0.0.0.0…
 Patching component oracle.ons.ic, 19.0.0.0.0…
 Patching component oracle.rdbms.install.common, 19.0.0.0.0…
 Patching component oracle.xdk, 19.0.0.0.0…
 Patching component oracle.rdbms.dv, 19.0.0.0.0…
 Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
 Patching component oracle.rdbms.scheduler, 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.rman, 19.0.0.0.0…
 Patching component oracle.oraolap, 19.0.0.0.0…
 Patching component oracle.rdbms.crs, 19.0.0.0.0…
 Patching component oracle.dbdev, 19.0.0.0.0…
 Patching component oracle.rdbms.hsodbc, 19.0.0.0.0…
 Patching component oracle.network.client, 19.0.0.0.0…
 Patching component oracle.xdk.xquery, 19.0.0.0.0…
 Patching component oracle.ldap.client, 19.0.0.0.0…
 Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
 Patching component oracle.ctx.rsf, 19.0.0.0.0…
 Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
 Patching component oracle.xdk.rsf, 19.0.0.0.0…
 Patching component oracle.network.listener, 19.0.0.0.0…
 Patching component oracle.ovm, 19.0.0.0.0…
 Patching component oracle.sdo.locator, 19.0.0.0.0…
 Patching component oracle.mgw.common, 19.0.0.0.0…
 Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
 Patching component oracle.precomp.common, 19.0.0.0.0…
 Patching component oracle.precomp.lang, 19.0.0.0.0…
 Patching component oracle.jdk, 1.8.0.201.0…
 Patch 32904851 successfully applied.
 Sub-set patch [29517242] has become inactive due to the application of a super-set patch [32904851].
 Please refer to Doc ID 2161861.1 for any possible further required actions.
 Log file location: /u01/app/oracle/product/19.1.0/dbhome_1/cfgtoollogs/opatch/opatch2021-09-15_11-33-39AM_1.log
 OPatch succeeded.

Step 6: Check the database release update:

$ /u01/app/oracle/product/19.1.0/dbhome_1/OPatch/opatch lspatches
 32904851;Database Release Update : 19.12.0.0.210720 (32904851)
 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

Enjoy !!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply