Dec 08

How to apply PSU in multiple Oracle Databases simultaneously using the Enterprise Manager 12c

In this tutorial, I will show how to apply PSU in multiple Oracle Databases simultaneously using the Enterprise Manager 12c. This is a very useful feature available specially when you have tens or hundreds of databases in your EM and you want to patch them all without the need to do it one by one. …

Continue reading

Nov 25

EM Patch apply failing with: Prereq “checkActiveFilesAndExecutables” is not executed

Those days, when trying to apply Database Patches using the Oracle Enterprise Manager 12c, I was getting an error: Prereq “checkActiveFilesAndExecutables” is not executed. Invoking prereq “checkactivefilesandexecutables” Prereq “checkActiveFilesAndExecutables” is not executed. The details are: No patch location specified. OPatch failed with error code 2 ERROR: Failed to invoke ‘opatch prereq checkActiveFilesAndExecutables’ ERROR: Some processes …

Continue reading

Oct 07

OCM 12c Upgrade is finally out!

After a long waiting time, Oracle finally released and published in his main page more information about Oracle 12c OCM exam! When you click in “View Exam Details and Register”, you are redirected to this page. Here you see some differences from the prior OCM exam versions. The main one is that now they require a …

Continue reading

Aug 14

OPatch auto is not patching Database Home

Sometimes I face a situation where the following command finishes successfully, however, RAC database ORACLE_HOME is not patched: # opatch auto -ocmrf There are 2 situations where this happens: 1. The GI home and RAC database home are under different Patch Sets (until 4th digit) i.e. : GI is 11.2.0.4 and RAC is 11.2.0.3 GI …

Continue reading

Aug 13

opatch auto failing “Can’t locate Switch.pm in @INC”

Those days, when trying to run “opatch auto” on a Enterprise Linux 7 server to automatically patch my GI Home and all the Database Homes, I faced the following error: [root@localhost 20834621]# opatch auto ./20485808 -ocmrf /tmp/ocm.rsp Can’t locate Switch.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /u01/app/11.2.4/grid/OPatch/crs/auto_patch.pl line 2730. BEGIN …

Continue reading