Re: Creating oracle 8i control file under RH 6.1

Marco Mapelli wrote:
>
> Hello all,
>
> I am experiencing a problem re-creating control
> file using Oracle 8i (8.1.6) under Linux RH 6.1.
> I am usaing the following create command :
>
> 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 raised error 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
>
> Does anymore know the reason ?
>
> Thanks in advance
>
> Marco Mapelli

You didn't specify a path for the SYSTEM tablespace's datafile.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.