Re: Problem creating control file

Marco Mapelli wrote:
>
> 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 ?

   Check controlfile name in your init<SID>.ora

valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia