ORA-00600: internal error code, arguments: [19004]

最新推荐文章于 2021-08-03 22:41:20 发布

最新推荐文章于 2021-08-03 22:41:20 发布 · 451 阅读

文章标签：

#数据库

本文详细介绍了如何解决在使用Oracle 11g应用时遇到的ORA-00600内部错误代码问题。包括检查数据库版本、执行特定工作流程和删除列直方图等步骤，最终问题得以解决。

Got an error from application.

Server Error in '/PSM/CSR' Application.

ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Oracle.DataAccess.Client.OracleException: ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []

Check the DB version:

select * from v$version;

It is 11.2.

It issaid that For oracle 10.2.0.3 install patch for BUG#5579764. The bug has been fixed in11g.

Follow instructions of Metalink Note 390249.1 and delete column histograms.

But it seems it did not fix on windows platform:

try the workaround providedfor oracle 10.2.0.3:

execute dbms_stats.delete_schema_stats('BUSINESSDATA');

It is resolved.