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

Aug 07

OCM 11g Preparation – Configure connect time failover

This topic is pretty easy. You have all the default properties that you can list using the broker: FastStartFailoverThreshold = ’30’ OperationTimeout = ’30’ FastStartFailoverLagLimit = ’30’ CommunicationTimeout = ‘180’ FastStartFailoverAutoReinstate = ‘TRUE’ FastStartFailoverPmyShutdown = ‘TRUE’ BystandersFollowRoleChange = ‘ALL’ To change any of them, all you need is to run: “EDIT DATABASE <database name> SET PROPERTY <property …

Continue reading