- 最后登录
- 2015-8-6
- 在线时间
- 5 小时
- 威望
- 0
- 金钱
- 33
- 注册时间
- 2015-1-22
- 阅读权限
- 10
- 帖子
- 6
- 精华
- 0
- 积分
- 0
- UID
- 2245
|
1#
发表于 2015-4-27 15:37:34
|
查看: 3332 |
回复: 1
本帖最后由 linxs 于 2015-5-3 13:37 编辑
双节点1,节点1报ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
数据库实例自动重启。详细信息请查看附件日志,麻烦大神们看看,谢谢!
数据库版本:
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 [sub]partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I1 or some [sub]partitions of the index have been marked unusable
Index RMS.IF_TRAN_DATA_I4 or some [sub]partitions of the index have been marked unusable
Index RMS.DEAL_PERF_TRAN_DATA_I1 or some [sub]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 [sub]partitions of the index have been marked unusable
Index RMS.REPL_ITEM_LOC_UPDATES_I2 or some [sub]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 [sub]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: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
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=[cdmp_20150427014056], requested by (instance=1, osid=19133 (LMS4)), summary=[incident=1536630].
Mon Apr 27 01:40:59 2015
Sweep [inc][1536630]: completed
Sweep [inc2][1536630]: completed
Errors in file /u01/app/oracle/diag/rdbms/rmsdb/rmsdb1/trace/rmsdb1_lms4_19133.trc:
ORA-00600: internal error code, arguments: [kjblpkeydrmqscchk:pkey], [999306], [12], [2476912], [0], [7], [0], [], [], [], [], []
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.
[name='igb2:1', type=1, ip=169.254.26.113, mac=a0-36-9f-2e-21-42-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=169.254.0.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Private Interface 'igb3:1' configured from GPnP for use as a private interconnect.
[name='igb3:1', type=1, ip=169.254.193.63, mac=a0-36-9f-2e-21-43-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=169.254.128.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Public Interface 'ixgbe0' configured from GPnP for use as a public interface.
[name='ixgbe0', type=1, ip=192.168.0.103, mac=00-10-e0-3f-46-de-00-00-00-00-00-00-00-00-00-00-00-2f-ff-ff, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
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
|
|