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

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jul 2011 14:38:04 -0500

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: