Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED

From: machao <machao2004_at_gmail.com>
Date: Fri, 27 Jun 2008 02:47:26 -0700 (PDT)
Message-ID: <726da134-a17f-4234-a8e6-2b87352d8fd7@p39g2000prm.googlegroups.com>


Was your cotrolfile DAMAGED ?

Backup your control file and try to restart instance mv '/abl/apps/oracle/oradata/BOCHUM/control01.ctl' '/abl/apps/oracle/ oradata/BOCHUM/control01.bak'
mv '/abl/apps/oracle/oradata/BOCHUM/control02.ctl' '/abl/apps/oracle/ oradata/BOCHUM/control02.bak'
mv '/abl/apps/oracle/oradata/BOCHUM/control03.ctl' '/abl/apps/oracle/ oradata/BOCHUM/control03.bak'

cp '/abl/apps/oracle/oradata/BOCHUM/control01.bak' '/abl/apps/ oracle/oradata/BOCHUM/control01.ctl'
cp '/abl/apps/oracle/oradata/BOCHUM/control02.bak' '/abl/apps/ oracle/oradata/BOCHUM/control02.ctl'
cp '/abl/apps/oracle/oradata/BOCHUM/control03.bak' '/abl/apps/ oracle/oradata/BOCHUM/control03.ctl' Received on Fri Jun 27 2008 - 04:47:26 CDT

Original text of this message