This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religious fervor in the air, particularly from the point of view of someone more accustomed to Oracle conferences. The companies generating buzz were the small companies built around development of their own open source products. There are a surprising number of them out there, especially relating to multiple forks of a popular product like MySQL or Hadoop.
One of the great joys of Perl and CPAN is how it allows you to stand on the shoulders of giants. By picking the right tools, applications that are not that trivial can be built in a matter of days, if not hours. The goal of today’s little project is to demonstrate that very thing. Grab a helmet and put your mouth-piece on, for this time I aim to do nothing other than blow your mind to awestruck smithereens.
Recently I have troubleshooted failing RMAN backups in a 18.104.22.168 RAC environment. The backups failed with the error message “ORA-00245: control file backup operation failed”. The solution for the issue is simple. Here it is!
On Friday 13 of June 2012, I was an on-call Oracle DBA. I got to work on a high priority client’s request. One of our client’s financial team was executing final steps of a year closing process in their ERP production environment and had a problem. The step that I received a complain about took 2 hours and still didn’t complete.
Some parts of the world are going through winter in swing while others are savoring summer (or suffering through it!). This variation in weather is beautifully in-sync with the variety of blog posts sprouting all over the web, especially regarding database technology. This mixed flavor of database blogs is captured once again by this Log Buffer Edition.
Since a third person just asked me how to prepare for OCM exam in last 2 days, I decided to make my answer publicly available. I will leave you to discover the formal path yourself and give you a guideline in terms of the how-to and length of the preparation.
This is not the first time I have run into this issue – in the past I (and who knows how many more Oracle DBAs) have had to deal with handling jobs from a different user, which usually ends in a big error. The answer to my prayers was the undocumented dbms_ijob package.
Database bloggers are blowing their trumpets at full throttle, warming up the hearts of readers across the globe with cool tips, nifty tricks, and glimmering gems. This Log Buffer Edition picks those gems and offers them to you.
After a little more than two weeks of soaking without any issues (yay!), version 1.45_00 of DBD::Oracle has been promoted to general use as v1.46.
And because some contributors have been very busy in the meantime, the next trial version, v1.47_00, is also already on its way to CPAN. This new version offers a few bug fixes (more details in the changelog excerpt below) as well as a rework of the platform-specific troubleshooting guides as POD documents. As usual, it’ll be left around for a minimum of two weeks before it gets promoted to v1.48. Happy upgrade!
Often, a hardware is updated at the same time as a database version. In such cases, we migrate a database from an original location to a new server upgrading the database version and sometimes changing operational system. If this is your situation, you can use the upgrade process to minimize the system’s downtime to 1 hour, independently from the size of the database you migrate.