Re: error while manually creating database

You did read the following segment of the trace file carefully?

ORA-00604: error occurred at recursive SQL level 1 ORA-02236: invalid file name
Offending statement at line 6183
CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file
'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 6183 ORA-00604: error occurred at recursive SQL level 1 ORA-02236: invalid file name

Do you see a filename?

Am I right in assuming you didn't do any investigation of your own, and dumped the trace file to this forum right away?

FYI: This is a *volunteer* forum, NOT *Oracle Support*

On 23 Sep 2006 00:44:52 -0700, "radian7" <radian7_at_poczta.onet.pl> wrote:

>Hi
>
>I try manually create database in Oracle 10g on Windows XP prof.
>And I get following error:
>
>ERROR at line 1:
>ORA-01092: ORACLE instance terminated. Disconnection forced
>
>
>Udump trace file is following:
>
>Dump file e:\oracle\product\10.1.0\admin\test1\udump\orcl_ora_3400.trc
>Sat Sep 23 09:35:01 2006
>ORACLE V10.1.0.2.0 - Production vsnsta=0
>vsnsql=13 vsnxtr=3
>Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>With the Partitioning, OLAP and Data Mining options
>Windows XP Version V5.1 Dodatek Service Pack 2
>CPU : 1 - type 586
>Process Affinity: 0x00000000
>Memory (A/P) : PH:534M/1023M, PG:3473M/4022M, VA:1765M/2047M
>Instance name: orcl
>
>Redo thread mounted by this instance: 1
>
>Oracle process number: 12
>
>Windows thread id: 3400, image: ORACLE.EXE (SHAD)
>
>
>*** SERVICE NAME:(SYS$USERS) 2006-09-23 09:35:01.890
>*** SESSION ID:(162.1) 2006-09-23 09:35:01.890
>*** 2006-09-23 09:35:01.890
>All processes have switched to database character set
>*** 2006-09-23 09:35:20.078
>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 TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
>ORA-01501: CREATE DATABASE failed
>ORA-01519: error while processing file
>'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 6183
>ORA-00604: error occurred at recursive SQL level 1
>ORA-02236: invalid file name

--
Sybrand Bakker, Senior Oracle DBA