适用范围

  
  
  

   
   
   Oracle Database - Enterprise Edition - Version 11.2.0.4
  
  
  

问题概述

  
  
  

   
   
   ORA-00600: internal error code, arguments: [16703], [1403], [20]
  
  
  

问题原因

  
  
  

   
   
   1). 非官方途径下载的数据库软件2). 破解版plsql/toad运维工具数据库软件被注入恶意代码，定期删除数据库基表 tab$
  
  
  

解决方案

  
  
  

   
   
   ### 1. delete boorstrap i_tab1startup mountset linesize 200 pagesize 9999col name for a60select file#,name from v$datafile_header where ts#=0 order by file# asc;shutdown abortcat listfile.txtset dba 1,523p *kdbr[9]x /rnncm /x 3c offset 4910assign kdbh.kdbhavsp=3722assign kdbh.kdbhtosp=3724sum apply vp *kdbr[9]x /rnnc### 2. undel tab[[email protected] xdul]# cat control.txt /oradata/orcl/system01.dbf/oradata/orcl/system02.dbf/oradata/orcl/system03.dbf[[email protected] xdul]# ./xdulXDUL>undel tabdbv file=/oradata/orcl/system01.dbfdbv file=/oradata/orcl/system02.dbfdbv file=/oradata/orcl/system03.dbf### 3. open db### 禁用trigger参数*._system_trig_enabled=false*.job_queue_processes=0sqlplus / as sysdbaSQL> startup pfile='/home/oracle/pfile.ora'ORACLE instance started.Total System Global Area 3123322880 bytesFixed Size 2257312 bytesVariable Size 721423968 bytesDatabase Buffers 2382364672 bytesRedo Buffers 17276928 bytesDatabase mounted.Database opened.SQL>drop procedure DBMS_SUPPORT_DBMONITORP;drop trigger DBMS_SUPPORT_DBMONITOR;drop PACKAGE DBMS_SUPPORT;replace $ORACLE_HOME/rdbms/admin/prvtsupp.plbselect obj#,dataobj#,owner#,name from obj$ where name like 'ORACHK%';insert into tab$ select * from (select * from ORACHK2BE4B6ABB3416B12BE4B6AB where obj# in (select obj# from ORACHK2BE4B6ABB3416B12BE4B6AB where obj#<>23750 minus select obj# from tab$));
  
  
  

参考文档

  
  
  

   
   
   ### 数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复https://www.modb.pro/db/19154