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 05:21:28 -0700 (PDT)
Message-ID: <a64ad36c-ffb0-4927-826b-d19e644518c5@w8g2000prd.googlegroups.com>

First, plase backup your database .it will protect your data. It is very import!!!

.
I think the problem is OS,not oracle

---

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

ORA-00205: error in identifying controlfile, check alert log for more info

......
ALTER DATABASE MOUNT
Fri Jun 27 10:49:38 2008
ORA-00202: controlfile: '/abl/apps/oracle/oradata/BOCHUM/ control01.ctl'
ORA-27086: skgfglk: unable to lock file - already in use Linux Error: 11: Resource temporarily unavailable Additional information: 8

---

when oracle startup,it first allocated memory for sga,then mounted the database (open control file),but it failed,because of "ORA-00205: error in identifying controlfile",

it indicated oracle could not open the control file.

in the alert.log,there was error messese: "ORA-27086: skgfglk: unable to lock file - already in use "

so,ora27086 was the cause of ora-00205 , but the "Linux Error: 11: Resource temporarily unavailable " was the cause of ora-27086.

you haved followed my advice ,moved the control file,and used a new backup control file to startup .
so the oracle database mounted ,it could open the control file.

---

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.

---

last,oracle could not open other datafile ,because of
>ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
> ORA-01110: data file 1: '/abl/apps/oracle/oradata/BOCHUM/system01.dbf'

so there is a simple solution,

cp /abl/apps/oracle/oradata/BOCHUM/system01.dbf /abl/apps/oracle/

oradata/BOCHUM/system01.dbf'.bak
mv   /abl/apps/oracle/oradata/BOCHUM/system01.dbf  /abl/apps/oracle/
oradata/BOCHUM/system01.dbf.orig

mv /abl/apps/oracle/oradata/BOCHUM/system01.dbf'.bak /abl/apps/oracle/ oradata/BOCHUM/system01.dbf

perhaps,you must do it for every datafile . Received on Fri Jun 27 2008 - 07:21:28 CDT