Re: CREATE DATABASE (..) LOGFILE question

I suppose you have successfully created the instance.

STARTUP NOMOUNT PFILE = INITTEST.ORA
CREATE DATABASE TEST
LOG FILE
    GROUP1 ('/DISK3/LOG1A.RDO','/DISK4/LOG1B.RDO') SIZE 60M,     GROUP2 ('/DISK3/LOG2A.RDO','/DISK4/LOG2B.RDO') SIZE 60M DATAFILE
    '/DISK1/TEST01.DBF' SIZE 100M AUTOEXTEND ON CHARACTER SET WE8ISO8859P1; Hope it helps.

Wuchun Shen

Surf the World wrote:

> Hello All-
>
> Forgive my ignorance as I'm a newcomer to the realm of installing and
> administering Oracle, but I'm lost and had no where else to turn to.
>
> I'm running Linux and have created my init<SID>.ora file and have
> successfully startup'ed it with the svrmgrl. However, when I try to
> create my test database using the following command:
>
> CREATE DATABASE test DATAFILE '/u7/test.db' SIZE 600M LOGFILE
> ('/u7/test.log') SIZE 60M
>
> I get:
> ORA-01518: CREATE DATABASE must specify more than one log file
>
> I have tried several variations on the above logfile entry, including
> things like ('/u7/test.log' SIZE 60M, '/u7/test2.log' SIZE 60M) and have
> also tried using the MAXLOGFILES variable. I couldn't get it to work.
>
> I have several fairly heavy Oracle books that're good for Oracle research
> (as well as smashing bugs) but none of them give a good concrete example
> of the CREATE DATABASE command. Similarly, the Oracle 8 documentation for
> the ORA-01518 error message isn't too informative.
>
> One of the bug-squashing books I have mentioned that "File specifications
> for log files depend on the operating system." I take that to mean that
> under *nix systems you have a '/blah/nowhere' logfile format and WinX
> boxes have a "C:\blah\nowhere' format.
>
> If someone could gimme a pointer on this, I would be grateful.
>
> ------------
> En Taro Adun
> Chris Blunck
Received on Fri Jun 04 1999 - 16:08:34 CDT