In this post, we are going to apply bug fix patch for testing in Oracle 18c Database. First of all, we can download latest opatch utility from support.

  • Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version.

Check the version from new OPatch utility.

Now we are going to set proper home and check the lsinventory

Conflict Detection and Resolution

The easiest and quickest way to determine if you have a patch already applied that will conflict with another patch that will still be applied is through the One-off Patch ConflictDetectionandResolution method.

If no conflict is found you can apply the patch, otherwise you need to resolve the conflicts.

Applying the Patch in the Database Home

The OPatch utility automates the patch application for Oracle Grid Infrastructure Home and Oracle RAC Database Home. It operates by consulting the existing configuration and automating the steps required to patch both DB Home and GI Home.

Note: This is just a bug fix patch.

After applying the patch to the DB Home you can consult the list of patches applied using OPatch “lsinvetory”.

Removing the Database Home Patch

The patch rollback instructions will be different for GI and DB Home. The steps required for rollback in DB Home are listed below.

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’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.