Re: when are control files created

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/