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:10:37 +0000
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:
- » all time worst question I have been ever asked as a DBA- Andrew Kerber
- » Re: all time worst question I have been ever asked as a DBA- Lyall Barbour
- » Re: all time worst question I have been ever asked as a DBA- Paul Drake
- » Re: all time worst question I have been ever asked as a DBA- Thomas Roach
- » RE: all time worst question I have been ever asked as a DBA- Aragon, Gabriel (GE, Corporate, consultant)
- » RE: all time worst question I have been ever asked as a DBA - Walker, Jed S
- » RE: all time worst question I have been ever asked as a DBA- Walker, Jed S
- » Re: all time worst question I have been ever asked as a DBA- Guillermo Alan Bort
- » Re: all time worst question I have been ever asked as a DBA- Hans Forbrich
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Ram Srinivasan
- » RE: all time worst question I have been ever asked as a DBA- Goulet, Richard
- » RE: all time worst question I have been ever asked as a DBA- Marco Gralike
- » RE: all time worst question I have been ever asked as a DBA- Stephens, Chris
- » Re: all time worst question I have been ever asked as a DBA- S. Anthony Sequeira
- » Re: all time worst question I have been ever asked as a DBA- Kevin Lidh
- » Re: all time worst question I have been ever asked as a DBA- Brian Anderson
- » Re: all time worst question I have been ever asked as a DBA- Nilo Segura
- » RE: all time worst question I have been ever asked as a DBA- Amaral, Rui
- » RE: all time worst question I have been ever asked as a DBA- Lange, Kevin G
- » Re: all time worst question I have been ever asked as a DBA- Bill Ferguson
- » Re: all time worst question I have been ever asked as a DBA- Kellyn Pot'vin
- » Re: all time worst question I have been ever asked as a DBA- Marco Gralike
- » Re: all time worst question I have been ever asked as a DBA- Ram Srinivasan
- » Re: all time worst question I have been ever asked as a DBA- David Fitzjarrell
- » Re: all time worst question I have been ever asked as a DBA- Guillermo Alan Bort
- » RE: all time worst question I have been ever asked as a DBA- Aragon, Gabriel (GE, Corporate, consultant)
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Adric Norris
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Eric Jenkinson
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » RE: all time worst question I have been ever asked as a DBA- Goulet, Richard
- » Re: all time worst question I have been ever asked as a DBA- Mark Brinsmead
- » Re: all time worst question I have been ever asked as a DBA- Kellyn Pot'Vin
- » RE: all time worst question I have been ever asked as a DBA- Upendra N
- » Re: all time worst question I have been ever asked as a DBA- rjamya
- » RE: all time worst question I have been ever asked as a DBA- Bobak, Mark
- » Re: all time worst question I have been ever asked as a DBA- David Fitzjarrell