Error creating control file

From: Shirish Nilekar <shirish_at_shaydes.com>
Date: 15 Dec 2002 14:54:09 -0800
Message-ID: <af54e0f8.0212151454.40eebada@posting.google.com>

Hi,

I have two 9i databases with sid 'dev1' and 'dev2'. The control files for 'dev1' got messed up, and I have to recreate them. When I try to create control files for 'dev1' using CREATE CONTROLFILE ('dev2' is running while i am doing this), I get the following error:

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/usr/local/dbms/oracle/oradata/dev2/control01.ctl'
ORA-27086: skgfglk: unable to lock file - already in use

Linux Error: 11: Resource temporarily unavailable Additional information: 8

But if I shutdown 'dev2' and try to create control files for 'dev1', everything goes fine, and I can start 'dev1'. But then 'dev2' fails to mount with the following error:

ORA-01103: database name 'dev1' in controlfile is not 'dev2'

My command for creating control files is given at the end of this message. Why does the CREATE CONTROLFILE for 'dev1' database try to access control files of 'dev2' database? I recheked my ORACLE_SID env variable, and it is 'dev1'. The initdev1.ora file also has correct file locations for control files.

What could have caused this dependency between databases? And how can I fix it?

Thanks,
shirish
(http://www.shaydes.com)

-- 
CREATE CONTROLFILE REUSE SET DATABASE "DEV1" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE


  '/usr/local/dbms/oracle/oradata/dev1/redo03.log'  SIZE 100M,

  '/usr/local/dbms/oracle/oradata/dev1/redo02.log'  SIZE 100M,

  '/usr/local/dbms/oracle/oradata/dev1/redo01.log'  SIZE 100M

-- STANDBY LOGFILE
DATAFILE


  '/usr/local/dbms/oracle/oradata/dev1/system01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/undotbs01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/cwmlite01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/drsys01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/example01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/indx01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/tools01.dbf',

  '/usr/local/dbms/oracle/oradata/dev1/users01.dbf'

CHARACTER SET US7ASCII

Received on Sun Dec 15 2002 - 16:54:09 CST