作者: Maclean Liu, post on December 7th, 2010 一套AIX上的9.2.0.6 RAC系统，alert日志中最初报LMS进程(Lock Manager Server process，即锁服务管理进程，仅出现在RAC系统中)遭遇ORA-00600[kclchkinteg_2]，继而出现ORA-00600[[kjmsm_epc]内部错误导致实例crash(instance crashed)。相关日志如下:
Tue Dec 1 01:20:25 2009 Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc: ORA-00600: internal error code, arguments: [kclchkinteg_2], [], [], [], [], [], [], [] Tue Dec 1 01:20:25 2009 Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc: ORA-00600: internal error code, arguments: [kclchkinteg_2], [], [], [], [], [], [], [] Tue Dec 1 01:20:26 2009 . . . → Read More: ORA-00600:[kclchkinteg_2]及[kjmsm_epc]内部错误一例
作者: Maclean Liu, post on November 29th, 2010 一套HP-UX上的10.2.0.4系统在运行某条 select查询语句时出现ORA-00600[kkocxj:pjpCtx]内部错误，TRACE文件信息如下：
FILE VERSION —————— Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /oracle/app/oracle/product/10.2 System name: HP-UX Node name: crmdb1 Release: B.11.31 Version: U Machine: ia64 Instance name: cbssnm Redo thread mounted by this instance: 1 TRACE FILE ————— Filename . . . → Read More: ora-00600[kkocxj:pjpCtx]内部错误一例
作者: Maclean Liu, post on November 1st, 2010 一套windows上的11.1.0.7系统，用户在查询时出现ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], [], [], [], []错误如下:
Dump continued from file: c:\app\administrator\diag\rdbms\dbuat\dbuat\trace\dbuat_ora_544.trc ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], [], [], [], [] ========= Dump for incident 16131 (ORA 600 [15160]) ======== *** 2010-07-20 15:49:20.015 —– Current SQL Statement . . . → Read More: ORA-00600: internal error code, arguments: [15160]
作者: Maclean Liu, post on September 17th, 2010 一套Linux上的10.2.0.1系统出现ORA-00600:[15570]内部错误，日志如下:
Sat Jun 5 11:33:17 2010 Memory Notification: Library Cache Object loaded into SGA Heap size 2190K exceeds notification threshold (2048K) KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== Sat Jun 5 14:57:25 2010 Thread 1 advanced to log sequence 16540 Current log# 3 seq# 16540 mem# 0: /ora_data/mantas/redo03.log Sat Jun 5 14:58:37 2010 Errors in file /opt/oracle/admin/mantas/udump/mantas_ora_10803.trc: ORA-00600: . . . → Read More: ORA-00600:[15570]内部错误一例
作者: Maclean Liu, post on September 9th, 2010 一套Solaris上的9.2.0.7系统，实例意外终止，告警日志中出现以下记录:
Thu Sep 2 02:15:41 2010 Errors in file /u01/app/oracle/admin/preg063/bdump/preg063_smon_11391.trc: ORA-07445: exception encountered: core dump [0000000101E05500] [SIGBUS] [Object specific hardware error] [0xFFFFFFFF7CB3BF90] [] [] Thu Sep 2 02:15:48 2010 Errors in file /u01/app/oracle/admin/preg063/bdump/preg063_pmon_11379.trc: ORA-00474: SMON process terminated with error Thu Sep 2 02:15:48 2010 PMON: terminating instance due to error 474 Wed Sep 1 15:04:20 . . . → Read More: ORA-07445 [SIGBUS] [Object specific hardware error]错误一例
作者: Maclean Liu, post on September 5th, 2010 Oracle Solaris上的一套11.2.0.1.0最近出现以下告警记录:
Dump file /cnbbs01/app/oracle/diag/rdbms/nbbsprd1/nbbsprd1/incident/incdir_373041/nbbsprd1_ora_24754_i373041.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production ORACLE_HOME = /cnbbs01/app/oracle/product/11.2.0/db_1 System name: SunOS Node name: ut06db03 Release: 5.10 Version: Generic_142901-12 Machine: i86pc Instance name: nbbsprd1 Redo thread mounted by this instance: 1 Oracle process number: 130 Unix process pid: 24754, image: oracle@ut06db03 *** 2010-08-25 02:01:19.169 *** SESSION . . . → Read More: ORA-03137: TTC protocol internal error : [12333]错误一例
作者: Maclean Liu, post on September 3rd, 2010
作者: Maclean Liu, post on August 27th, 2010 帮网友强制打开了一个没有备份的测试库，这个库没有备份也没有打开归档，因为之前也出现过active日志文件损毁，一直使用隐式参数才能正常打开:
_allow_resetlogs_corruption= TRUE
这次一开始这个库报ORA-600[2662]错误:
Mon Aug 23 09:37:00 2010 Errors in file /oracle/QAS/saptrace/usertrace/qas_ora_852096.trc: ORA-00600: internal error code, arguments: [2662], [0], [130131504], [0], [130254136], [4264285], [], [] Mon Aug 23 09:37:02 2010 Errors in file /oracle/QAS/saptrace/usertrace/qas_ora_852096.trc: ORA-00600: internal error code, arguments: [2662], [0], [130131506], [0], [130254136], [4264285], [], []
ORA-600 [2662] “Block SCN is ahead of . . . → Read More: Database Force open example
|
|
最新评论