I was using the DB Config Asst (8.1.5 on NT4) to create a very small database (10Mb files, System datafile of 5Mb etc), all the files on 1 disk etc when the Assistant failed.
Error messages: "ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 3476".
Followed by "ORA-00604: error occurred at recursive SQL Level 1"
Followed by "ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM.".
I used the INITIAL extent size of 100K for SYSTEM so a 5Mb size should accommodate this???
I have included the tail of the ALERT log here:
ARC0: media recovery disabled
Thu Feb 28 15:14:22 2002
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 2 seq# 4 mem# 0: G:\ORACLE\INACT1\INACT_REDO_02.LOG
LGWR: prodding the archiver
Thread 1 advanced to log sequence 5
Thu Feb 28 15:14:24 2002
Current log# 1 seq# 5 mem# 0: G:\ORACLE\INACT1\INACT_REDO_01.LOG
Thu Feb 28 15:14:24 2002
ARC0: received prod
Thu Feb 28 15:14:24 2002
ARC0: media recovery disabled
Thu Feb 28 15:14:26 2002
Thread 1 cannot allocate new log, sequence 6
Checkpoint not complete
Current log# 1 seq# 5 mem# 0: G:\ORACLE\INACT1\INACT_REDO_01.LOG
LGWR: prodding the archiver
Thread 1 advanced to log sequence 6
Thu Feb 28 15:14:27 2002
Current log# 2 seq# 6 mem# 0: G:\ORACLE\INACT1\INACT_REDO_02.LOG
Thu Feb 28 15:14:27 2002
ARC0: received prod
Thu Feb 28 15:14:27 2002
ARC0: media recovery disabled
Thu Feb 28 15:14:28 2002
ORA-1652: unable to extend temp segment by 3 in tablespace SYSTEM
Thu Feb 28 15:14:28 2002
Errors in file C:\Ora8i\admin\Inact1\udump\ORA00432.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
Thu Feb 28 15:14:28 2002
SMON: disabling cache recovery
Thu Feb 28 15:14:28 2002
ORA-1501 signalled during: CREATE DATABASE Inact1
LOGFILE 'G:\oracle\Inact1\i...
Shutting down instance (immediate)
License high water mark = 1
archiving is disabled
ARCH: changing ARC0 KCRRACTIVE->KCRRSHUTDN
ARCH: sending ARC0 shutdown message
Thu Feb 28 16:23:21 2002
ARCH shutting down
ARC0: Archival stopped
ARC0: changing ARC0 KCRRSHUTDN->KCRRDEAD
Can anyone help?
