ORA-00202错误是Oracle数据库中的一个常见错误,以下是对该错误的详细解答: 1. ORA-00202错误的含义 ORA-00202错误表示“控制文件: ''”,通常伴随着一个具体的控制文件路径。这个错误表明Oracle数据库在尝试打开或访问指定的控制文件时遇到了问题。控制文件是Oracle数据库的关键文件之一,它包含了数据库的结构和状态信...
1、发现数据库宕机,检查alert日志发现如下出现控制文件:I/O错误 Thu Apr 11 06:40:14 2019WARNING: Read Failed. group:2 disk:1 AU:675 offset:16384 size:16384WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 260 in group [2.3852408873] from disk DATA_0001 a...
Errors in file /u01/app/oracle/diag/rdbms/jsswgsjk/jsswgsjk1/trace/jsswgsjk1_ckpt_93628.trc: ORA-00202: control file: '+DATA/jsswgsjk/controlfile/current.260.998936297' ORA-15081: failed to submit an I/O operation to a disk ORA-27072: File I/O error Linux-x86_64 Error: 5: Input/o...
Errors in file /u01/app/oracle/diag/rdbms/jsswgsjk/jsswgsjk1/trace/jsswgsjk1_ckpt_93628.trc: ORA-00202: control file: '+DATA/jsswgsjk/controlfile/current.260.998936297' ORA-15081: failed to submit an I/O operation to a disk ORA-27072: File I/O error Linux-x86_64 Error: 5: Input/o...
ORA-00202: control file: '+DATA/jsswgsjk/controlfile/current.260.998936297'ORA-15081: failed to submit an I/O operation to a diskORA-27072: File I/O errorLinux-x86_64 Error: 5: Input/output errorAdditional information: 4Additional information: 1382432Additional information: -1Thu Apr 11 06:...
ORA-00205: error in identifying control file, check alert log for more info 查看alert日志内容如下:ALTER DATABASE MOUNT ORA-00210: cannot open the specified control file ORA-00202: control file: '/opt/oracle/oradata/mrad/sys03/control03.ctl' ORA-27086: unable to lock file - already in ...
ORA-00202: control file: '/data/orcl/control02.ctl' ORA-27072: File I/O error 说明:ora-00206告警并不一定标识控制文件损坏.hba 、光纤线、光纤交换机、存储连接都也会导致此异常. 参考文档: MOS【Doc ID 1073745.1】 2. 3. 5. 6. 7.
ORA-00202: control file: '+DATA/jsswgsjk/controlfile/current.260.998936297' ORA-15081: failed to submit an I/O operation to a disk ORA-27072: File I/O error Linux-x86_64 Error: 5: Input/output error Additional information: 4 Additional information: 1382432 ...
ORA-00202: control file: '+DATA/healdg/controlfile/control01.ctl' ORA-15081: failed to submit an I/O operation to a disk 异常原因: 报警提示很明显,缺少访问磁盘组的权限. 解决过程: 通过查询资料了解到很可能与?/bin/oracle权限有关.
两个节点只能同时open一个节点,启动另一个节点时报错,不能访问磁盘组,ORA-00204 ORA-00202 ORA-15081 并且在实例trace日志中有报错ORA-01565 故障分析: 1、安装时出现过ASM共享磁盘告警 2、两个节点同时用DD命令去写入正常 3、记录之前看过高斌的RAC核心技术书籍有记录交代了ASM访问属组关系 ...