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

From: A. Farber <Alexander.Farber_at_gmail.com>
Date: Fri, 27 Jun 2008 02:55:14 -0700 (PDT)
Message-ID: <39bea971-1aec-4959-9a3d-5c242c216d2c@e53g2000hsa.googlegroups.com>

Hello,

I've followed your advice and
issued "shutdown immediate" from sqlplus, then:

On 27 ÉÀÎ, 11:47, machao <machao2..._at_gmail.com> wrote:
> 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'

Then I've tried to "startup" from sqlplus and:

> 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'

Now I have an even worse looking error message:

SQL> startup
ORACLE instance started.

Total System Global Area 135336712 bytes

Fixed Size                   451336 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/abl/apps/oracle/oradata/BOCHUM/system01.dbf'

Regards
Alex Received on Fri Jun 27 2008 - 04:55:14 CDT