Re: Create Database ...

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 10 Jun 1998 14:44:54 +0200
Message-ID: <6llv0m$7jt$1@hermes.is.co.za>

Jones Chung wrote in message <357ca85a.411463656_at_news.seed.net.tw>...

>ORA-00603: ORACLE server session terminated by fatal error

This is what the online help says:
00603, 00000, "ORACLE server session terminated by fatal error" // *Cause: An ORACLE server session is in an unrecoverable state. // *Action: Login to ORACLE again so a new server session will be created

Not very useful. :-)

>create database test
> datafile 'test_system' size 10M
> logfile group 0 ('test_log1a', 'test_log1b') size 500K,
> group 2 ('test_log2a', 'test_log2b') size 500K;
>what's wrong it happened? Thanks for help again,

Where's the control file statement - I think it's needed? And I suggest that you rather specify full path names for all files.

Something like this:
---
STARTUP nomount PFILE=C:\orant\DATABASE\initDW80.ora;

CREATE DATABASE DW80
    controlfile reuse

    logfile  'C:\DATABASE\log1DW80.dbf' SIZE 1M reuse,
             'C:\DATABASE\log2DW80.dbf' SIZE 1M reuse,
             'C:\DATABASE\log3DW80.dbf' SIZE 1M reuse,
             'C:\DATABASE\log4DW80.dbf' SIZE 1M reuse
    datafile 'C:\DATABASE\sys1DW80.dbf' SIZE 10M reuse

    character set WE8ISO8859P1;
---

There's probably a syntax error in your CREATE DATABASE statement that's causing the error. Peek in the manual again to make sure you have the syntax right and all have bases covered when it comes to the options.

regards,
Billy Received on Wed Jun 10 1998 - 07:44:54 CDT