August 2015 archive

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

Aug 10

OCM 11g Preparation - Configure archivelog deletion policy for the Dataguard configuration

When you are in a DG environment, you need to decide what to do with your archivelog and define a retention policy for them. You can do it using the "CONFIGURE ARCHIVELOG DELETION POLICY" option of RMAN. You can define it to either: BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier; TO APPLIED ON [ALL] …

Continue reading