I’ve been managing Oracle databases since about Version 6, so I have seen a lot of trends over the years, and watched as the Oracle database morphed from Oracle 7.1, the integration with Digital Rdb, the short-lived 8.0 release, 8.1, 9i, 10g, 11g and sometime soon 12c.
The database software is immensely complex and deep, and the never ending list of new features mean there is always something to learn. Some amazing people have worked on the development of the software over the years, and still more have experimented, analyzed, written about and evangelized about it.
I’ve watched as Oracle struggled to add replication through Symmetric Replication, Advanced Replication, Streams, Logical Standby and finally they threw in the towel and bought Golden Gate. Not everything out of Redwood Shores has been production ready.
Having spent nearly 20 years as a production DBA, I was the one up at 2am fixing corruption, recovering databases and explaining to management why the website was down. I been around the block enough to separate hype from fact, and to never run version x.1 of anything! Having two kids and a busy home life, I also don’t have all day and all night to download Linux RPMs and patches from MOS, I expect stuff to basically work first time.
I also don’t have all day and all night to blog about every little widget I have installed on my home Sparc Super Cluster, if you are looking for such material then you will need to look elsewhere. What you will find here is, I hope, a useful collection of tips, scripts and notes on making Oracle work in a production ready state. Quirky, irreverent and often blunt, I am more interested in making it work well than having every one of Larry’s bells and whistles.
Production DBAs will know what I mean.
The Gruff DBA (aka Oracle Jedi)
Since Sept 2011, I have worked for EMC evangelizing among the DBA community the advantages of EMC products such as the VNX and the Symmetrix VMAX. As trite as it may sound, after almost 20 years as a production DBA, I found storage was often critical to reliable operation and performance. And in almost 20 years, Clariion and Symmetrix arrays rarely if ever let me down.
It should go without saying that the views and opinions expressed here are mine, and do not necessarily reflect those of EMC, but we live in an age apparently we have to clearly state the blindingly obvious.
I am not here to disparage the efforts of other storage vendors, including Oracle, but I thought readers should know my position here.