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

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 26 Jul 2011 19:46:12 +0000
Message-ID: <20110726194612.318750_at_gmx.com>

Well, you made at least half the list's day with this one. From all of us, "thank you"
----- Original Message -----

From: Andrew Kerber
Sent: 07/26/11 03: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 - 14:46:12 CDT