Re: when are control files created

Hi all.

I just wanted to point out that running the DB Creation Assistant is NOT mandatory on a NT box. A DB can be created manually easily (the same way you create it on any other system, except for the pain in the ass of the Service...)

The general procedure to create a DB is this:

1. pick a name
2. set ORACLE_SID
3. create your parameter file
4. create the service and point it at your parameter file
5. startup nomount
6. create database <---- controlfile(s) get created
7. run catalog, catproc, create rollback segs, create tablespaces, etc, etc.

That's exactly what the DB configuration assistant does ...

HTH Dave Haas

"David Fitzjarrell" <oratune_at_aol.com> wrote in message news:93novg$j5$1_at_nnrp1.deja.com...
> In our last gripping episode DutcherJG_at_navair.navy.mil (J. G. Dutcher)
> wrote:
> > I'm running Windows NT 4, Oracle 8.1.6.
> >
> > My understanding is that the control files are created when you do the
> > create database sql statement. However, when I do the oradim dos
 command,
> > I get the error message (the control files do not exist at this time)
> > ORA-00205 error in identifying control file xxxx. However, the control
> > name is in the init.ora file.
> >
> > The oradim statement that I'm executing is
> >
> > oradim -new -sid pdas -intpwd xxx -startmode auto -pfile
 d:\pdas\initpdas.ora
> >
> > followed by
> >
> > oradim -startup -sid pdas -starttype srvc,inst -pfile
 d:\pdas\initpdas.ora
> >
> > It is after the second oradim that I get the error.
> >
> > Can anyone give me some clues as to what is wrong?
> >
> > Any help gratefully accepted.
> >
> > J. Dutcher
> > newbie DBA
> >
>
> Nothing is wrong. ORADIM does not create a database, only the service
> and password file. It will be necessary to use the Oracle Database
> Configuration Assistant to actually create a database. You will need
> to delete the current service with ORADIM, then use the Oracle Database
> Configuration Assistant to create your database; the Configuration
> Assistant will create the database, the files the password file and the
> service.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 12 2001 - 17:59:12 CST