RE: all time worst question I have been ever asked as a DBA

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 27 Jul 2011 08:39:47 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F125A44DB_at_us-bos-mx022.na.pxl.int>



OH BOTHER, I’ve had a month of those days recently. End result the DBA(that would be me) blew his top and hung up on the complaining developers. They then decided to take the DBA’s advice & poof, all the problems disappeared. Wonder Why?  

Richard Goulet

Senior Oracle DBA/Na Team Leader  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ram Srinivasan Sent: Wednesday, July 27, 2011 7:03 AM
To: fuzzy.graybeard_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: all time worst question I have been ever asked as a DBA  

I love this one.  

Yes. Everything is DBA's fault, even after proving (showing log files, etc.) that the fault is with developers or with the unix system.  

It is always DBA's fault, whatever it is.  

Ram Srinivasan


On Tue, Jul 26, 2011 at 9:47 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

According to nearly every User, SysAdmin, NetAdmin and StorAdmin I know:

Rule 1: It's the DBA's fault

Rule 2: You can change anything arbitrarily without telling the DBA, it'll still be the DBA's fault.

Rule 3: Even when the DBA shows exactly where (in another area) the problem is, It still is the DBA's fault.

Developers add:

Performance, security and integrity are add-ons, after the fact. When they are needed, it's the DBA's fault.

On 26/07/2011 3:12 PM, Walker, Jed S wrote:

Argh, hit send too soon:  

+ then tell him to do that for all of them and if he gets it wrong it’ll be on him. He’ll learn to fix it.  

From: Walker, Jed S
Sent: Tuesday, July 26, 2011 3:11 PM
To: 'andrew.kerber_at_gmail.com'; ORACLE-L Subject: RE: all time worst question I have been ever asked as a DBA  

Common with netapp, you can actually try copying the file to a new file. Delete that file, and then rename the copy back. I think that will work, but it can be a pain.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Tuesday, July 26, 2011 1:38 PM
To: ORACLE-L
Subject: all time worst question I have been ever asked as a DBA  

So, I am getting this error on one of our virtual Linux servers:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/datafiles/devdb/control01.ctl'
ORA-27086: unable to lock file - already in use

Its probably due to a stale NFS lock. The question from my sys admin:

-rw-r----- 1 oracle oinstall 10076160 Jul 22 13:33 control01.ctl

can that file just be removed

Ok, I am a little frustrated with him...

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'  

--

Sincerely
Ram Srinivasan

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 27 2011 - 07:39:47 CDT

Original text of this message