Posts Categorized: Technical Blog

Installing 11gR2 Grid Infrastructure in 5 Easy Lessons

It started out innocently enough: Two node RAC cluster on two Linux RHEL5 with Netapp NFS used as shared filesystem for all shared files. My favorite OS and storage, so I felt confident that clusterware installation will be as smooth as it usually is. I told the customer that this can be done in 3 hours. What I didn’t take into account is that this was my first 11gR2 installation, and that much have changed since 11gR1. As things turned out, it took over 20 hours of my time and a lot of help from colleagues and even former colleagues before we had a successful installation. The time it takes you to read this blog post (and any other on this subject) is likely to be time well spent.

MetaCPAN FTW!

Right now, Galuga has a widget that lists my CPAN distributions. But it’s a boring old static affair that is updated manually. Surely in this age of the Web 2.0, I can do better than that. My first instinct that to go straight for my CPAN author page and extract the information off the HTML

11G R2 Cluster: AVOID using sqlplus & lsnrctl for Oracle

For last few months I was part of the Pythian’s team helping implement Oracle 11gR2 Clusters for different Oracle customers. All the implementations had different requirements and configurations, however, in all cases, the client’s DBAs made the same mistake over and over again. They used sqlplus and lsnrctl utilities to manage (start/stop) databases and listeners. This is totally wrong in the 11gR2 Cluster world. The following commands are just few examples on how you should start/stop Oracle processes

DBD Release 1.27 Release Candidate 1

Sorry, no funny nick name for version 1.27 but here is the scoop on it anyway. This version removes ‘PERL_POLLUTE’ and adds in PL_ so it will be fully compatible with Perl 5.13. So in a nutshell 1.27 is a single issue maintenance release.

Failure Scenarios for your Restore Practice

I always tell DBAs to practice their restore skills because this is one area that you are not allowed to get wrong. Having experience with different types of restores give you the confidence to do the right thing in an emergency. However, I noticed that when it comes to practicing, not all DBAs are equally imaginative on what to practice. Practicing the same failure over and over is not the best possible practice. Here are few scenarios you should be able to recover from

UKOUG Days 2 & 3

My presentations are finished and the feedback positive. I will be presenting one of sessions (Using AWR/ASH data) at RMOUG Training Days and Hotsos Symposium 2011 with minor modifications (I wonder…can I use the 11g analytical function LISTAGG with AWR/ASH data?). Anyway here are some highlights from the last day and a half…

Page 32 of 55« First...1020...3031323334...4050...Last »