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

Aug 10

OTN LA – Guob Tech Day 2015

This year we had another edition of the incredible event GUOB Tech Day, which took place in São Paulo on August 8. The event featured more than 10 speakers adding new ideas and knowledge to the entire audience. I had the honor to speak personally with some of them. They include: Alex Zaballa. Oracle Ace …

Continue reading

Aug 10

OCM 11g Preparation – Convert the standby to a snapshot standby

Standby databases can become snapshot standbys with a single command line over DG Broker. This is one of the most amazing things in Data Guard and very useful to test your scripts before running them on production! What I recommend in this chapter is: Convert a physical standby to snapshot standby (and vice-versa) using Broker. …

Continue reading