暂无图片
alert抓取的问题
我来答
分享
来杯奶茶
2022-04-12
alert抓取的问题

alert中抓取的消息:
Errors in file /u01/app/oracle/diag/rdbms/maafc/afc1/trace/afc1_pmon_18067.trc:
ORA-24756: transaction does not exist
Tue Apr 12 11:49:14 2022
Errors in file /u01/app/oracle/diag/rdbms/maafc/afc1/trace/afc1_pmon_18067.trc:
ORA-24756: transaction does not exist
Tue Apr 12 11:49:24 2022
Errors in file /u01/app/oracle/diag/rdbms/maafc/afc1/trace/afc1_pmon_18067.trc:
ORA-24756: transaction does not exist
Tue Apr 12 11:49:34 2022
Errors in file /u01/app/oracle/diag/rdbms/maafc/afc1/trace/afc1_pmon_18067.trc:
ORA-24756: transaction does not exist
具体文件里面的内容:

[oracle@bjnewrac1 trace]$ tail -f /u01/app/oracle/diag/rdbms/maafc/afc1/trace/afc1_pmon_18067.trc

*** 2022-04-12 11:49:44.425
found process 0xca14570a0 pid=68 serial=7 ospid = 1160 dead

*** 2022-04-12 11:49:44.428
kssxdl: error deleting SO: 0xcb6855ea8 = transaction (56)
----------------------------------------
SO: 0xcb6855ea8, type: 56, owner: 0xc89a26f00, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xca14570a0, name=transaction, file=ktccts.h LINE:410, pg=0
ORA-24756: transaction does not exist

*** 2022-04-12 11:49:54.429
found process 0xca14570a0 pid=68 serial=7 ospid = 1160 dead

*** 2022-04-12 11:49:54.432
kssxdl: error deleting SO: 0xcb6855ea8 = transaction (56)
----------------------------------------
SO: 0xcb6855ea8, type: 56, owner: 0xc89a26f00, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xca14570a0, name=transaction, file=ktccts.h LINE:410, pg=0
ORA-24756: transaction does not exist

*** 2022-04-12 11:50:04.434
found process 0xca14570a0 pid=68 serial=7 ospid = 1160 dead

*** 2022-04-12 11:50:04.436
kssxdl: error deleting SO: 0xcb6855ea8 = transaction (56)
----------------------------------------
SO: 0xcb6855ea8, type: 56, owner: 0xc89a26f00, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xca14570a0, name=transaction, file=ktccts.h LINE:410, pg=0
ORA-24756: transaction does not exist

这是什么原因造成这样的问题的那。 

我来答
添加附件
收藏
分享
问题补充
6条回答
默认
最新
来杯奶茶
升级问题到: 潜在风险
暂无图片 评论
暂无图片 有用 0
来杯奶茶

select local_tran_id,state from dba_2pc_pending;  查了这个没东西。

暂无图片 评论
暂无图片 有用 0
吾喾


暂无图片 评论
暂无图片 有用 0
来杯奶茶

重启呀。

暂无图片 评论
暂无图片 有用 0
吾喾
2022-04-12
对,可能是bug或XA问题
来杯奶茶

不能停业务呀,没别的方法吗。 

暂无图片 评论
暂无图片 有用 0
钟永生

检查v$session和v$process 看这个会话进程是否存在?同时ps -ef |grep 1160 看对应的os进程是否存在? 如果不存在,就只能重启了吧?
pid=68 serial=7 ospid = 1160

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏