ITPub博客

首页 > 数据库 > Oracle > 遇到ora-00206

遇到ora-00206

原创 Oracle 作者:msdnchina 时间:2011-06-16 23:13:34 0 删除 编辑

Thu Jun 16 00:25:30 2011
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_ckpt_151720.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control03.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control02.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control01.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
Thu Jun 16 00:25:30 2011
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_ckpt_151720.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control03.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control02.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control01.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
Thu Jun 16 00:25:30 2011
CKPT: terminating instance due to error 221
Termination issued to instance processes. Waiting for the processes to exit
Thu Jun 16 00:25:40 2011
Instance termination failed to kill one or more processes
Instance terminated by CKPT, pid = 151720
Thu Jun 16 07:13:59 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.

值得注意的是ora00206不代表控制文件就损坏了。

还的看hba ,光纤线,光纤交换机,存储的连接上。

事后查明,这是光纤线结构松动导致的 oracle 无法写控制文件。

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-1051249/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ora-00327
下一篇: 增加LVM
请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1542478