{"id":814,"date":"2020-10-19T20:01:38","date_gmt":"2020-10-19T23:01:38","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=814"},"modified":"2020-10-20T02:29:02","modified_gmt":"2020-10-20T05:29:02","slug":"patching-ocw-for-oh","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/patching-ocw-for-oh\/","title":{"rendered":"Patching OCW for OH"},"content":{"rendered":"

If you search around about how to patch Oracle Database you will find a lot of blog posts teaching how to patch your Oracle Home (OH) (I will not put the list here because it will be enormous – but just follow Mike Dietrich<\/a>). But most of them write nothing about OCW, how to patch it, or if it is needed to patch OCW.  And unfortunately, even Oracle is not clear about that.<\/p>\n

Just to complement, recently Liron Amitzi got one issue<\/a> related to OCW. And if you search more, you will find that Frits Hoogland wrote something<\/a> about it too. But in the end, need I to concern about OCW<\/strong>? And, what is OCW<\/strong>?<\/p>\n

OCW<\/h2>\n

OCW means O<\/strong>racle C<\/strong>lusterw<\/strong>are, and basically is the core for the Grid Infrastructure, it is everything there. But for OH is important too because if the database needs to communicate with GI Clusterware it uses the OCW binaries\/libraries that are at OH (like srvctl, crstctl) to do that. So, if have some kind of bug at this portion of OCW, it needs to be patched.<\/p>\n

The point is that the only place that you can find the OCW patch is under the GI RU patch. Look at the readme for last GI RU 19.8.0.0.200714 (Patch 31305339<\/a>):<\/p>\n

\"\"<\/a><\/p>\n

And if you look at the readme for DB RU 19.8.0.0.200714 (Patch 31281355<\/a>) there is no reference to the OCW patch. So, if apply just the DB RU the OCW will not be updated.<\/p>\n

And just to remember you that patch 31305087 does not exist alone to be downloaded:<\/p>\n

\"\"<\/a><\/p>\n

<\/p>\n

Patching<\/h2>\n

Here in this example, I will use a vanilla 19.3 installation. And as you can see the OCW is there at OH:<\/p>\n

[oracle@orcloel7 ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\n[oracle@orcloel7 ~]$ export PATH=$ORACLE_HOME\/OPatch:$ORACLE_HOME\/bin:$PATH\r\n[oracle@orcloel7 ~]$\r\n[oracle@orcloel7 ~]$ which opatch\r\n\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/OPatch\/opatch\r\n[oracle@orcloel7 ~]$\r\n[oracle@orcloel7 ~]$ opatch lspatches\r\n29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)\r\n29517242;Database Release Update : 19.3.0.0.190416 (29517242)\r\n\r\nOPatch succeeded.\r\n[oracle@orcloel7 ~]$<\/pre>\n
Now, over this home I will install the DB RU 19.8.0.0.200714 (Patch 31281355<\/a>), and OJVM as well:<\/p>\n
[oracle@orcloel7 ~]$ cd \/tmp\/install\/database\/31281355\/\r\n[oracle@orcloel7 31281355]$\r\n[oracle@orcloel7 31281355]$ opatch apply\r\nOracle Interim Patch Installer version 12.2.0.1.21\r\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\r\n\r\n\r\nOracle Home       : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n   from           : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/oraInst.loc\r\nOPatch version    : 12.2.0.1.21\r\nOUI version       : 12.2.0.7.0\r\nLog file location : \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2020-10-03_19-01-34PM_1.log\r\n\r\nVerifying environment and performing prerequisite checks...\r\nOPatch continues with these patches:   31281355\r\n\r\nDo you want to proceed? [y|n]\r\ny\r\nUser Responded with: Y\r\nAll checks passed.\r\n\r\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\r\n(Oracle Home = '\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1')\r\n\r\n\r\nIs the local system ready for patching? [y|n]\r\ny\r\nUser Responded with: Y\r\nBacking up files...\r\nApplying interim patch '31281355' to OH '\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1'\r\nApplySession: 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.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.\r\n\r\nPatching component oracle.rdbms, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.util, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.assistants.acf, 19.0.0.0.0...\r\n\r\nPatching component oracle.assistants.deconfig, 19.0.0.0.0...\r\n\r\nPatching component oracle.assistants.server, 19.0.0.0.0...\r\n\r\nPatching component oracle.buildtools.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.ctx, 19.0.0.0.0...\r\n\r\nPatching component oracle.dbjava.ic, 19.0.0.0.0...\r\n\r\nPatching component oracle.ldap.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.network.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.dbscripts, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.deconfig, 19.0.0.0.0...\r\n\r\nPatching component oracle.sdo, 19.0.0.0.0...\r\n\r\nPatching component oracle.sdo.locator.jrf, 19.0.0.0.0...\r\n\r\nPatching component oracle.sqlplus, 19.0.0.0.0...\r\n\r\nPatching component oracle.xdk, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.crs, 19.0.0.0.0...\r\n\r\nPatching component oracle.install.deinstalltool, 19.0.0.0.0...\r\n\r\nPatching component oracle.dbjava.ucp, 19.0.0.0.0...\r\n\r\nPatching component oracle.oraolap.dbscripts, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.lbac, 19.0.0.0.0...\r\n\r\nPatching component oracle.dbdev, 19.0.0.0.0...\r\n\r\nPatching component oracle.marvel, 19.0.0.0.0...\r\n\r\nPatching component oracle.network.listener, 19.0.0.0.0...\r\n\r\nPatching component oracle.precomp.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.javavm.client, 19.0.0.0.0...\r\n\r\nPatching component oracle.precomp.common.core, 19.0.0.0.0...\r\n\r\nPatching component oracle.ldap.rsf.ic, 19.0.0.0.0...\r\n\r\nPatching component oracle.network.client, 19.0.0.0.0...\r\n\r\nPatching component oracle.ctx.atg, 19.0.0.0.0...\r\n\r\nPatching component oracle.ctx.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.drdaas, 19.0.0.0.0...\r\n\r\nPatching component oracle.duma, 19.0.0.0.0...\r\n\r\nPatching component oracle.javavm.server, 19.0.0.0.0...\r\n\r\nPatching component oracle.odbc, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.oci, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.rman, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.dv, 19.0.0.0.0...\r\n\r\nPatching component oracle.bali.ice, 11.1.1.7.0...\r\n\r\nPatching component oracle.ovm, 19.0.0.0.0...\r\n\r\nPatching component oracle.dbjava.jdbc, 19.0.0.0.0...\r\n\r\nPatching component oracle.oracore.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.scheduler, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.install.common, 19.0.0.0.0...\r\n\r\nPatching component oracle.ldap.owm, 19.0.0.0.0...\r\n\r\nPatching component oracle.ldap.security.osdt, 19.0.0.0.0...\r\n\r\nPatching component oracle.ons, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.install.plugins, 19.0.0.0.0...\r\n\r\nPatching component oracle.sdo.locator, 19.0.0.0.0...\r\n\r\nPatching component oracle.nlsrtl.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.xdk.rsf, 19.0.0.0.0...\r\n\r\nPatching component oracle.sqlplus.ic, 19.0.0.0.0...\r\n\r\nPatching component oracle.oraolap, 19.0.0.0.0...\r\n\r\nPatching component oracle.xdk.parser.java, 19.0.0.0.0...\r\n\r\nPatching component oracle.rdbms.rsf.ic, 19.0.0.0.0...\r\n\r\nPatching component oracle.precomp.common, 19.0.0.0.0...\r\n\r\nPatching component oracle.precomp.lang, 19.0.0.0.0...\r\n\r\nPatching component oracle.jdk, 1.8.0.201.0...\r\nPatch 31281355 successfully applied.\r\nSub-set patch [29517242] has become inactive due to the application of a super-set patch [31281355].\r\nPlease refer to Doc ID 2161861.1 for any possible further required actions.\r\nLog file location: \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/opatch\/opatch2020-10-03_19-01-34PM_1.log\r\n\r\nOPatch succeeded.\r\n[oracle@orcloel7 31281355]$\r\n[oracle@orcloel7 31281355]$\r\n[oracle@orcloel7 31281355]$\r\n[oracle@orcloel7 31281355]$ \r\n<\/pre>\n
And I will have at the end:<\/p>\n
[oracle@orcloel7 ~]$ opatch lspatches\r\n31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)\r\n31281355;Database Release Update : 19.8.0.0.200714 (31281355)\r\n29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)\r\n\r\nOPatch succeeded.\r\n[oracle@orcloel7 ~]$<\/pre>\n
As you can see above, now I have:<\/p>\n