Oracle11g 手工建库时报错！求帮忙！很急！

[WO浣熊OW]

Oracle11g 手工建库
当执行建库脚本时报错：



建库脚本：
create database tian
datafile 'D:\app\NDC002\oradata\tian\system01.dbf' size 300m autoextend on next 10m extent management local
sysaux datafile 'D:\app\NDC002\oradata\tian\sysaux01.dbf' size 120 undo tablespace undotbs01
datafile 'D:\app\NDC002\oradata\tian\undotbs01.dbf' size 100m default temporary tablespace temptbs01
tempfile 'D:\app\NDC002\oradata\tian\temptbs01' size 50m
logfile group 1 ('D:\app\NDC002\oradata\tian\redo01.log') size 50m,
group 2 ('D:\app\NDC002\oradata\tian\redo02.log') size 50m,
group 3 ('D:\app\NDC002\oradata\tian\redo03.log') size 50m;

请问怎么解决啊？很急！

[惜分飞]

为什么不使用dbca？

[WO浣熊OW]

alert.log的内容如下： Thu Oct 10 11:28:47 2013 create database tian datafile 'D:\app\XXXXXX\oradata\tian\system01.dbf' size 300m autoextend on next 10m extent management local sysaux datafile 'D:\app\XXXXXX\oradata\tian\sysaux01.dbf' size 120 undo tablespace undotbs1 datafile 'D:\app\XXXXXX\oradata\tian\undotbs01.dbf' size 100m default temporary tablespace temptbs1 tempfile 'D:\app\XXXXXX\oradata\tian\temp01' size 50m logfile group 1 ('D:\app\XXXXXX\oradata\tian\redo01.log') size 50m, group 2 ('D:\app\XXXXXX\oradata\tian\redo02.log') size 50m, group 3 ('D:\app\XXXXXX\oradata\tian\redo03.log') size 50m Database mounted in Exclusive Mode Lost write protection disabled Thu Oct 10 11:28:54 2013 Successful mount of redo thread 1, with mount id 1536593519 Assigning activation ID 1536593519 (0x5b968e6f) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: D:\APP\XXXXXX\ORADATA\TIAN\REDO01.LOG Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Oct 10 11:28:54 2013 SMON: enabling cache recovery processing %ORACLE_HOME%\RDBMS\ADMIN\dcore.bsq create tablespace SYSTEM datafile 'D:\app\XXXXXX\oradata\tian\system01.dbf' size 300m autoextend on next 10m EXTENT MANAGEMENT LOCAL online Thu Oct 10 11:29:03 2013 Completed: create tablespace SYSTEM datafile 'D:\app\XXXXXX\oradata\tian\system01.dbf' size 300m autoextend on next 10m EXTENT MANAGEMENT LOCAL online create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) processing %ORACLE_HOME%\RDBMS\ADMIN\dsqlddl.bsq processing %ORACLE_HOME%\RDBMS\ADMIN\dmanage.bsq CREATE TABLESPACE sysaux DATAFILE 'D:\app\XXXXXX\oradata\tian\sysaux01.dbf' size 120 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE ORA-3214 signalled during: CREATE TABLESPACE sysaux DATAFILE 'D:\app\XXXXXX\oradata\tian\sysaux01.dbf' size 120 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE ... Errors in file d:\app\XXXXXX\diag\rdbms\tian\tian\trace\tian_ora_1116.trc: ORA-00604: ?? SQL ?? 1 ???? ORA-03214: ??????????????? Errors in file d:\app\XXXXXX\diag\rdbms\tian\tian\trace\tian_ora_1116.trc: ORA-01501: CREATE DATABASE ?? ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\dmanage.bsq' ???? 17 ??? ORA-00604: ?? SQL ?? 1 ???? ORA-03214: ??????????????? Error 1519 happened during database creation, shutting down database USER (ospid: 1116): terminating the instance due to error 1519 Instance terminated by USER, pid = 1116 ORA-1092 signalled during: create database tian datafile 'D:\app\XXXXXX\oradata\tian\system01.dbf' size 300m autoextend on next 10m extent management local sysaux datafile 'D:\app\XXXXXX\oradata\tian\sysaux01.dbf' size 120 undo tablespace undotbs1 datafile 'D:\app\XXXXXX\oradata\tian\undotbs01.dbf' size 100m default temporary tablespace temptbs1 tempfile 'D:\app\XXXXXX\oradata\tian\temp01' size 50m logfile group 1 ('D:\app\XXXXXX\oradata\tian\redo01.log') size 50m, group 2 ('D:\app\XXXXXX\oradata\tian\redo02.log') size 50m, group 3 ('D:\app\XXXXXX\oradata\tian\redo03.log') size 50m... opiodr aborting process unknown ospid (1116) as a result of ORA-1092 Thu Oct 10 11:29:08 2013 ORA-1092 : opitsk aborting process

[WO浣熊OW]

引用 1 楼 xifenfei 的回复:

为什么不使用dbca？

已经用过了，想尝试一下手工建库，据说理解了手工建库的过程，就能理解Oracle。可是我现在一点也不理解

[WO浣熊OW]

问题已经解决了，是建库脚本的SQL语句写错了，惭愧～～～～ 改完之后的脚本如下： create database tian datafile 'D:\app\NDC002\oradata\tian\system01.dbf' size 300m autoextend on next 10m extent management local sysaux datafile 'D:\app\NDC002\oradata\tian\sysaux01.dbf' size 120m undo tablespace undotbs1 datafile 'D:\app\NDC002\oradata\tian\undotbs01.dbf' size 100m default temporary tablespace temptbs1 tempfile 'D:\app\NDC002\oradata\tian\temp01' size 50m logfile group 1 ('D:\app\NDC002\oradata\tian\redo01.log') size 50m, group 2 ('D:\app\NDC002\oradata\tian\redo02.log') size 50m, group 3 ('D:\app\NDC002\oradata\tian\redo03.log') size 50m;