Re: all time worst question I have been ever asked as a DBA
Date: Tue, 26 Jul 2011 22:29:58 -0300
Message-ID: <CAJ2dSGTxQPxbjd7v-0z670=DhRHix-3uOiUgPPs6YRP=W+1bKA_at_mail.gmail.com>
Since when has that worked?
I can't count the number of times I've been called on the 11th hour because
someone crapped out something and the customer was pissed off and they
needed someone who would actually get the DB up in the least possible amount
of time...
Alan.-
On Tue, Jul 26, 2011 at 6:12 PM, Walker, Jed S <Jed_Walker_at_cable.comcast.com
> 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.'****
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 26 2011 - 20:29:58 CDT