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.

Patch Information

Grid Infrastructure 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 Grid Infrastructure Apr 2018 Release Update 18.2.0.0.180417 patch, the Grid home must have the 18.1 Database installed.

Checking the Production Version

Run OPatch Conflict Check for Grid Infrastructure Home:
Syntax

Example

Run OPatch SystemSpace Check
Syntax

Example

One-off Patch Conflict Detection and Resolution

To patch only the GI home:
Syntax

Example

As I am running RAC on one node, So Grid patching cannot be performed in rolling mode.

Now, I will perform non-rolling mode to apply the patch.

Step 1: Stop CRS

Step 2: Unlock the Grid Home

Step 3: Apply all patches

Step 4: Lock back the Grid Home

Steps 5: List all patches applied.

Let’s connect to Sqlplus, as we see now version changes to 18.2.0.0.0

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