Database 18c Patch

As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0.

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.13 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@18c ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
[oracle@18c ~]$ opatch version
OPatch Version: 12.2.0.1.13

OPatch succeeded.
[oracle@18c ~]$

Patch Information

Database Apr 2018 Release Update 18.2.0.0.180417 patches are cumulative. That is, the content of all previous Database bundles is included in the latest Database bundle patch.

To install the Database Apr 2018 Release Update 18.2.0.0.180417 patch, the Oracle home must have the 18.1 Database installed.

Checking the Production Version

[oracle@18c ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Tue Apr 24 18:01:50 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle. All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

SQL>

In the next step, we can apply a patch 27676517 on 18.1 Database.

[oracle@18c 27676517]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/18.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/18.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.4.0
Log file location : /u01/app/oracle/product/18.0.0/db_1/cfgtoollogs/opatch/opatch2018-04-24_18-07-00PM_1.log

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

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/db_1')

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

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

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

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

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

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

Patching component oracle.sqlplus, 18.0.0.0.0...

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

Patching component oracle.rdbms, 18.0.0.0.0...

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

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

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

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

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

Patching component oracle.rdbms.rman, 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...
Patch 27676517 successfully applied.
Log file location: /u01/app/oracle/product/18.0.0/db_1/cfgtoollogs/opatch/opatch2018-04-24_18-07-00PM_1.log

OPatch succeeded.
[oracle@18c 27676517]$

As we see now version changes to 18.2.0.0.0, but for the post-installation step, we have to start the database and open all PDBs (if applicable)

[oracle@18c 27676517]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Apr 24 18:12:28 2018
Version 18.2.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2432694552 bytes
Fixed Size 8898840 bytes
Variable Size 654311424 bytes
Database Buffers 1761607680 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
show pdbs

Pluggable database altered.

SQL>
CON_ID   CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2              PDB$SEED READ ONLY NO
3              PDB18CFLEET READ WRITE NO
SQL> exit

In the last step, we can run datapatch verbose

[oracle@18c 27676517]$ datapatch -verbose
SQL Patching tool version 18.0.0.0.0 Production on Tue Apr 24 18:17:52 2018
Copyright (c) 2012, 2018, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_14589_2018_04_24_18_17_52/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
No interim patches found

Current state of release update SQL patches:
Binary registry:
18.2.0.0.0 Release_Update 1804041635: Installed
PDB CDB$ROOT:
No release update patches installed
PDB PDB$SEED:
No release update patches installed
PDB PDB18CFLEET:
No release update patches installed

Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB18CFLEET
No interim patches need to be rolled back
Patch 27676517 (Database Release Update : 18.2.0.0.180417 (27676517)):
Apply from 18.1.0.0.0 Feature Release to 18.2.0.0.0 Release_Update 1804041635
No interim patches need to be applied

Installing patches...
Patch installation complete. Total patches installed: 3

Validating logfiles...done
Patch 27676517 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27676517/22097537/27676517_apply_NEWCDB_CDBROOT_2018Apr24_18_18_40.log (no errors)
Patch 27676517 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27676517/22097537/27676517_apply_NEWCDB_PDBSEED_2018Apr24_18_19_34.log (no errors)
Patch 27676517 apply (pdb PDB18CFLEET): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27676517/22097537/27676517_apply_NEWCDB_PDB18CFLEET_2018Apr24_18_19_35.log (no errors)
SQL Patching tool complete on Tue Apr 24 18:20:20 2018
[oracle@18c 27676517]$

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.