Database 18c Patch

As of the Release date (16-Jan-2019), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Then afterwards, it was available for on-premise as well.

More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1)

OPatch Utility Information

You must use the OPatch utility version 12.2.0.1.14 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 by selecting the 12.2.0.1.0 release.

[oracle@oracle19c sw]$ export ORACLE_HOME=/u01/app/oracle/product/18.0.0/dbhome_1
[oracle@oracle19c sw]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@oracle19c sw]$
[oracle@oracle19c sw]$ sqlplus -v

SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

version
OPatch Version: 12.2.0.1.14

OPatch succeeded.
[oracle@oracle19c sw]$

Patch Information

R18 Database Release Update Jan 2019 18.5.0.0.150119 patches are cumulative. That is, the content of all previous Database bundles is included in the latest Database bundle patch.

To install the Database Release Update Jan 2019 18.5.0.0.150119 patch, the Grid home must have the 18.1 Database installed.

Checking the Production Version

[oracle@oracle19c sw]$ export ORACLE_HOME=/u01/app/oracle/product/18.0.0/dbhome_1
[oracle@oracle19c sw]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@oracle19c sw]$
[oracle@oracle19c sw]$ sqlplus -v

SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

version
OPatch Version: 12.2.0.1.14

OPatch succeeded.
[oracle@oracle19c sw]$

Run OPatch Conflict Check for Database Home

[oracle@oracle19c 28822489]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/18.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/18.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /u01/app/oracle/product/18.0.0/dbhome_1/cfgtoollogs/opatch/opatch2019-02-28_01-20-31AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@oracle19c 28822489]$

To Report the patch

[oracle@oracle19c 28822489]$ opatch apply -report
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/18.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/18.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /u01/app/oracle/product/18.0.0/dbhome_1/cfgtoollogs/opatch/opatch2019-02-28_01-21-17AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   28822489

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/18.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28822489' to OH '/u01/app/oracle/product/18.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.
Users request no RAC file generation.  Do not create MP files.

Skip patching component oracle.oracore.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.jdbc, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.ic, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.




Skip patching component oracle.network.listener, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.acf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.rsf.ic, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.server, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ons, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.deconfig, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.util, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo.locator.jrf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk.parser.java, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.server, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.crs, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.rman, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx.atg, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.ucp, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.install.deinstalltool, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.dbscripts, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.network.client, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.install.plugins, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.oci, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.oraolap.dbscripts, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.deconfig, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.nlsrtl.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.network.rsf, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sqlplus.ic, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo.locator, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.nlsrtl.rsf.core, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sqlplus, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.javavm.client, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.owm, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.security.osdt, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.install.common, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.lang, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.common, 18.0.0.0.0 and its actions.
The actions are reported here, but are not performed.

ApplySession skipping inventory update.
Patch 28822489 successfully applied.
Log file location: /u01/app/oracle/product/18.0.0/dbhome_1/cfgtoollogs/opatch/opatch2019-02-28_01-21-17AM_1.log

OPatch succeeded.
[oracle@oracle19c 28822489]$

Now apply the patch only the Database home

[oracle@oracle19c 28822489]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/18.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/18.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /u01/app/oracle/product/18.0.0/dbhome_1/cfgtoollogs/opatch/opatch2019-02-28_01-25-11AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   28822489

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/18.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28822489' to OH '/u01/app/oracle/product/18.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.oracore.rsf, 18.0.0.0.0...

Patching component oracle.rdbms, 18.0.0.0.0...

Patching component oracle.dbjava.jdbc, 18.0.0.0.0...

Patching component oracle.dbjava.ic, 18.0.0.0.0...

Patching component oracle.network.listener, 18.0.0.0.0...

Patching component oracle.assistants.acf, 18.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 18.0.0.0.0...

Patching component oracle.server, 18.0.0.0.0...

Patching component oracle.ctx, 18.0.0.0.0...

Patching component oracle.ons, 18.0.0.0.0...

Patching component oracle.rdbms.deconfig, 18.0.0.0.0...

Patching component oracle.rdbms.util, 18.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 18.0.0.0.0...

Patching component oracle.xdk.parser.java, 18.0.0.0.0...

Patching component oracle.assistants.server, 18.0.0.0.0...

Patching component oracle.rdbms.crs, 18.0.0.0.0...

Patching component oracle.rdbms.rman, 18.0.0.0.0...

Patching component oracle.xdk, 18.0.0.0.0...

Patching component oracle.ctx.atg, 18.0.0.0.0...

Patching component oracle.dbjava.ucp, 18.0.0.0.0...

Patching component oracle.install.deinstalltool, 18.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 18.0.0.0.0...

Patching component oracle.rdbms.rsf, 18.0.0.0.0...

Patching component oracle.xdk.rsf, 18.0.0.0.0...

Patching component oracle.network.client, 18.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 18.0.0.0.0...

Patching component oracle.sdo, 18.0.0.0.0...

Patching component oracle.rdbms.oci, 18.0.0.0.0...

Patching component oracle.ctx.rsf, 18.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 18.0.0.0.0...

Patching component oracle.assistants.deconfig, 18.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 18.0.0.0.0...

Patching component oracle.precomp.rsf, 18.0.0.0.0...

Patching component oracle.network.rsf, 18.0.0.0.0...

Patching component oracle.sqlplus.ic, 18.0.0.0.0...

Patching component oracle.sdo.locator, 18.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 18.0.0.0.0...

Patching component oracle.sqlplus, 18.0.0.0.0...

Patching component oracle.javavm.client, 18.0.0.0.0...

Patching component oracle.ldap.owm, 18.0.0.0.0...

Patching component oracle.ldap.security.osdt, 18.0.0.0.0...

Patching component oracle.rdbms.install.common, 18.0.0.0.0...

Patching component oracle.precomp.lang, 18.0.0.0.0...

Patching component oracle.precomp.common, 18.0.0.0.0...
Patch 28822489 successfully applied.
Sub-set patch [28090523] has become inactive due to the application of a super-set patch [28822489].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/18.0.0/dbhome_1/cfgtoollogs/opatch/opatch2019-02-28_01-25-11AM_1.log

OPatch succeeded.
[oracle@oracle19c 28822489]$

List all patches applied and Let’s connect to Sqlplus, as we see now version check the 18.5.0.0.0

[oracle@oracle19c 28822489]$ opatch lspatches
28822489;Database Release Update : 18.5.0.0.190115 (28822489)
27908644;UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171
27923415;OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)
28090553;OCW RELEASE UPDATE 18.3.0.0.0 (28090553)

OPatch succeeded.
[oracle@oracle19c 28822489]$ sqlplus -v

SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.5.0.0.0

[oracle@oracle19c 28822489]$

So, as we see it’s very simple approach to upgrading the version by applying the patch.

Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.