adewi,

below is my creation scripts:

startup nomount pfile=/home/oracle/admin/HULAND01/pfile/initHULAND01.ora

create database HULAND01
controlfile reuse
logfile ('/u01/oradata/HULAND01/log1HULAND01_A.log',
'/u01/oradata/HULAND01/log1HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log2HULAND01_A.log',
'/u01/oradata/HULAND01/log2HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log3HULAND01_A.log',
'/u01/oradata/HULAND01/log3HULAND01_B.log') size 20M
maxdatafiles 1022
maxlogfiles 32
maxlogmembers 5
maxinstances 10
character set "WE8ISO8859P1"
EXTENT MANAGEMENT LOCAL
datafile '/u01/oradata/HULAND01/system01.dbf' size 400m
DEFAULT TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
size 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k;



one thing on my init.ora I have as follow:

undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1