I am applying the Oracle CPU quarterly July Patches.( Oracle 11g rel 2 220.127.116.11)
I am having more than 30 databases on one server and I am the only dba here. I like to upgrade the home and half of the databases only. (Like 15 out of 30 on Sunday and the rest 15 databases after 3-4 days)
My question is I like to Patch the Oracle Home (using Opatch ) and I like to keep all the databases up and running.
Can I patch the home keeping all the databases up and running and then shutdown and start the individual oracle instance as per my own convenience like 15 now and the rest later?
The readme says stop the listener but it does not say to stop all the databases as well. I am planning to upgrade the home on Sunday and upgrade at least half of the databases at the same time and the rest half of the databases on Wednesday or Thursday ( After 3-4 days)
My question is that the non patched databases will give any error or it will keep running until I stop and start with the below command to upgrade the instances?
Earlier I used to stop everything (All the databases including listeners ) and apply it. This time I am thinking to apply this approach. Is this a right approach or I may not able to apply it without shutting down all the instances??
Apply Patch using Opatch
then catpatch individual databases
SQL> @catbundle.sql cpu apply