If you haven't created the database yet, look at the 'create database'
command. The controlfiles get created when you create the database.
If you already created a database, what happened to your controlfiles?
Anyway, if you lost them, you can always use the 'create controlfile'
command to get them back.
Also, you might want to have a look at the Oracle Concepts Manual. It
explains all about creating a database and controlfiles.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sun, 24 Nov 2002, john wrote:
> the location mentioned in the init.ora for control files does not
> have any control file.
> since this is a new install, please let me know how to generate or
> rather recreate control file(s).
> [since there are no control file the system is unable to start]
>
> since instance is getting shutdown, i cannot enter sql as well. how
> do i create these control files ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
INET: jwilton_at_speakeasy.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Nov 24 2002 - 17:08:38 CST
