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

"Mladen Gogala" <mgogala_at_yahoo.com> schreef in bericht news:4869ea21$0$1350$834e42db_at_reader.greatnowhere.com...
> On Fri, 27 Jun 2008 02:36:36 -0700, A. Farber wrote:
>
>> Hello DBAs,
>>
>> I'm running Oracle 9.2.0.8 on CentOS Linux 4.6 (which is same as RHEL
>> 4.6).
>
> This is an unsupported version of it. No support from Oracle. If it's
> any consolation, I am running 11G RAC/ASM on CentOS 5.2. Works like a
> charm.
>
> [mgogala_at_dibidus ~]$ uname -a
> Linux dibidus 2.6.18-92.1.6.el5.centos.plus #1 SMP Thu Jun 26 12:25:59
> EDT 2008 i686 i686 i386 GNU/Linux
> [mgogala_at_dibidus ~]$ cat /etc/redhat-release
> CentOS release 5.2 (Final)
> [mgogala_at_dibidus ~]$
>
>>
>> Since yesterday I'm unable to startup a "BOCHUM" database:
>
> I am available for consulting.
>
> .....
>> oracle_at_ablora01:~> sqlplus /nolog
>>
>> SQL*Plus: Release 9.2.0.8.0 - Production on Fri Jun 27 10:49:11 2008
>>
>> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>>
>> 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
>
> Hmmm, you can't access control file. From what you wrote a little bit
> later, it is not lost, it is only inaccessible. Many things can cause
> this. What kind of storage are you using? If it's NAS, are you sure that
> you've used the right storage options? As I have said before, I am
> available for consulting. Contact me by email if you need more
> information.
>
> --
> Mladen Gogala
> http://mgogala.freehostia.com

Please: for commercial posts use comp.database.oracle.marketplace ;-)

Shakespeare Received on Tue Jul 01 2008 - 04:09:27 CDT