今天oracle数据库莫名其妙地出现登录后执行报“通信通道的文件结束错误处理”的错误,同时搞了几天没搞好,交给我来处理,也是挺头晕的。
通过多次的调试最后锁定在执行分页SQL语句时候会报03113的错误,于是修改分页SQL语句,基本上能尝试的都尝试了。最后还是无动于衷,
该报错的地方还是报错。
ora-03113 通信通道的文件结束错误处理
编辑D:/oracle/ora92/network/admin/sqlnet.ora文件,将LNET.AUTHENTICATION_SERVICES= (MTC)或者SQLNET.AUTHENTICATION_SERVICES= (NTS)修改为NET.AUTHENTICATION_SERVICES= (NONE).
当日志中出现:
Mon Oct 26 17:18:08 2009
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_1676.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kglLockCursor+279] [PC:0x3FE9971] [ADDR:0xB8458B4E] [UNABLE_TO_READ] []
Mon Oct 26 17:18:08 2009
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_1676.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kglLockCursor+279] [PC:0x3FE9971] [ADDR:0xB8458B4E] [UNABLE_TO_READ]