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

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Tue, 26 Jul 2011 21:10:37 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C4E353375_at_COPDCEXMB08.cable.comcast.com>

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-l Received on Tue Jul 26 2011 - 16:10:37 CDT