C:\SET ORACLE_SID = ALI

CREATE DATABASE ali
logfile
GROUP 1('C:\ali\log_01_ali.rdo') size 15M,
 GROUP 2 ('C:\ali\log_02_ali.rdo') size 15M,
GROUP 3 ('C:\ali\log_03_ali.rdo') size 15M
DATAFILE 'C:\ali\SYSTEM_01_ali.DBF' SIZE 100M
undo tablespace undotbs1 
datafile 'c:\ali\undo01.dbf' SIZE 10M
sysaux datafile 'C:\ali\sysaux01.dbf' SIZE 10M
default temporary tablespace temp
tempfile 'C:\ali1\temp_01_ali.dbf' size 20M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
/

Dump file e:\oracle\rdbms\trace\alert_ali.log
Wed Dec 18 12:52:14 2002
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:299M/503M, Ph+PgF:1784M/1986M, VA:1941M/2047M
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
Wed Dec 18 12:52:14 2002
Starting ORACLE instance (normal)
Wed Dec 18 12:52:14 2002
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as E:\Oracle\RDBMS
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  control_files            = C:\ALI\CONTROL01.ORA, C:\ALI\CONTROL02.ORA
  db_block_buffers         = 2048
  db_block_size            = 4096
  undo_management          = AUTO
  undo_tablespace          = undtbs
  remote_login_passwordfile= SHARED
  instance_name            = ali
  db_name                  = ali
Wed Dec 18 12:52:14 2002
WARNING:Shared I/O Pool created with size=0 set size=0
PMON started with pid=2, OS id=1340
PSP0 started with pid=3, OS id=3724
MMAN started with pid=4, OS id=3652
DBW0 started with pid=5, OS id=2372
LGWR started with pid=6, OS id=1632
CKPT started with pid=7, OS id=3844
SMON started with pid=8, OS id=3648
RECO started with pid=9, OS id=3688
MMON started with pid=10, OS id=2132
MMNL started with pid=11, OS id=972
Wed Dec 18 12:52:34 2002
CREATE DATABASE ali
logfile GROUP 1('C:\ali\log_01_ali.rdo') size 15M,
 GROUP 2 ('C:\ali\log_02_ali.rdo') size 15M,
GROUP 3 ('C:\ali\log_03_ali.rdo') size 15M
DATAFILE 'C:\ali\SYSTEM_01_ali.DBF' SIZE 100M
UNDO TABLESPACE UNDO
DATAFILE 'C:\ali\undo_01_ali.DBF' SIZE 40m
sysaux datafile 'C:\ali\sysaux01.dbf' SIZE 10M
default temporary tablespace temp
tempfile 'C:\ali1\temp_01_ali.dbf' size 20M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
Wed Dec 18 12:52:38 2002
Database mounted in Exclusive Mode
Wed Dec 18 12:52:50 2002
Successful mount of redo thread 1, with mount id 143894482
Assigning activation ID 143894482 (0x893a7d2)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: C:\ALI\LOG_01_ALI.RDO
Successful open of redo thread 1
Wed Dec 18 12:52:50 2002
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Dec 18 12:52:50 2002
SMON: enabling cache recovery
Wed Dec 18 12:52:50 2002
create tablespace SYSTEM datafile  'C:\ali\SYSTEM_01_ali.DBF' SIZE 100M

  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online

Wed Dec 18 12:53:21 2002
Completed: create tablespace SYSTEM datafile  'C:\ali\SYSTEM_01_ali.DBF' SIZE 100M
  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Wed Dec 18 12:53:21 2002
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Wed Dec 18 12:53:28 2002
CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\ali\undo_01_ali.DBF' SIZE 40m


Wed Dec 18 12:53:35 2002
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\ali\undo_01_ali.DBF' SIZE 40m
...
Wed Dec 18 12:53:35 2002
Errors in file e:\oracle\rdbms\trace\ali_ora_3596.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'undtbs' does not exist or of wrong type

Wed Dec 18 12:53:35 2002
Errors in file e:\oracle\rdbms\trace\ali_ora_3596.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 5792
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'undtbs' does not exist or of wrong type

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_pmon_1340.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_reco_3688.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_smon_3648.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_ckpt_3844.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_lgwr_1632.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_dbw0_2372.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_mman_3652.trc:
ORA-01519: error while processing file '' near line 

Wed Dec 18 12:53:36 2002
Errors in file e:\oracle\rdbms\trace\ali_psp0_3724.trc:
ORA-01519: error while processing file '' near line 

Instance terminated by USER, pid = 3596
ORA-1092 signalled during: CREATE DATABASE ali
logfile GROUP 1('C:\ali\log_01_ali.rdo') size 15M,
 GROUP 2 ('C:\ali\log_02_ali.rdo') size 15M,
GROUP 3 ('C:\ali\log_03_ali.rdo') size 15M
DATAFILE 'C:\ali\SYSTEM_01_ali.DBF' SIZE 100M
UNDO TABLESPACE UNDO
DATAFILE 'C:\ali\undo_01_ali.DBF' SIZE 40m
sysaux datafile 'C:\ali\sysaux01.dbf' SIZE 10M
default temporary tablespace temp
tempfile 'C:\ali1\temp_01_ali.dbf' size 20M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K...

undo tablespace undotbs1 
datafile 'c:\ali\undo01.dbf' SIZE 10M