Problem creating control file

From: Marco Mapelli <mapelli.marco_at_libero.it>
Date: 2 Nov 2001 01:58:40 -0800
Message-ID: <8914cf58.0111020158.29aaf642@posting.google.com>

Hello all,

I am having problems creating control file under RH 6.1 and Oracle 8.1.6.
I use the following SQL statement :

create controlfile reuse
database SYST

LOGFILE GROUP 1 ('/home/oracle/syst/data/log1.log',


                 '/home/oracle/syst/data/redobck/log1.log') SIZE 1M REUSE,    

        GROUP 2 ('/home/oracle/syst/data/log2.log',


                 '/home/oracle/syst/data/redobck/log2.log') SIZE 1M REUSE

maxinstances 2 resetlogs;

The error I get is :

create controlfile reuse
*

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'
ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory Additional information: 3

Any ideas ?

Thanks in advance

Marco Mapelli Received on Fri Nov 02 2001 - 03:58:40 CST