In this Document
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 06-May-2013***
SYMPTOMS
Any of below two symptoms are seen:
MMAN terminates instance after receiving ORA-600 [17074] in the alert.log:
Thu Sep 08 12:15:44 2011
Errors in file /opt/oracle/POLNSRB8/diag/rdbms/polnsrb8/POLNSRB8/trace/POLNSRB8_mman_22472.trc (incident=544073):
ORA-00600: internal error code, arguments: [17074], [0x0EE948A18], [0x110352750], [4], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/POLNSRB8/diag/rdbms/polnsrb8/POLNSRB8/incident/incdir_544073/POLNSRB8_mman_22472_i544073.trc
Errors in file /opt/oracle/POLNSRB8/diag/rdbms/polnsrb8/POLNSRB8/trace/POLNSRB8_mman_22472.trc:
ORA-00600: internal error code, arguments: [17074], [0x0EE948A18], [0x110352750], [4], [], [], [], [], [], [], [], []
MMAN (ospid: 22472): terminating the instance due to error 822
Instance terminated by MMAN, pid = 22472
with a call stack trace looking similar to:
kgesic3 kglhpd kghfrx kghrecr_quiesce kghquiesce_regular_ extent
- OR -
MMAN terminates instance after receiving ORA-600 [kglhpd-bad-free] in the alert.log:
Wed Sep 28 08:07:12 2011
Errors in file /arpsysc2/oracle/11.2.0/admin/arpsysc2_arpsysc2/diag/rdbms/arpsysc2/arpsysc2/trace/arpsysc2_mman_21666.trc (incident=48275):
ORA-00600: internal error code, arguments: [kglhpd-bad-free], [0x3A9CEBD50], [], [], [], [], [], [], [], [], [], []
Incident details in: /arpsysc2/oracle/11.2.0/admin/arpsysc2_arpsysc2/diag/rdbms/arpsysc2/arpsysc2/incident/incdir_48275/arpsysc2_mman_21666_i48275.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /arpsysc2/oracle/11.2.0/admin/arpsysc2_arpsysc2/diag/rdbms/arpsysc2/arpsysc2/trace/arpsysc2_mman_21666.trc:
ORA-00600: internal error code, arguments: [kglhpd-bad-free], [0x3A9CEBD50], [], [], [], [], [], [], [], [], [], []
MMAN (ospid: 21666): terminating the instance due to error 822
Wed Sep 28 08:07:14 2011
System state dump requested by (instance=1, osid=21666 (MMAN)), summary=[abnormal instance termination].
System State dumped to trace file /arpsysc2/oracle/11.2.0/admin/arpsysc2_arpsysc2/diag/rdbms/arpsysc2/arpsysc2/trace/arpsysc2_diag_21660.trc
Instance terminated by MMAN, pid = 21666
Wed Sep 28 08:34:26 2011
Starting ORACLE instance (normal)
with a call stack similar to:
kghrecr_quiesce <- kghquiesce_regular_extent <- kgh_next_free <- extent <- ksmc_next_free <- kmgs_extract_mem_from_granule <- kmgs_check_inuse_lists
<- kmgsdrv <- sts <- ksbcti <- ksbabs <- ksbrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- start
CAUSE
The problem is caused by Bug:9795214:DATABASE INSTANCE CRASHED DUE ORA-00600 [17074], ORA-822MMAN
Bug 9795214 is fixed in PSU 11.1.0.7.7, PSU 11.2.0.2.4, 11.2.0.3 and 12.1.
SOLUTION
To implement a solution for Bug:9795214, please consider any of below alternative solutions:
- On RDBMS release 11.1, the preferred solution is to apply patchset 11.1.0.7 and PSU 11.1.0.7.7 or above.
- OR -
- On RDBMS release 11.2, apply PSU 11.2.0.2.4 or patchset 11.2.0.3
- OR -
- On Windows, install 11.2.0.1 patchbundle 12 or higher
- OR -
- On Windows, install 11.2.0.2 patchbundle 08 or higher
- OR -
- Check for the availability of one-off Patch:9795214 for your platform and RDBMS release on MOS.
To check for conflicting patches, please use the MOS Patch Planner Tool
There is no known workaround available for the problem.