Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> control files trouble

control files trouble

From: bakhit <bakhit_at_rideau.carleton.ca>
Date: 1 Apr 1999 19:16:00 GMT
Message-ID: <7e0glg$oio$1@bertrand.ccs.carleton.ca>

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 Thu Apr 01 1999 - 13:16:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US