Hello everyone,

I'm trying to create an oracle database manually using Create Database command.
I'm using 10g on Fedora Core 4.

Here is the command:

CREATE DATABASE testDb
USER SYS IDENTIFIED BY secrect
USER SYSTEM IDENTIFIED BY secret
LOGFILE GROUP 1 ('/u01/app/oracle/oraData/testDb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oraData/testDb/redo02.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oraData/testDb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oraData/testDb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE USERS
DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE UNDOTBS
DATAFILE '/u01/app/oracle/oraData/testDb/undo01.dbf' SIZE 200M REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED;


and here is the PFILE which I got it from the SPFILE that I'm using:

testDbInstanceSID.__db_cache_size=92274688
testDbInstanceSID.__java_pool_size=4194304
testDbInstanceSID.__large_pool_size=4194304
testDbInstanceSID.__shared_pool_size=62914560
testDbInstanceSID.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/testDb/adump'
*.background_dump_dest='/u01/app/oracle/admin/testDb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oraData/testDb/control01.ctl','/u01/app/oracle/oraData/testDb/control02.ctl','/u01/app/oracle/oraData/testDb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/testDb/cdump'
*.db_block_size=8192
*.db_domain='TestSys'
*.db_file_multiblock_read_count=16
*.db_name='testDb'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='/u01/app/oracle/admin/testDb/udump'


and the SID is "testDbInstanceSID"

So what I do is like this:


>sqlplus "/ as sysdba"
>startup nomount;
>@/home/oracle/dbCreateScript.sql

but I get this error in SqlPlus:

CREATE DATABASE testDb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

and when I check the alert log, I find this:

.....
Completed: create tablespace SYSAUX datafile '/u01/app/oracle/oraData/testDb/sysaux01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Sat May 6 16:02:31 2006
CREATE TEMPORARY TABLESPACE TEMPTBLSPC TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
UNIFORM SIZE 1048576
Completed: CREATE TEMPORARY TABLESPACE TEMPTBLSPC TEMPFILE '/u01/app/oracle/oraData/testDb/temp01.dbf' SIZE 200M
UNIFORM SIZE 1048576
Sat May 6 16:02:31 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTBLSPC
Sat May 6 16:02:31 2006
Errors in file /u01/app/oracle/admin/testDb/udump/testdbinstancesid_ora_14790.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Sat May 6 16:02:31 2006
Errors in file /u01/app/oracle/admin/testDb/udump/testdbinstancesid_ora_14790.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


which I don't really underestand. What is that about? It got to be something obvious.

Any Idea?

Thanks in advance