手工建库

RomanHeart

oracle 10g 手工建的时候,会有这样的情况:
           指定log 位置会报错,为什么呢?

RomanHeart

ORA-01092: ORACLE 实例终止。强制断开连接
ORA-00447: fatal error in background process
ORA-01519: error while processing file '' near line
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 5253 ???
ORA-00604: ?? SQL ?? 2 ????
ORA-00942: ???????

建立数据库时用如下语句 :
create database base
maxlogfiles 30
maxlogmembers 3
maxinstances 8
maxdatafiles 60
maxloghistory 100
logfile
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
datafile 'f:\sysbase.dbf' size 10m
sysaux datafile 'f:\auxbase.dbf' size 10m
undo tablespace UNDOTBS1 datafile 'f:\undobase.dbf' size 10m
/

RomanHeart

datafile 没问题
当有这段logfile
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
时会有错,拿掉就没有错