Re: possible nomination for oracle wtf

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Thu, 23 Jul 2009 12:09:01 -0700 (PDT)
Message-ID: <077b75f0-a25d-4ad0-83d0-4f952233a8ac_at_a7g2000yqk.googlegroups.com>



On Jul 23, 1:05 pm, gazzag <gar..._at_jamms.org> wrote:

snip

> I think you completely missed the point, John.  As others have
> commented, she was pointing out the value of proper error reporting:
>
> "....the basics of error handling should not be ignored – When an
> error occurs,  we must know what was the error."
>
> It reminds me of the circumstances in which I entered the world of the
> Oracle DBA.  Many years ago, Oracle 7.3.4, in fact, I was a contractor
> in a government department.  At the time, the incumbent Oracle DBA was
> away for a week and we had a problem that could possibly have required
> us to revert to the previous night's cold backup.  I was tasked with
> locating the relevant tapes and checking their contents.  I tried the
> tape from the previous night's backup and my heart sank as it appeared
> to be empty.  The tape from the night before was empty aswell.  As I
> worked backwards through tape after tape, it became apparent that we
> had no backup whatsoever.
>
> I located the script that was run by cron every night and examined
> it.  There, the very last line in the script simply was:
>
> echo "Backup completed." | mail <list_of_recipients>
>
> There was no logic within the script - that line would be executed
> regardless.  Fortunately we found a workaround to the issue, so no
> real harm was done.  Apart to the DBA's career, naturally.  When the
> then-DBA returned from holiday he was "promoted sideways" and I was
> treated to approximately six weeks worth of training with Oracle :-)

The part especially for Oracle WTF was the code in the WHEN OTHERS logic ... basically job failed not catching how/why and no RAISE statement.

But it is at least amusing to me the politics involved in having Oracle ACE's employed ( that might or might not have a clue ... it probably varies a lot person by person ) in organizations that allow stuff like this to either almost run in production or really get installed into production.

It could be the factor "well we know better but we do not have any management willing to stop stuff like this from happening".

Also amusing is the idea that this project is so big and so important and ... well let's allow the DBA involved to take a 3 week vacation as it goes live ... that sounds like a recipe for fireworks if any problems develop. Received on Thu Jul 23 2009 - 14:09:01 CDT

Original text of this message