Re: control files trouble

Check your parameter file (init<sid>.ora) and look for parameter control_files=(path/filename, path/filename, ...) If you run command 'create database', oracle creates controlfiles as specified in init<sid>.ora. If the path part of this parameter is nonsense, then the creation of control files fails AFAIK.

--
Greetz from Estonia
Juhan Kundla

bakhit wrote:
>
> hi all
>
> i installed oracle 8.0.5 on redhat 5.2, and with some help was able to
> overcome most of the problems so far.
> last night i tried to create a new database,i did the following:
> 1. copied init.ora to initorcl.ora in changed the SID to reflect my
> database
> 2. copied the makedb.sql from the HOWTO
> 3. started up the server / connect internal/ @makedb
> it looked fine, but when i tried to startup the database it gave me an
> error message saying something about the control files and suggested i
> check the alert logfile.
> in the logfile this what i found about the control files:
> System parameters with non-default values:
> control files oracontrol1,oracontrol2
>
> and these error messages:
> ORA-00202: controlfile 'oracontrol1'
> ORA-27037: unable to obtain file status
> Linux Error:2: No such file or directory
>
> Now i understand this file is needed to create the database and somehow
> i don't have it. how can i create it? what does it contain? how
> important is it ?
>
> any help is really apprecitaed.
> thanx
> mark
Received on Mon Apr 05 1999 - 09:05:57 CDT