今天重新导库查询业务单据发现查询不到任何数据,查看日志发现是数据库报错了,数据库版本为Oracle11.2.0.1.0,报错为: 内部错误代码, 参数: [19004], [], [], [], [], [], [], [], [], [], [], [],网上查了一下是Oracle的BUG,解决方案如下

ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], [], [], [], [], []_数据库

连接数据库服务器,使用DBA用户登录,执行execute dbms_stats.delete_schema_stats('数据库用户名');

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 14 21:54:18 2022

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>execute dbms_stats.delete_schema_stats('xtkf1114');

ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], [], [], [], [], []_sql_02

ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], [], [], [], [], []_oracle_03