"Marco Mapelli" <mapelli.marco_at_libero.it> wrote in message
news:8914cf58.0111020158.29aaf642_at_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
The specification of a datafile is wrong. Perhaps the mount point does not
exist.
Received on Mon Nov 05 2001 - 06:18:23 CST
