create database command fail, need suggestion
DBA2011Jun 16 2008 — edited Jun 16 2008this is tail of alertlog, what i am doing wrong? version 10202 on SunOS10
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oracle/oradata/dfct/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/oradata/dfct/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/oracle/oradata/dfct/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED...
Mon Jun 16 07:40:42 2008
CREATE DATABASE dfct
USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/oracle/oradata/dfct/redo01.log') SIZE 100M,
GROUP 2 ('/oracle/oradata/dfct/redo02.log') SIZE 100M,
GROUP 3 ('/oracle/oradata/dfct/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oracle/oradata/dfct/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oracle/oradata/dfct/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/oradata/dfct/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/oracle/oradata/dfct/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Mon Jun 16 07:40:42 2008
Database mounted in Exclusive Mode
Mon Jun 16 07:40:47 2008
Successful mount of redo thread 1, with mount id 2688685690
Assigning activation ID 2688685690 (0xa042167a)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oracle/oradata/dfct/redo01.log
Successful open of redo thread 1
Mon Jun 16 07:40:47 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 16 07:40:47 2008
SMON: enabling cache recovery
Mon Jun 16 07:40:47 2008
create tablespace SYSTEM datafile '/oracle/oradata/dfct/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL online
Mon Jun 16 07:40:49 2008
Completed: create tablespace SYSTEM datafile '/oracle/oradata/dfct/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL online
Mon Jun 16 07:40:49 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Mon Jun 16 07:40:53 2008
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oracle/oradata/dfct/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oracle/oradata/dfct/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Mon Jun 16 07:40:54 2008
create tablespace SYSAUX datafile '/oracle/oradata/dfct/sysaux01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Completed: create tablespace SYSAUX datafile '/oracle/oradata/dfct/sysaux01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Mon Jun 16 07:40:57 2008
CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE '/oracle/oradata/dfct/temp01.dbf'
SIZE 20M REUSE
Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE '/oracle/oradata/dfct/temp01.dbf'
SIZE 20M REUSE
Mon Jun 16 07:40:57 2008
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Mon Jun 16 07:40:57 2008
Errors in file /oracle/admin/dfct/udump/dfct_ora_28090.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Mon Jun 16 07:40:57 2008
Errors in file /oracle/admin/dfct/udump/dfct_ora_28090.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 28090
ORA-1092 signalled during: CREATE DATABASE dfct
USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE GROUP 1 ('/oracle/oradata/dfct/redo01.log') SIZE 100M,
GROUP 2 ('/oracle/oradata/dfct/redo02.log') SIZE 100M,
GROUP 3 ('/oracle/oradata/dfct/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oracle/oradata/dfct/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oracle/oradata/dfct/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oracle/oradata/dfct/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/oracle/oradata/dfct/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED...