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

答案:4 悬赏:50 手机版

解决时间 2021-12-25 03:51

提问者网友：眉目添风霜
2021-12-24 14:06

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...

最佳答案

五星知识达人网友：污到你湿
2021-12-24 15:07

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

全部回答

1楼网友：野味小生
2021-12-24 16:37

临时表空间设置了码?

2楼网友：我住北渡口
2021-12-24 16:17

examine the alert log for more details. when the instance has been restarted, retry action.

3楼网友：旧脸谱
2021-12-24 15:12

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

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息