Oracle Database Discussions

hi

after installing the oracle software, I ran dbca to create the DB.

However, a pop-up message appears:
ORA-01092: Oracle instance terminated. Disconnection forced.


the trace file shows:


kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0

Control file created with size 430 blocks

*** 2007-10-24 18:04:39.488

ORA-00604: error occurred at recursive SQL level 1

ORA-02494: invalid or missing maximum file size in MAXSIZE clause

Offending statement at line 5795

CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE '/sapidou1/oracle/oradata/sapidou/sapidou/undotbs01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 4000M, '/sapidou1/oracle/oradata/sapidou/sapidou/undotbs02.dbf' SIZE 1000M AUTOEXTEND ON NEXT 100K MAXSIZE 4000K

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5795

ORA-00604: error occurred at recursive SQL level 1

ORA-02494: invalid or missing maximum file size in MAXSIZE clause





The createDB log shows:

ORACLE instance started.
Total System Global Area 5251268608 bytes
Fixed Size 2178360 bytes
Variable Size 949797576 bytes
Database Buffers 4294967296 bytes
Redo Buffers 4325376 bytes
CREATE DATABASE "SAPIDOU"
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


thanks