In this article we will apply the latest PSU applied to Database Home. 

Latest Patch : Database Jan 2020 Release Update : 12.2.0.1.200114 (30593149)

We need to initially download the desired PSU and My Oracle Support compatible OPatch utility (support.oracle.com).

  • Doc ID 2118136.2 -> Quick References to Patch Numbers for Database / GI PSU, SPU (CPU), Bundle Patches and Patchsets.
  • Doc ID 274526.1 -> How To Download And Install The Latest OPatch (6880880) Version.

The next step is to install OPatch in Database Home:

  • Find the Database Home.
  • Back up the old OPatch utility
  • Unzip the new OPatch in Oracle Home

Check the OPatch version. We upgrade the opatch utility as per README file in patch.

Now, shutdown the database.

Then stop the listener before patching.

Go to the directory where the patch has downloaded and unzip it.

Now, set the environmental varible and run the precheck for conflicts. If there is any conflicts, then contact Oracle Support for validation or merge patch if needed.

Finally, you can apply the patch.

Note: -silent is used to suppresses any user-interaction

You can cross check the patch with opatch utility.

Now, start the database & listener.

Run the datapatch to make the entry in database registry. 

If you are getting the error related to extjob0 and opatch has warning.

Then you need to rollback the patch and re-apply the patch. It will resolve your error.

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/

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.