Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: machao <machao2004@xxxxxxxxx>
- Date: Fri, 27 Jun 2008 05:21:28 -0700 (PDT)
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 .
.
- Follow-Ups:
- References:
- ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: A. Farber
- Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: machao
- Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: A. Farber
- Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: A. Farber
- Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- From: A. Farber
- ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- Prev by Date: Re: Oracle ODBC scalability with increased user volumes
- Next by Date: Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- Previous by thread: Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- Next by thread: Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
- Index(es):
Relevant Pages
|
