linux中oracle手工创建数据库出错，ORA-00604: error occurred at recursive SQL level ！alert如下！
Thu May 09 11:16:48 2013
ARC0 started with pid=20, OS id=2732
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /ora/oracle/oradata/yyh/redo01a.rdo
Current log# 1 seq# 1 mem# 1: /ora/oracle/oradata/yyh/redo01b.rdo
Successful open of redo thread 1
Thu May 09 11:16:49 2013
SMON: enabling cache recovery
Thu May 09 11:16:49 2013
ARC1 started with pid=21, OS id=2734
Thu May 09 11:16:49 2013
ARC2 started with pid=22, OS id=2736
Thu May 09 11:16:49 2013
processing ?/rdbms/admin/dcore.bsq
create tablespace SYSTEM datafile
'/ora/oradata/yyh/system01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL online
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thu May 09 11:16:50 2013
ARC3 started with pid=23, OS id=2738
ORA-1119 signalled during: create tablespace SYSTEM datafile
'/ora/oradata/yyh/system01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL online
...
Errors in file /ora/oracle/diag/rdbms/yyh/yyh/trace/yyh_ora_2658.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/ora/oradata/yyh/system01.dbf'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
Errors in file /ora/oracle/diag/rdbms/yyh/yyh/trace/yyh_ora_2658.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 27
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file '/ora/oradata/yyh/system01.dbf'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
Error 1519 happened during database creation, shutting down database
USER (ospid: 2658): terminating the instance due to error 1519
Instance terminated by USER, pid = 2658
ORA-1092 signalled during: CREATE DATABASE "yyh"
MAXDATAFILES 500
MAXINSTANCES 8
MAXLOGFILES 32
CHARACTER SET "UTF8"
NATIONAL CHARACTER SET AL16UTF16
SYSAUX DATAFILE '/ora/oracle/oradata/yyh/sysaux01.dbf' SIZE 300M
ARCHIVELOG
DATAFILE
'/ora/oradata/yyh/system01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/ora/oracle/yyh/tempts01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/ora/oracle/oradata/yyh/undotbs01.dbf' SIZE 200M
LOGFILE
GROUP 1 (
'/ora/oracle/oradata/yyh/redo01a.rdo',
'/ora/oracle/oradata/yyh/redo01b.rdo'
) SIZE 100M,
GROUP 2 (
'/ora/oracle/oradata/yyh/redo02a.rdo',
'/ora/oracle/oradata/yyh/redo02b.rdo'
) SIZE 100M,
GROUP 3 (
'/ora/oracle/oradata/yyh/redo03a.rdo',
'/ora/oracle/oradata/yyh/redo03b.rdo'
) SIZE 100M
...
opiodr aborting process unknown ospid (2658) as a result of ORA-1092
Thu May 09 11:16:51 2013
ORA-1092 : opitsk aborting process
帮忙看一下了，谢谢 Linux Oracle 数据库
[解决办法]
1、看下有没有这个目录 '/ora/oradata/yyh/'
2、看下上面的这个木有没有写的权限
3、打开跟踪日志看看什么错误 '/ora/oracle/diag/rdbms/yyh/yyh/trace/yyh_ora_2658.trc'
[解决办法]
