opiodr aborting process unknown ospid (21745) as a result of ORA-609
昨天巡检数据库发现的,求助大家一下,怎么解决,产生原因,多谢。
2022-07-19T00:05:45.730426+08:00
Thread 4 advanced to log sequence 47453 (LGWR switch)
Current log# 4 seq# 47453 mem# 0: +DG_DATA/XXXXXXXXX/ONLINELOG/group_4.932.1073525991
Current log# 4 seq# 47453 mem# 1: +DG_DATA/XXXXXXXXX/ONLINELOG/group_4.931.1073525993
2022-07-19T00:05:46.132412+08:00
ARC2 (PID:57680): Archived Log entry 256361 added for T-4.S-47452 ID 0x458c991c LAD:1
2022-07-19T00:07:41.694816+08:00
opiodr aborting process unknown ospid (21745) as a result of ORA-609
我来答
添加附件
收藏
复制链接
微信扫码分享
在小程序上查看
分享
添加附件
问题补充
4条回答
默认
最新
2022-07-18T22:50:46.593208+08:00
Thread 4 advanced to log sequence 47448 (LGWR switch)
Current log# 3 seq# 47448 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_3.934.1073525987
Current log# 3 seq# 47448 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_3.933.1073525989
2022-07-18T22:50:46.802824+08:00
ARC1 (PID:57678): Archived Log entry 256341 added for T-4.S-47447 ID 0x458c991c LAD:1
2022-07-18T23:02:41.030465+08:00
Dumping diagnostic data in directory=[cdmp_20220718230240], requested by (instance=1, osid=71327 (MZ01)), summary=[incident=426048].
2022-07-18T23:05:47.165909+08:00
Thread 4 advanced to log sequence 47449 (LGWR switch)
Current log# 4 seq# 47449 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_4.932.1073525991
Current log# 4 seq# 47449 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_4.931.1073525993
2022-07-18T23:05:48.184143+08:00
ARC2 (PID:57680): Archived Log entry 256346 added for T-4.S-47448 ID 0x458c991c LAD:1
2022-07-18T23:20:44.719099+08:00
Thread 4 advanced to log sequence 47450 (LGWR switch)
Current log# 1 seq# 47450 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_1.919.1073525981
Current log# 1 seq# 47450 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_1.917.1073525983
2022-07-18T23:20:44.976614+08:00
ARC3 (PID:57682): Archived Log entry 256349 added for T-4.S-47449 ID 0x458c991c LAD:1
2022-07-18T23:35:45.334454+08:00
Thread 4 advanced to log sequence 47451 (LGWR switch)
Current log# 2 seq# 47451 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_2.926.1073525983
Current log# 2 seq# 47451 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_2.927.1073525985
2022-07-18T23:35:45.580215+08:00
ARC0 (PID:57674): Archived Log entry 256353 added for T-4.S-47450 ID 0x458c991c LAD:1
2022-07-18T23:50:45.466898+08:00
Thread 4 advanced to log sequence 47452 (LGWR switch)
Current log# 3 seq# 47452 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_3.934.1073525987
Current log# 3 seq# 47452 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_3.933.1073525989
2022-07-18T23:50:45.667085+08:00
ARC1 (PID:57678): Archived Log entry 256357 added for T-4.S-47451 ID 0x458c991c LAD:1
2022-07-19T00:05:45.730426+08:00
Thread 4 advanced to log sequence 47453 (LGWR switch)
Current log# 4 seq# 47453 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_4.932.1073525991
Current log# 4 seq# 47453 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_4.931.1073525993
2022-07-19T00:05:46.132412+08:00
ARC2 (PID:57680): Archived Log entry 256361 added for T-4.S-47452 ID 0x458c991c LAD:1
2022-07-19T00:07:41.694816+08:00
opiodr aborting process unknown ospid (21745) as a result of ORA-609
2022-07-19T00:20:46.021393+08:00
Thread 4 advanced to log sequence 47454 (LGWR switch)
Current log# 1 seq# 47454 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_1.919.1073525981
Current log# 1 seq# 47454 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_1.917.1073525983
2022-07-19T00:20:46.333294+08:00
ARC3 (PID:57682): Archived Log entry 256366 added for T-4.S-47453 ID 0x458c991c LAD:1
2022-07-19T00:35:46.410618+08:00
Thread 4 advanced to log sequence 47455 (LGWR switch)
Current log# 2 seq# 47455 mem# 0: +DG_DATA/XXXXXXXX/ONLINELOG/group_2.926.1073525983
Current log# 2 seq# 47455 mem# 1: +DG_DATA/XXXXXXXX/ONLINELOG/group_2.927.1073525985
2022-07-19T01:30:29.638345+08:00
Dumping diagnostic data in directory=[cdmp_20220719013029], requested by (instance=3, osid=5185 (MZ01)), summary=[incident=330155].
2022-07-19T01:31:28.162900+08:00
Errors in file /opt/oracle/diag/rdbms/jiangpust/jpora4/trace/jpora4_mz02_11389.trc (incident=273949) (PDBNAME=PDB_HDCTS):
ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], [], [], [], [], []
PDB_HDCTS(4):Incident details in: /opt/oracle/diag/rdbms/jiangpust/jpora4/incident/incdir_273949/jpora4_mz02_11389_i273949.trc
2022-07-19T01:31:31.491488+08:00
PDB_HDCTS(4):*****************************************************************
PDB_HDCTS(4):An internal routine has requested a dump of selected redo.
PDB_HDCTS(4):This usually happens following a specific internal error, when
PDB_HDCTS(4):analysis of the redo logs will help Oracle Support with the
PDB_HDCTS(4):diagnosis.
PDB_HDCTS(4):It is recommended that you retain all the redo logs generated (by
PDB_HDCTS(4):all the instances) during the past 12 hours, in case additional
PDB_HDCTS(4):redo dumps are required to help with the diagnosis.
PDB_HDCTS(4):*****************************************************************
展开全部评论(1条)
ospid应该是某个系统进程,是客户端在建立或创建会话过程超时了吧
评论
有用 0回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏


