Question

手动创建oracle数据库时弹出“ORA-01092: ORACLE 实例终止。强制断开连接”下面是日志文件，请高手帮忙

Wed Jun 15 23:06:32 2011
Completed: create tablespace SYSTEM datafile 'C:\oracle\orad
Wed Jun 15 23:06:32 2011
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM

Wed Jun 15 23:06:34 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\udump\zlz_ora_3056.trc:
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????

Wed Jun 15 23:06:34 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\udump\zlz_ora_3056.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 2356 ???
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_reco_3132.trc:
ORA-01519: ????? '' ???? ???

Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_smon_3184.trc:
ORA-01519: ????? '' ???? ???

Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_ckpt_3124.trc:
ORA-01519: ????? '' ???? ???

Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_lgwr_756.trc:
ORA-01519: ????? '' ???? ???

Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_dbw0_3492.trc:
ORA-01519: ????? '' ???? ???

Wed Jun 15 23:06:35 2011
Errors in file c:\oracle\product\10.1.0\admin\zlz\bdump\zlz_mman_3116.trc:
ORA-01519: ????? '' ???? ???

Instance terminated by USER, pid = 3056
ORA-1092 signalled during: CREATE DATABASE "zlz"
MAXINSTANCES 8
MAXLOGHISTORY...

Answer 1

你这些显示的文件夹路径有没有在物理磁盤上创建呢？还有就是你用init.ora文件创建的pfile里需要修改几个地方，例如数据库名，添加控制文件等。
另外建议你改变一下语言，这样错误容易看懂。
alter session set nls_language=american;

Answer 2

Errors in file c:\oracle\product\10.1.0\admin\zlz\udump\zlz_ora_3056.trc:
ORA-00604: ?? SQL ?? 1 ????
ORA-00988: ???????
跟踪文件错误，IO问题，你看下操作系统或者磁盘有什么故障

Answer 3

检查建库脚本，里面的路径在你的物理磁盘上是不是有真实的存在。

Answer 4

临时表空间设置了码?