连oracle 时断时续,业务反应APP到DB的连接时断时续，数据也无法保存提交。环境：Oracle 12.2.0.1 RAC，RHEL6.9....

2019-03-13

业务反应APP到DB的连接时断时续，数据也无法保存提交。环境：Oracle 12.2.0.1 RAC，RHEL6.9.

检查数据库，发现一个节点alert日志正常，另一个节点alert日志如下

2019-03-13T18:48:43.105236+08:00Archived Log entry 11681 added for T-2.S-2902 ID 0xc3109d85 LAD:1

2019-03-13T18:52:57.423641+08:00

TT02: Standby redo logfile selected for thread 2 sequence 2903 for destination LOG_ARCHIVE_DEST_2

2019-03-13T19:04:53.919412+08:00

KILL SESSION for sid=(581, 24669):

Reason = alter system kill session

Mode = KILL SOFT -/-/-

Requestor = USER (orapid = 159, ospid = 21879, inst = 2)

Owner = Process: USER (orapid = 9, ospid = 5313)

Result = ORA-0

2019-03-13T19:05:12.685498+08:00

KILL SESSION for sid=(879, 15503):

Reason = alter system kill session

Mode = KILL SOFT -/-/-

Requestor = USER (orapid = 159, ospid = 21879, inst = 2)

Owner = Process: USER (orapid = 78, ospid = 31568)

Result = ORA-0

2019-03-13T19:27:10.469819+08:00

KILL SESSION for sid=(949, 25776):

Reason = alter system kill session

Mode = KILL SOFT -/-/-

Requestor = USER (orapid = 159, ospid = 21879, inst = 2)

Owner = N/A

Result = ORA-27

2019-03-13T19:27:39.835691+08:00

KILL SESSION for sid=(949, 25776):

Reason = alter system kill session

Mode = KILL SOFT -/-/-

Requestor = USER (orapid = 159, ospid = 21879, inst = 2)

Owner = N/A

Result = ORA-27