Patching Database Cloud Service

There is nothing simple more than this , Applying patch on the cloud (Dbaas), Oracle Cloud allow you to check the following :-

  • Viewing Available Patches
  • Check Prerequisites.
  • Apply Patch.
  • Rollback Patch.
In this post it will show you how to do all the above steps :-
  • Open the Oracle Database Cloud Service console.
  • Click the database deployment on which you want to check patching.
  • Click the Administration tile and then click the Patching tab.
  • If you want to use command line it’s possible as well, you have to connect to the cloud using Putty on windows check the post from here that will tell you how to connect using putty to the cloud, however if the below you will see that the available patch in the picture for my Dbaas, you can check the prerequisites again by press on it. 

If you want to run the same without GUI ( Cloud Console ) you can do the following 

Remember you should configure Putty to be able to access the root on the cloud.
  • Now If you want to apply the patch on the cloud Using the console it’s very easy. 
Enjoy the Cloud 
Thank you 
Osama

Describe Oracle Patches

Regarding to Oracle Documentation patch is program (set of instructions) to fix a particular problem or enhance/ add a particular feature in existing program/product/software. And There’s Four kind of Oracle Patches :

  • One-off patches (bug fix)
  • CPU (security patches)
  • Upgrade patches (bug fixes)
  • PSU (bug fixes are security patches)

There’s another kind called Bundle Patched for windows and exadata.
The most two kind of patch that people get little confused about them is CPU and PSU what are they ? when should i use them ?  is there any different between them ?

First Thing you need to know about them since they have different name then sure it’s have different.

CPU:  security fixes each quarter rather than the cumulative database.

PSU : same as CPU  patches but include both the security fixes and priority fixes.Note Once a PSU is applied, only PSUs can be applied in future quarters until the database is upgraded to a new base version.
Which mean you can’t Apply CPU and PSU and same database.

Some MOS note that could be Useful :

Introduction to Oracle Patch Set Updates (PSU) 854428.1
Quick Reference to Patchset Patch Numbers [ID 753736.1]
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets [ID 1454618.1]
New Patch Nomenclature for Oracle Products [ID 1430923.1]

PSU  contain fix for bugs that cause Instance crash,Wrong results and Data Corruption on the other hand Dictionary changes , Major Algorithm changes ,and Optimizer plan changes not fixed by PSU.

to check Applied PSU patched you need to run :

opatch lsinventory -bugs_fixed | grep -i ‘DATABASE PSU’

 and if you need to check CPU :

 Select * from registry$history;

Thank you
Osama mustafa