Re: database create

You'll need to start over:

--do a shutdown abort
--delete all files created under /oracle_data/oradata/PROTO

Then run your create script.

Suzy

Steff Gonos wrote:
>
> help ...
>
> what have I done in the following scenario -
> I used a script to issue the create database
> command. For my data file, the path was incorrect.
> So I got a create database failed message.
>
> I corrected the path, reissued the command and now
> am getting the create data base failed message and
> data base mounted message.
>
> Can I just add the data file? I looked at the
> ALter tablespace command that allows me to add
> a datafile, but I am confused, cause at this point,
> I don't believe I have a tablespace created.
>
> This is what I issued -
> create database PROTO
> maxinstances 8
> maxlogfiles 32
> maxdatafiles 500
> datafile
> '/oracle_app/oradata/PROTO/PROTOsys01.dbf' size
> 100M
> logfile
> group 1 ('/oracle_app/oradata/PROTO/PROTOlog1a.dbf',
> '/oracle_data/oradata/PROTO/PROTOlog1b.dbf')
> size 10M,
> group 2 ('/oracle_app/oradata/PROTO/PROTOlog2a.dbf',
> '/oracle_data/oradata/PROTO/PROTOlog2b.dbf')
> size 10M,
> group 3 ('/oracle_app/oradata/PROTO/PROTOlog3a.dbf',
> '/oracle_data/oradata/PROTO/PROTOlog3b.dbf')
> size 10M,
> group 4 ('/oracle_app/oradata/PROTO/PROTOlog4a.dbf',
> '/oracle_data/oradata/PROTO/PROTOlog4b.dbf')
> size 10M;
>
> Appreciate any ideas on how to fix this.
> Thanks.
> Steff Gonos
> TASC
>
> =====
> *******************************************************
> The opinions expressed herein are mine. Get your own opinions!
> *******************************************************
>
> Steff Gonos
> steff_gonos_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: Steff Gonos
> INET: steff_gonos_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Wed Jul 12 2000 - 15:44:35 CDT