Re: CREATE DATABASE error ??? [worked!]

From: Jack Wang <cwang9_at_hotmail.com>
Date: Mon, 12 Mar 2001 23:20:46 GMT
Message-ID: <iRcr6.22428$Pq3.6492987@typhoon.tampabay.rr.com>

Peter:

That change in quote fixed my problem instantly, Thanks,

Jack

"Peter Laursen" <pl_at_mail1.remove.this.stofanet.dk> wrote in message news:uQPq6.1338$Q%2.35744_at_news101.telia.com...
> datafile '/u03/oradata/dev1/system01.dbf' size 60m
> logfile GROUP 1 ('/u01/oradata/dev1/redo01a.log,
> /u02/oradata/dev1/redo01b.log') size 500k,
> GROUP 2 ('/u03/oradata/dev1/redo02a.log,
> /u04/oradata/dev1/redo02b.log') size 500k;

>ORA-01501: CREATE DATABASE failed
>ORA-00301: error in adding log file '/u01/oradata/dev1/redo01a.log,
>/u02/oradata/dev1/redo01b.log' - file cannot be created
>ORA-27040: skgfrcre: create error, unable to create file
>Linux Error: 2: No such file or directory

Jack,
Your filespec needs to be:

logfile GROUP 1 ('/u01/oradata/dev1/redo01a.log',

                                  '/u02/oradata/dev1/redo01b.log') size

500k,

Peter Laursen Received on Mon Mar 12 2001 - 17:20:46 CST