数据库无法启动,错误如下,在线等待,高分!!!分不够再加! 大哥,我不知道有没有metalink的账号(你的oracle最终用户应该有),去哪里查吧。这个错误不是SQL可以解决的。可能要靠打补丁来做 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你的alter log中都有些啥错误,贴出来另,你是从未启动起来过数据库,还是后来启动不了的? 那你调整过什么吗?我记得好像在oracle9.0.1中调整db_files会有这个问题。 Tue Feb 11 17:38:54 2003Shutting down instance (abort)Wed Mar 26 16:16:13 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_9772.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824Wed Mar 26 16:28:35 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_10026.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorLinux Error: 25: Inappropriate ioctl for deviceAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorLinux Error: 25: Inappropriate ioctl for deviceAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorLinux Error: 25: Inappropriate ioctl for deviceAdditional information: 213760Wed Mar 26 16:35:10 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_8696.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824Thu Mar 27 08:48:39 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1367.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824Thu Mar 27 09:05:02 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1814.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760Thu Mar 27 09:07:11 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1834.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824ORA-01114: IO error writing block to file 201 (block # 213825)ORA-27072: skgfdisp: I/O errorAdditional information: 213824Thu Mar 27 09:09:09 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1852.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760ORA-01114: IO error writing block to file 201 (block # 213761)ORA-27072: skgfdisp: I/O errorAdditional information: 213760Sat Mar 29 19:09:42 2003Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_2324.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-01114: IO error writing block to file 201 (block # 170177)ORA-27072: skgfdisp: I/O errorLinux Error: 28: No space left on deviceAdditional information: 170176ORA-01114: IO error writing block to file 201 (block # 170177)ORA-27072: skgfdisp: I/O errorLinux Error: 28: No space left on deviceAdditional information: 170176ORA-01114: IO error writing block to file 201 (block # 170177)ORA-27072: skgfdisp: I/O errorLinux Error: 28: No space left on deviceAdditional information: 170176Mon Apr 7 09:33:37 2003Shutting down instance (abort)由于数据库断电造成的这种错误! oracle9i_ora_9772.trc里应该有相应的信息,好象是数据块损坏了。 查看一下Track文件,知道那个文件错了,然后startup mountrecover datafile '' ORA-00600 ,oracle很经典的错误。我遇到过几次了。如果你没有买ORACLE的服务话,就重建数据库吧,要等待解决是不现实的了。 oracle数据库,导出某个user的所有数据 问2个问题,在线等,,急急 怎么写出易懂的注释 接昨晚登录问题? oracle 查询求助!! 如何使用SQL Loader导入日期类型 在oracle下如何用一个表更新另一个表? 递归查询的sql语句如何写? 简单命令问题 简单类型问题,送分。100 存储过程返回的值应该怎么取得? 请问有没有将一个值转换成浮点类型的函数,类似to_number()之类的
另,你是从未启动起来过数据库,还是后来启动不了的?
我记得好像在oracle9.0.1中调整db_files会有这个问题。
Shutting down instance (abort)
Wed Mar 26 16:16:13 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_9772.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
Wed Mar 26 16:28:35 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_10026.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Linux Error: 25: Inappropriate ioctl for device
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Linux Error: 25: Inappropriate ioctl for device
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Linux Error: 25: Inappropriate ioctl for device
Additional information: 213760
Wed Mar 26 16:35:10 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_8696.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
Thu Mar 27 08:48:39 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1367.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
Thu Mar 27 09:05:02 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1814.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
Thu Mar 27 09:07:11 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1834.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
ORA-01114: IO error writing block to file 201 (block # 213825)
ORA-27072: skgfdisp: I/O error
Additional information: 213824
Thu Mar 27 09:09:09 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_1852.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
ORA-01114: IO error writing block to file 201 (block # 213761)
ORA-27072: skgfdisp: I/O error
Additional information: 213760
Sat Mar 29 19:09:42 2003
Errors in file /opt/oracle/admin/oracle9i/udump/oracle9i_ora_2324.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 170177)
ORA-27072: skgfdisp: I/O error
Linux Error: 28: No space left on device
Additional information: 170176
ORA-01114: IO error writing block to file 201 (block # 170177)
ORA-27072: skgfdisp: I/O error
Linux Error: 28: No space left on device
Additional information: 170176
ORA-01114: IO error writing block to file 201 (block # 170177)
ORA-27072: skgfdisp: I/O error
Linux Error: 28: No space left on device
Additional information: 170176
Mon Apr 7 09:33:37 2003
Shutting down instance (abort)
由于数据库断电造成的这种错误!
startup mount
recover datafile ''
如果你没有买ORACLE的服务话,就重建数据库吧,要等待解决是不现实的了。