DBA Lounge

Not so good news for MCM Aspirants

A few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM aspirants. This announcement has upset many in the SQL Community including myself. I had my own reasons, and beliefs about not attending any of the certification exam…

The death of the MCM Program

In case you’re unaware, Microsoft sent a late night email on Friday August 30th announcing it would kill off the MCM, MCSM and MCA certifications as of October 1, 2013. These are top level certifications, requiring candidates to do more than answer multiple-guess questions, and that, when achieved, really separate the experts from the rest…

Database 12c: What’s New with Data Pump? Lots.

Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.

Oracle Database 12c: Network Recovery in RMAN

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner’s Guide for Oracle Database 12c. Many of the new 12c features have fascinated me and my peers. I have thirsted in particular for the following handful of rman enhancements that are bundled with Database 12c…

SLOB2 Kick start

A few of my friends asked me to assist them with getting up to speed with SLOB2 testings. I have decided to publish this quick blog post and give people to a few hints. Additional Scripts Here are some of the scripts I have used to simplify SLOB testing management for my testing efforts: SLOB2…

OEM Notification on Generated Trace Files

The predefined metric “Dump Area Used (%)” can monitor space consumption for dump destination of oracle database. However, it just triggers on percentage occupied, and if there are several databases on the host using the same file system for trace files destination, the metric notifies DBA for all databases at once. I decided to create…

Connection Resets When Importing from Oracle with Sqoop

I’ve been using Sqoop to load data into HDFS from Oracle. I’m using version 1.4.3 of Sqoop, running on a Linux machine and using the Oracle JDBC driver with JDK 1.6. I was getting intermittent connection resets when trying to import data. After much troubleshooting, I eventually found the problem to be related to a…

Page 3 of 6712345...10...Last Page »