Re: when are control files created

In our last gripping episode DutcherJG_at_navair.navy.mil (J. G. Dutcher) wrote:
> If nothing is wrong, why do I get the ORA 00205 error message? I
 wasn't
> expecting the oradim to create the database and don't understand why
 it is
> even checking for the existence of the control files.
>
> I've used this script before, and the third step (after the two oradim
> commands) is to create the actual database.
>
> Still wondering
>
> J. Dutcher
>
> In article <93novg$j5$1_at_nnrp1.deja.com>, David Fitzjarrell
> <oratune_at_aol.com> wrote:
>
> > 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/
>

The key to your difficulty is in the command itself:

oradim -startup -sid pdas -starttype srvc,inst -pfile d:\pdas\initpdas.ora

You are not only attempting to start the service (which should proceed without incident) you are also attempting to start the instance (which hasn't been created yet). This is why ORADIM is looking for the controlfiles. Take out the ',inst -pfile ...' and the service should start without error.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/