数据库宕机发生时间为190920 17:49 之后
-----节点2alert
Fri Sep 20 17:49:00 2019
NOTE: ASMB terminating
Errors in file /app/odb/oracle/diag/rdbms/jlcw/jlcw2/trace/jlcw2_asmb_7275.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 1985 ???: 3
Errors in file /app/odb/oracle/diag/rdbms/jlcw/jlcw2/trace/jlcw2_asmb_7275.trc:
ORA-15064: ? ASM ??????
ORA-03113: ?????????
?? ID:
?? ID: 1985 ???: 3
ASMB (ospid: 7275): terminating the instance due to error 15064
Termination issued to instance processes. Waiting for the processes to exit
Instance terminated by ASMB, pid = 7275
Fri Sep 20 17:50:02 2019
Adjusting the default value of parameter parallel_max_servers
from 2560 to 1470 due to the value of parameter processes (1500)
通过观察告警日志及告警日志指向的trc等文件目前有两个疑问在日志中没看到
在节点一的oraagent_grid.log日志中观察到该时间节点显示如下信息：
status=nodedown reason=public_nw_down
jlcw1_smon_8905_i66241.trc中信息：
========== FRAME [29] (_start()+41 -> __libc_start_main()) ==========
defined by frame pointers 0x0 and 0x7ffff3560300
CALL TYPE: call ERROR SIGNALED: yes COMPONENT: (null)
为什么与asm不能通讯（虽然ora-15064事件比较明确，但在相关trc文件中未观察到连接相关信息
ksedsts()+465<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+63<-ksuitm()+5570<-ksbrdp()+3507<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253）
为什么节点1在恢复时会遭遇ora-600
请专家指点
评论
有用 0
