ora-29740 instance evicted
alert 日志
2023-04-04T08:58:25.812811+08:00
Detected an inconsistent instance membership by instance 2
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_lmon_8216.trc (incident=2785485) (PDBNAME=CDB$ROOT):
ORA-29740: 已被编号为 2 的实例逐出, 组原型 6
Incident details in: /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/incident/incdir_2785485/ xxxxxx1_lmon_8216_i2785485.trc
2023-04-04T08:58:26.400637+08:00
xxxxxxPDB(3):minact-scn: got error during useg scan e:12751 usn:12
xxxxxxPDB(3):minact-scn: useg scan erroring out with error e:12751
2023-04-04T08:58:26.625510+08:00
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_dia0_8214_base_1.trc:
ORA-27508: ??????? IPC ??
2023-04-04T08:58:27.346041+08:00
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_dia0_8214_base_1.trc:
ORA-27508: ??????? IPC ??
2023-04-04T08:58:27.421378+08:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2023-04-04T08:58:27.421709+08:00
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_lmon_8216.trc:
ORA-29740: 已被编号为 2 的实例逐出, 组原型 6
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_lmon_8216.trc (incident=2785486) (PDBNAME=CDB$ROOT):
ORA-29740 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/incident/incdir_2785486/ xxxxxx1_lmon_8216_i2785486.trc
2023-04-04T08:58:27.866590+08:00
xxxxxxPDB(3):SMON (ospid: 8262): terminating the instance due to error 481
2023-04-04T08:58:28.057197+08:00
Errors in file /u01/app/oracle/diag/rdbms/ xxxxxx/ xxxxxx1/trace/ xxxxxx1_dia0_8214_base_1.trc:
ORA-27508: ??????? IPC ??
2023-04-04T08:58:30.350076+08:00
License high water mark = 129
2023-04-04T08:58:35.699859+08:00
xxxxxxPDB(3):Instance terminated by SMON, pid = 8262
查看lmon日志 分析实例被驱逐的原因
*** 2023-04-04T08:57:37.813387+08:00 (CDB$ROOT(1))
2023-04-04 08:57:37.813 : kjxgrDD_rr_read: Detect reconfig from inst 2, seq 5, reason 3
kjxgrrcfgchk: Initiating reconfig, reason=3
kjxgrrcfgchk: COMM rcfg - Disk Vote Required
kjfmReceiverHealthCB_CheckAll: Recievers are healthy.
2023-04-04 08:57:37.823 : kjxgrnetchk: start 0x22f194f, end 0x22fcf99
2023-04-04 08:57:37.823 : kjxgrnetchk: Network Validation wait: 46 sec
2023-04-04 08:57:37.823 : kjxgrnetchk: Sending comm check req to inst 2
kjxgrrcfgchk: prev pstate 6 mapsz 1024
kjxgrrcfgchk: new bmp: 1 2
kjxgrrcfgchk: cnct bmp: 1 2
kjxgrrcfgchk: disc bmp:
kjxgrrcfgchk: work bmp: 1 2
kjxgrrcfgchk: rr bmp: 1 2
1
实例被驱逐的原因 网络问题kjxgrrcfgchk: Initiating reconfig, reason=3
通常实例被驱逐重新配置的原因
原因 0 = 未重新配置
原因 1 = 节点监视器生成了重新配置
原因 2 = 检测到实例死亡。
原因 3 = 通信故障
原因 4 = 挂起后重新配置
网络原因被驱逐的话部署osw监控网络
参考mos Troubleshooting Instance Evictions (Instance terminates with ORA-29740, Instance Abort, Instance Kill) (Doc ID 1549135.1)

浙公网安备 33010602011771号