ora-00600 内部错误代码参数 4415

最新推荐文章于 2024-06-19 23:41:26 发布

女侠客啊

最新推荐文章于 2024-06-19 23:41:26 发布

阅读量905

点赞数

本文链接：https://blog.csdn.net/ffuygggh/article/details/84025527

版权

本文详细记录了一起在Oracle 11g环境中遇到的ORA-00600 内部错误代码 4415 的问题。错误发生在物理数据保护的数据库上，尽管数据库仍能正常服务，但触发了错误。分析显示该问题是由于在主库上通过db-link访问standby库的同义词并执行了rollback操作，而read only的standby库不支持事务操作。故障对数据库影响较小，可能是由于Oracle的已知bug 9531380导致，该bug在11.2.0.3及更高版本中已修复。

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

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

author：skate
time：2011/12/01

环境：
os：CentOS release 5.5
db: 11.2.0.2.0 - 64bit Production
physical dataguard

现象：只是报ora-00600: 内部错误代码, 参数: [4415]；数据库还是可以正常提供服务

诊断：
这套oracle11g的DG已经运行一段时间了，在调整了些小问题后，目前运行还是比较稳定，今天
在primary库收到报警，在alertlog里的错误信息如下：

Wed Nov 30 17:58:28 2011
Archived Log entry 1547 added for thread 1 sequence 7842 ID 0xa47b04d0 dest 1:
Wed Nov 30 18:21:33 2011
Media Recovery Waiting for thread 1 sequence 7844
Wed Nov 30 18:21:34 2011
RFS[5]: Selected log 7 for thread 1 sequence 7844 dbid -1535431216 branch 760042576
Recovery of Online Redo Log: Thread 1 Group 7 Seq 7844 Reading mem 0
Mem# 0: /oracle/oradata/skatedb/sdbyredo07.log
Wed Nov 30 18:21:41 2011
Archived Log entry 1548 added for thread 1 sequence 7843 ID 0xa47b04d0 dest 1:
Wed Nov 30 18:28:20 2011
Errors in file /oracle/app/diag/rdbms/skate03/skatedb/trace/skatedb_ora_31048.trc (incident=56617):
ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56617/skatedb_ora_31048_i56617.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
System State dumped to trace file /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56617/skatedb_ora_31048_i56617.trc
Wed Nov 30 18:29:19 2011
Dumping diagnostic data in directory=[cdmp_20111130182919], requested by (instance=1, osid=31048), summary=[incident=56617].
Wed Nov 30 18:29:25 2011
Errors in file /oracle/app/diag/rdbms/skate03/skatedb/trace/skatedb_ora_31048.trc (incident=56618):
ora-00603: ORACLE 服务器会话因致命错误而终止
ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/skate03/skatedb/incident/incdir_56618/skatedb_ora_31048_i56618.trc
Dumping diagnostic data in directory=[cdmp_20111130182926], requested by (instance=1, osid=31048), summary=[incident=56618].
opiodr aborting process unknown ospid (31048) as a result of ora-603
Wed Nov 30 18:29:29 2011
Sweep [inc][56618]: completed
Sweep [inc][56617]: completed
Sweep [inc2][56618]: completed
Sweep [inc2][56617]: completed
Wed Nov 30 18:44:01 2011
RFS[5