Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CREATE DATABASE error ??? [worked!]

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

From: Kurt <kurti_at_kurti.cc>
Date: Fri, 16 Mar 2001 17:22:35 GMT
Message-ID: <vZrs6.159915$ld4.5689780@news.chello.at>

you need to use a ' befor and anfter each filename so you left away two '

do use

> > logfile GROUP 1 ('/u01/oradata/dev1/redo01a.log',
> > '/u02/oradata/dev1/redo01b.log') size
500k,

instead of

> > logfile GROUP 1 ('/u01/oradata/dev1/redo01a.log,
> > /u02/oradata/dev1/redo01b.log') size 500k,

"Jack Wang" <cwang9_at_hotmail.com> wrote in message news:iRcr6.22428$Pq3.6492987_at_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 Fri Mar 16 2001 - 11:22:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US