Re: Create Database ...

From: Sebastian Rehm (QI/LBS3-Rt) <Sebastian.Rehm_at_rt.bosch.de>
Date: Wed, 10 Jun 1998 15:07:10 +0200
Message-ID: <357E84FE.CD0648B4@rt.bosch.de>

Hi,

I had this problem too.

I think a size of 10M for the system-tablespace is to small ... If this does not help, try to set the values for maxlogfiles and/or maxlogmembers higher.

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

    CREATE DATABASE DW80
    controlfile reuse
    logfile group 1 ('C:\DATABASE\log1DW80.dbf','D:\DATABASE\log1DW80.db= f') SIZE 1M reuse,

               group 2 ('C:\DATABASE\log2DW80.dbf','D:\DATABASE\log2DW80.= dbf') SIZE 1M reuse,

               group 3 ('C:\DATABASE\log3DW80.dbf','D:\DATABASE\log3DW80.= dbf') SIZE 1M reuse,

               group 4 ('C:\DATABASE\log4DW80.dbf','D:\DATABASE\log4DW80.= dbf') SIZE 1M reuse

    maxlogfiles 10
    maxlogmembers 3
   datafile 'C:\DATABASEsystem_01_DW80.dbf' size 50M reuse    maxdatafiles 40
   maxinstances 2
   noarchivelog
   character set we8iso8859p1
    /

---

regards
Sebastian

Jones Chung wrote:

> C:> svrmgr30
> . . . .
> SVRMGR>connect internal/test
> connected!
> SVRMGR>startup nomount
>
> ORACLE °õ¦æ¶µ¦¸¶}©l.
> ¨t²Î¾ãÅé°Ï¦@ 11705004 ­Ó¦ì¤¸²Õ=

> Fixed Size 47788 ­Ó¦ì¤¸²Õ
> Variable Size 11173888 ­Ó¦ì¤¸²Õ
> Database Buffers 409600 ­Ó¦ì¤¸²Õ
> Redo Buffers 73728 ­Ó¦ì¤¸²Õ
> ORACLE °õ¦æ¶µ¦¸¶}©l.
> (* Sorry for the Chinese charters, however it's sucessful for
> starting)
> SVRMGR>@d:\OraNT\createdb
> create database test
> *
> ORA-00603: ORACLE server session terminated by fatal error
> SVRMGR>
> =========================

---

==
> where the content of createdb.sql is:
> >>>>
> 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,
>
> regards,
> Jones
Received on Wed Jun 10 1998 - 08:07:10 CDT