错误：ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey],...
本帖最后由 linxs 于 2015-5-3 13:37 编辑双节点1，节点1报ORA-00600: internal error code, arguments: , , , , , , , [], [], [], [], []
数据库实例自动重启。详细信息请查看附件日志，麻烦大神们看看，谢谢！
数据库版本：
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
节点1：alert日志
Mon Apr 27 01:31:46 2015
Archived Log entry 61132 added for thread 1 sequence 41381 ID 0x39c8f03e dest 1:
Mon Apr 27 01:37:52 2015
Index RMS.IF_TRAN_DATA_I3 or some partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I1 or some partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I4 or some partitions of the index have been marked unusable
Index RMS.DEAL_PERF_TRAN_DATA_I1 or some partitions of the index have been marked unusable
Mon Apr 27 01:38:19 2015
Thread 1 advanced to log sequence 41383 (LGWR switch)
Current log# 3 seq# 41383 mem# 0: +DATA1DG/rmsdb/onlinelog/group_3.256.844074027
Mon Apr 27 01:38:23 2015
Archived Log entry 61133 added for thread 1 sequence 41382 ID 0x39c8f03e dest 1:
Mon Apr 27 01:38:43 2015
Thread 1 advanced to log sequence 41384 (LGWR switch)
Current log# 4 seq# 41384 mem# 0: +DATA1DG/rmsdb/onlinelog/group_4.259.844074019
Mon Apr 27 01:38:47 2015
Archived Log entry 61135 added for thread 1 sequence 41383 ID 0x39c8f03e dest 1:
Mon Apr 27 01:38:55 2015
Index RMS.REPL_ITEM_LOC_UPDATES_I1 or some partitions of the index have been marked unusable
Index RMS.REPL_ITEM_LOC_UPDATES_I2 or some partitions of the index have been marked unusable
Mon Apr 27 01:39:01 2015
Thread 1 advanced to log sequence 41385 (LGWR switch)
Current log# 5 seq# 41385 mem# 0: +DATA1DG/rmsdb/onlinelog/group_5.258.844074011
Mon Apr 27 01:39:05 2015
Archived Log entry 61136 added for thread 1 sequence 41384 ID 0x39c8f03e dest 1:
Mon Apr 27 01:39:19 2015
Thread 1 advanced to log sequence 41386 (LGWR switch)
Current log# 1 seq# 41386 mem# 0: +DATA1DG/rmsdb/onlinelog/group_1.261.844074041
Mon Apr 27 01:39:23 2015
Archived Log entry 61137 added for thread 1 sequence 41385 ID 0x39c8f03e dest 1:
Mon Apr 27 01:39:43 2015
Thread 1 advanced to log sequence 41387 (LGWR switch)
Current log# 2 seq# 41387 mem# 0: +DATA1DG/rmsdb/onlinelog/group_2.260.844074035
Mon Apr 27 01:39:48 2015
Archived Log entry 61139 added for thread 1 sequence 41386 ID 0x39c8f03e dest 1:
Mon Apr 27 01:40:07 2015
Thread 1 advanced to log sequence 41388 (LGWR switch)
Current log# 3 seq# 41388 mem# 0: +DATA1DG/rmsdb/onlinelog/group_3.256.844074027
Mon Apr 27 01:40:11 2015
Archived Log entry 61140 added for thread 1 sequence 41387 ID 0x39c8f03e dest 1:
Mon Apr 27 01:40:53 2015
Index RMS.HIST_REBUILD_MASK_I1 or some partitions of the index have been marked unusable
Mon Apr 27 01:40:54 2015
Errors in file /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/trace/rmsdb1_lms4_19133.trc (incident=1536630):
ORA-00600: internal error code, arguments: , , , , , , , [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/incident/incdir_1536630/rmsdb1_lms4_19133_i1536630.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 27 01:40:56 2015
Dumping diagnostic data in directory=, requested by (instance=1, osid=19133 (LMS4)), summary=.
Mon Apr 27 01:40:59 2015
Sweep : completed
Sweep : completed
Errors in file /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/trace/rmsdb1_lms4_19133.trc:
ORA-00600: internal error code, arguments: , , , , , , , [], [], [], [], []
LMS4 (ospid: 19133): terminating the instance due to error 484
Mon Apr 27 01:41:08 2015
Instance terminated by LMS4, pid = 19133
Mon Apr 27 01:41:30 2015
Adjusting the default value of parameter parallel_max_servers
from 7680 to 2985 due to the value of parameter processes (3000)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Mon Apr 27 01:41:41 2015
Private Interface 'igb2:1' configured from GPnP for use as a private interconnect.
Private Interface 'igb3:1' configured from GPnP for use as a private interconnect.
Public Interface 'ixgbe0' configured from GPnP for use as a public interface.
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: SunOS
Node name: sfmomdb1
Release: 5.10
Version: Generic_150400-07
Machine: sun4v
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfilermsdb1.ora
System parameters with non-default values:
processes = 3000
sessions = 4608
sga_max_size = 90G
shared_pool_size = 5G
large_pool_size = 3G
set _gc_read_mostly_locking=false
页:
[1]