Lee,
In my case (please see my previous post on the subject) I had proposed a
change that was rejected. In short I wanted to move a datafile during a
maintenance down day from one drive to another where there would be more room
for expansion. OK, so management rejected the change for dumb reasons (did not
want to see IO spread out too far across mount points) and a week or so later
the old "cannot extend" message appeared at 3AM (when else) with the mount point
at 100% utilization. The line techs declared a "line down" situation & I did
what I had wanted earlier, but as an emergency change. Total down time for the
assembly line was 3 hours at $1000 per minute. At the post-mortem meeting later
in the day I had a pile of fun rubbing the disapproved change request in
someone's face in front of their management. Boy do I love it when a damagement
person puts the egg on his/her own face!!! Can you say change of policy!!
Dick Goulet
____________________Reply Separator____________________
Author: Robertson Lee - lerobe <[EMAIL PROTECTED]>
Date: 6/26/2001 12:15 AM
Excuse me but you are a little presumptious and rude with that last mail. If
a process is put in place that requires a form to be signed and
authorisation to be given before action can be taken then I would be going
totally against the grain and would get into trouble for not adhering to the
company guidelines (as some of the UNIX S.A's did when they went in and made
changes without filling out the necessary paperwork !!). On the contrary to
your mail, I am a good DBA and I do take pride in my work and prior to the
ridiculous rules that were put in place all work was done proactively and we
never suffered because of it. What the managers (and "Quality Team", who had
no bloody idea what their process would do to us) failed to realise was
exactly how well I was doing my job, in that they were never bothered in the
past. Once the mistakes were made and there was reactive form filling
processes for certain things put in place, then things went back to normal.
I think thats whats called a bite on my behalf!!
-----Original Message-----
Sent: 25 June 2001 18:16
To: Multiple recipients of list ORACLE-L
I say that if you wait until you database has an error you really
aren't proving much except that you are not proactive in your job.
Which, in my book, makes you not a very good DBA. Dealing with a
dumb process is one thing (we have our fair share on this account)
but I take to much pride in my work to let things fail because I
need to fill in a piece of paper.
-----Original Message-----
Sent: Monday, June 25, 2001 9:43 AM
To: Multiple recipients of list ORACLE-L
Wahey !!! The answer I was going to provide. We started calling the manager
up quite frequently at home to authorise changes - he eventually saw sense.
Not quite as bad as 2am in the morning but inconvenient enough for him to
put a stop to it.
Best of Luck.
-----Original Message-----
Sent: 25 June 2001 17:07
To: Multiple recipients of list ORACLE-L
Jay;
I have had to go thru the same thing a couple times on a previous job with
Auditors. Every time those kind of restrictions were placed on us it
brought things to a snails pace or, in some conditions, a complete halt.
Sooner or later they realized that it was unreasonable and lifted them. But
it was a pain until they did it.
It took them a while to realize that we HAD to work the way we did in order
to keep things running smoothly.
I personally think that you should wait with resizing any of your production
data files until you get oracle errors saying that things can not extend.
At that time, call up the Sr. VP at 2 am in the morning and tell him that
you have a crisis but you can not proceed until you get his permission
because of the restrictions placed on you by the Auditors. Repeat this
process as many times as neccessary for them to lift the restrictions.
Kevin
-----Original Message-----
Sent: Monday, June 25, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L
We've been through an internal audit and I was just wondering if anyone else
has to deal with the rather ludicrous requirements I now have. In order to
add or resize a datafile I now need to fill out a form and get Senior VP
approval and the alert logs must be reviewed every day by a non-DBA in order
to be certain that I didn't make any database changes without such approval.
The auditors were horrified to discover that not only did I do such things
whenever I thought them necessary but that we didn't have a non-DBA review
everything I did after an Oracle upgrade to ensure I didn't install any
other software.
Fortunately I managed to convince them that yes, I really did need a Unix
login (they were skeptical).
So, any similar horror stories?
Jay Miller
Sr. Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
