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

  • From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
  • To: "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jul 2011 21:12:23 +0000

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@xxxxxxxxx'; 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.'

Other related posts: