Posts Categorized: Technical Blog
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
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.
Welcome to Log Buffer, the weekly news update of happenings in the database world.
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
Welcome to Log Buffer, the weekly round up of news and happenings in the database world.
In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I know I use them a lot when addressing questions regarding HADR.) These acronyms fall under the second P in my PPT for HADR – PROCESS.
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…
The highlight of Monday night was Doug Burns shaving ceremony and finalizing it at Tap & Spile. I have captured some videos but they need some post-processing before I can publish them. Another highlight was watching photos of previous UKOUG conferences I attended.
The Schwartz factor of a CPAN author is the ratio of the number of tarballs sitting in his CPAN directory over the number of distributions. A low number indicates that it’s probably time for this author to do some clean-up. I wanted to include a periodic check of my Schwartz factor to my monitoring system. Coming up with a script to extract the information from my CPAN home directory was simple enough.
Blogging from the Speaker Ready room which is now suited on the balcony overlooking the exhibition. I must say that I like the new location. Not only it is closer to the action, but allows you to oversee who is hanging out over the exhibitors. There’s been a number of interesting sessions, but it’s little things here and there that I learn that provide some real value. Here’s a few examples