ORA-00600: internal error code, arguments: [4137]/ [4136]

最新推荐文章于 2024-07-31 10:17:32 发布

24号信仰

最新推荐文章于 2024-07-31 10:17:32 发布

阅读量5.7k

点赞数

分类专栏：【ORACLE知识库】文章标签： ORA-00600: internal error code ORA-00600 undo 实例反复重启 11.2.0.4

本文链接：https://blog.csdn.net/Skybig1988/article/details/81336954

版权

这篇博客详细描述了如何处理Oracle数据库11.2.0.4版本中遇到的ORA-00600错误，该错误通常与undo段有关。作者提供了备份参数文件、手动管理undo表空间、离线损坏回滚段等步骤来解决反复重启的问题。通过修改参数文件并启动数据库，然后检查和修复回退段状态，为遇到类似问题的数据库管理员提供了实用的解决方案。

摘要由CSDN通过智能技术生成

现象描述：

xx系统oracle数据库11.2.0.4 反复重启：

后台日志报错如下：

SMON: enabling cache recovery
Undo initialization finished serial:0 start:173950654 end:173950754 diff:100 (1 seconds)
                                                                                                                                                                                          75589,1       98%
SMON: enabling cache recovery
Undo initialization finished serial:0 start:173950654 end:173950754 diff:100 (1 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8ISO8859P1
Errors in file /oracle/db/diag/rdbms/sjxthx/sjxthx/trace/sjxthx_smon_30481.trc  (incident=516251):
ORA-00600: internal error code, arguments: [4137], [14.5.6274], [0], [0], [], [], [], [], [], [], [], []
Incident details in: /oracle/db/diag/rdbms/sjxthx/sjxthx/incident/incdir_516251/sjxthx_smon_30481_i516251.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
No Resource Manager plan active
ORACLE Instance sjxthx (pid = 13) - Error 600 encountered while recovering transaction (14, 5).
Errors in file /oracle/db/diag/rdbms/sjxthx/sjxthx/trace/sjxthx_smon_30481.trc:
ORA-00600: internal error code, arguments: [4137], [14.5.6274], [0], [0], [], [], [], [], [], [], [], []
Mon Nov 13 15:53:46 2017
Sweep [inc][516251]: completed
Mon Nov 13 15:53:47 2017
Dumping diagnostic data in directory=[cdmp_20171113155347], requested by (instance=1, osid=30481 (SMON)), summary=[incident=516251].
replication_dependency_tracking turned off (no async multimaster replication found)
Errors in file /oracle/db/diag/rdbms/sjxthx/sjxthx/trace/sjxthx_smon_30481.trc  (incident=516252):
ORA-00600: internal error code, arguments: [4137], [14.5.6274], [0], [0], [], [], [], [], [], [], [], []
Incident details in: /oracle/db/diag/rdbms/sjxthx/sjxthx/incident/incdir_516252/sjxthx_smon_30481_i516252.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Nov 13 15:53:47 2017
Errors in file /oracle/db/diag/rdbms/sjxthx/sjxthx