Oracle Database Discussions

Hi,

I tried to creat a new database several times but it gives an above mentioned error.

I will appreciate your help to fix this issue on an urgent basis.

Thu Sep 28 15:12:12 2006
CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/u01/app/oracle/oradata/db1/undotbs3.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/u01/ap
Thu Sep 28 15:12:17 2006
create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Thu Sep 28 15:12:29 2006
Completed: create tablespace SYSAUX datafile '/u01/app/oracl
Thu Sep 28 15:12:29 2006
CREATE TEMPORARY TABLESPACE MKODOTEMP1 TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP1 TEMPFILE '
Thu Sep 28 15:12:30 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
Thu Sep 28 15:12:30 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Thu Sep 28 15:12:30 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
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 = 7169
ORA-1092 signalled during: CREATE DATABASE db1
USER SYS IDENTIFIED BY ***US...

The output or message from the trace file is as below:
/u01/app/oracle/admin/db1/udump/db1_ora_7169.trc
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: polo
Release: 2.6.11-1.1369_FC4smp
Version: #1 SMP Thu Jun 2 23:08:39 EDT 2005
Machine: i686
Instance name: db1
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 7169, image: oracle@polo (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2006-09-28 15:11:57.252
*** SESSION ID:(272.1) 2006-09-28 15:11:57.252
*** 2006-09-28 15:11:57.252
All processes have switched to database character set
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Assigned RBS 4 to pool 0
Undo Segment 4 Onlined
Assigned RBS 5 to pool 1
Undo Segment 5 Onlined
Assigned RBS 6 to pool 2
Undo Segment 6 Onlined
Assigned RBS 7 to pool 3
Undo Segment 7 Onlined
Assigned RBS 8 to pool 4
Undo Segment 8 Onlined
Assigned RBS 9 to pool 5
Undo Segment 9 Onlined
Assigned RBS 10 to pool 6
Undo Segment 10 Onlined
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6183
CREATE TABLESPACE MKODO1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name

Thanks in advance.
Jayesh
solankijayesh@yahoo.com