联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
今天早上例行对各个区域数据库服务器进行检查,发现内蒙古电信的数据库服务器出现ORA-600 [12235]错误
一、错误现象
alert_txzldb.log日志: Sun Nov 6 09:34:57 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_8253.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] txzldb_ora_8253.trc内容: Oracle program name: oracle@database.localdomain *** 2011-11-06 09:34:57.530 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] Current SQL information unavailable - no session. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 0 ? 0 ? ksfdmp()+14 call ksedmp()+0 3 ? BFFFECA0 ? 98584A4 ? AD58F60 ? 3 ? A4B929C ? kgeriv()+188 call ksfdmp()+0 AD58F60 ? 3 ? kgesiv()+113 call kgeriv()+0 AD58F60 ? 0 ? 2FCB ? 0 ? BFFFED0C ? ksesic0()+39 call kgesiv()+0 AD58F60 ? 0 ? 2FCB ? 0 ? BFFFED0C ? 2FCB ? 0 ? BFFFED0C ? opirip()+519 call ksesic0()+0 2FCB ? AD5903C ? BFFFF6AC ? FFFFFFFF ? BFFFF814 ? 1 ? opidrv()+462 call opirip()+0 32 ? 0 ? 0 ? sou2o()+25 call opidrv()+0 32 ? 0 ? 0 ? main()+355 call sou2o()+0 BFFFF814 ? 32 ? 0 ? 0 ? BFFFF840 ? 0 ? __libc_start_main() call main()+0 1 ? BFFFF894 ? BFFFF89C ? +161 96DFD4 ? 1 ? 8208E40 ? --------------------- Binary Stack Dump --------------------- ========== FRAME [1] (ksedmp()+269 -> ksedst()+0) ========== Dump of memory from 0xBFFFEB64 to 0xBFFFEC64 BFFFEB60 BFFFEC64 0820B6F8 00000000 [d..... .....] BFFFEB70 00000000 00000000 00000000 00000000 [................] Repeat 2 times ………………
二、数据库版本
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Linux: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production
三、mos信息
根据mos的建议,这个错误可以忽略,不用过多关注
ORA-600 [12235] "Oracle process has no purpose in life !" [ID 33174.1] ERROR: ORA-600 [12235] [a] [b] [/c] [d] [e] VERSIONS: versions 7.0 to 9.2 DESCRIPTION: This error shows up when Oracle detects an Oracle defunct process. When an Oracle process starts up, it reads data from the SGA that defines what type of process it should become. If the process does not locate any valid customization data, it reports ORA-600 [12235] and exits. On a heavily loaded system, ORA-600 [12235] may be a symptom that the server process was too slow in starting. That is, the process that initiated the new server may timeout waiting for the new process to start and abandon the new server request. In the new server process it is possible that the new server reaches the code to customize its operation before the os request to kill the process is actioned. The messages "ksbsrv: No startup acknowledgement from forked process ..." and "Timed out trying to start shared server ..." may be reported to trace and alert files. SUGGESTIONS: Ignore the error. One of the most common reasons for this error to be reported is that someone typed 'oracle' manually at the OS prompt. If this error is reported regularly and appears not to be explained by comments made in this note, contact Oracle Support Services.
四、错误重现
根据mos中的讲述,在系统级别执行oracle,也会出现该错误提示,使用oracle重现结果
[oracle@database ~]$ oracle [oracle@database ~]$ oracle [oracle@database ~]$ tail $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log Mon Nov 7 11:10:25 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_27108.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] Mon Nov 7 11:10:27 2011 Errors in file /opt/oracle/admin/txzldb/bdump/txzldb_ora_1281.trc: ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []