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 03:13:23 -0700 (PDT)
Message-ID: <032659b9-2cba-4ef2-99bd-ee6014215465@25g2000hsx.googlegroups.com>

And if I remove the .ctl files (I've backed up them) I get the error:

oracle_at_ablora01:BOCHUM> rm *.ctl
oracle_at_ablora01:BOCHUM> sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Fri Jun 27 11:47:33 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
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

SQL> exit
Disconnected from Oracle9i Release 9.2.0.8.0 - Production JServer Release 9.2.0.8.0 - Production

And the alert log file reports:

Starting up ORACLE RDBMS Version: 9.2.0.8.0. System parameters with non-default values:

  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 83886080
  large_pool_size          = 8388608
  java_pool_size           = 0
  control_files            = /abl/apps/oracle/oradata/BOCHUM/

control01.ctl,
/abl/apps/oracle/oradata/BOCHUM/control02.ctl,
/abl/apps/oracle/oradata/BOCHUM/control03.ctl

  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  cluster_database         = FALSE
  fast_start_mttr_target   = 0
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = BOCHUM
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = /abl/apps/oracle/admin/BOCHUM/bdump
  user_dump_dest           = /abl/apps/oracle/admin/BOCHUM/udump
  core_dump_dest           = /abl/apps/oracle/admin/BOCHUM/cdump
  sort_area_size           = 524288
  db_name                  = BOCHUM
  open_cursors             = 300

  star_transformation_enabled= FALSE

  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
  aq_tm_processes          = 1
PMON started with pid=2, OS id=29712
DBW0 started with pid=3, OS id=29714
LGWR started with pid=4, OS id=29716
CKPT started with pid=5, OS id=29718
SMON started with pid=6, OS id=29720
RECO started with pid=7, OS id=29722

CJQ0 started with pid=8, OS id=29724
QMN0 started with pid=9, OS id=29726
Fri Jun 27 11:47:40 2008
Oracle Data Guard is not available in this edition of Oracle. Fri Jun 27 11:47:40 2008
ALTER DATABASE MOUNT
Fri Jun 27 11:47:40 2008
ORA-00202: controlfile: '/abl/apps/oracle/oradata/BOCHUM/ control01.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3
Fri Jun 27 11:47:40 2008
ORA-205 signalled during: ALTER DATABASE MOUNT...

oracle_at_ablora01:BOCHUM> lsnrctl status

LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 27-JUN-2008 11:50:43

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.8.0 -
Production
Start Date                27-JUN-2008 11:26:12
Uptime                    0 days 0 hr. 24 min. 30 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         /abl/apps/oracle/9.2/network/log/

listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=ablora01.internal.novero.com)(PORT=1521))) Services Summary...
Service "BOCHUM" has 1 instance(s).
  Instance "BOCHUM", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

Any ideas please?

Regards
Alex Received on Fri Jun 27 2008 - 05:13:23 CDT