RAC一个节点突然重启
生产上突然一个实例重启。操作系统：ORACLE enterprises Linux5.6
数据库版本：11.2.0.3
下面是该实例的alert Time: 15-MAR-2014 18:19:14
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.4.95.132)(PORT=50000))
opidcl aborting process unknown ospid (48803) as a result of ORA-2396
Sat Mar 15 19:54:31 2014
LMS0 (ospid: 31900) received an instance eviction notification from instance 3
Sat Mar 15 19:54:31 2014
LMON received an instance eviction notification from instance 3
The instance eviction reason is 0x2
The instance eviction map is 2
Received an instance abort message from instance 4
Please check instance 4 alert and LMON trace files for detail.
Sat Mar 15 19:54:32 2014
Received an instance abort message from instance 4
Please check instance 4 alert and LMON trace files for detail.
LMS0 (ospid: 31900): terminating the instance due to error 481
Sat Mar 15 19:54:32 2014
System state dump requested by (instance=2, osid=31900 (LMS0)), summary=.
System State dumped to trace file /u01/app/oracle/diag/rdbms/nmsw/nmsw2/trace/nmsw2_diag_31884.trc
Sat Mar 15 19:54:34 2014
ORA-1092 : opitsk aborting process
Sat Mar 15 19:54:34 2014
License high water mark = 245
Instance terminated by LMS0, pid = 31900
USER (ospid: 111413): terminating the instance
Instance terminated by USER, pid = 111413
Sat Mar 15 19:54:45 2014
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 16 GB (100%)
Large Pages used by this instance: 8193 (16 GB)
Large Pages unused system wide = 14 (28 MB) (alloc incr 32 MB)
Large Pages configured system wide = 19592 (38 GB)
Large Page size = 2048 KB
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/arch
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.3/dbhome_1
System name: Linux
Node name: dm03db02.bmcc.com.cn
Release: 2.6.32-400.21.1.el5uek
Version: #1 SMP Wed Feb 20 01:35:01 PST 2013
Machine: x86_64
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/initnmsw2.ora上面是重启的实例的alertoracle@dm03db02 tmp]$ more output.txt
TKPROF: Release 11.2.0.3.0 - Development on Sun Mar 16 21:06:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Trace file: /u01/app/oracle/diag/rdbms/nmsw/nmsw2/trace/nmsw2_diag_31884.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: /u01/app/oracle/diag/rdbms/nmsw/nmsw2/trace/nmsw2_diag_31884.trc
Trace file compatibility: 11.1.0.7
Sort options: default
1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
13511141 lines in trace file.
0 elapsed seconds in trace file.没有一点头绪，望各位指点一下。 crs的日志也要上传一下吧！
页:
[1]