Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create database command fail, need suggestion

DBA2011Jun 16 2008 — edited Jun 16 2008
this 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2008
Added on Jun 16 2008
4 comments
2,228 views