IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因

    惜分飞发表于 2024-03-21 12:40:53
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    最近接触过几个ORA-600 16703的恢复case,报错日志类似为:

    SMON: enabling cache recovery
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2071.trc  (incident=7357):
    ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], []
    Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_7357/orcl_ora_2071_i7357.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2071.trc:
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], []
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2071.trc:
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], []
    Error 704 happened during db open, shutting down database
    USER (ospid: 2071): terminating the instance due to error 704
    Instance terminated by USER, pid = 2071
    ORA-1092 signalled during: ALTER DATABASE OPEN...
    

    查看客户的日志,发现客户的库被人使用bbed按照网上的思路进行过恢复(使用block替换的方式尝试open库),结果报出来ORA-00600: internal error code, arguments: [16703], [1403], [4]之类的错误

    Wed Mar 20 22:00:39 2024
    SMON: enabling cache recovery
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_1840752.trc  (incident=62557):
    ORA-00600: internal error code, arguments: [16703], [1403], [4], [], [], [], [], [], [], [], [], []
    Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_62557/orcl_ora_1840752_i62557.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_1840752.trc:
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [16703], [1403], [4], [], [], [], [], [], [], [], [], []
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_1840752.trc:
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [16703], [1403], [4], [], [], [], [], [], [], [], [], []
    Error 704 happened during db open, shutting down database
    USER (ospid: 1840752): terminating the instance due to error 704
    Instance terminated by USER, pid = 1840752
    ORA-1092 signalled during: alter database open...
    

    其实ORA-600 16703 1403 N的错误,表示数据库在检索tab$表的时候,N为发现异常的obj#的值,这里的报错表示数据库在启动过程中无法检索到tab$中的tab$对象,应该是恢复过程中缺少该记录导致,解决问题的思路就是把该记录回写到tab$表中即可
    以前写过类似文章:ORA-00600: internal error code, arguments: [16703], [1403], [4] 故障处理

    • aix平台tab$被删除可能出现ORA-600 [16703], [1403], [28]错误
    • tab$异常被处理之后报ORA-600 13304故障处理
    • ORA-00600: internal error code, arguments: [16703], [1403], [32]
    • ORA-00600: internal error code, arguments: [16703], [1403], [4] 故障处理
    • 12C数据库遭遇ORA-600 16703
    • tab$恢复错误汇总
    • ora-600 2662和ora-600 kclchkblk_4恢复
    • ORA-00600 kcratr_scan_rc
    • ORA-600 kkdlcob-objn-exist 40
    • ORA-600 ksuloget2 恢复
    • 正常open库报ORA-600 2662,ORA-600 4097错误
    • 10g数据库遭遇ORA-600 16703


沪ICP备19023445号-2号
友情链接