暂无图片
opiodr aborting process unknown ospid (21745) as a result of ORA-609
我来答
分享
mmxxpp
2022-07-20
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条回答
默认
最新
张sir
上传附件:Doc ID 1538717.1.pdf
暂无图片 评论
暂无图片 有用 0
打赏 0
张sir

试试mos上这个文档。这种问题原因比较多。

暂无图片 评论
暂无图片 有用 0
打赏 0
mmxxpp
题主
2022-07-20
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
mmxxpp
题主
2022-07-20
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
mmxxpp
题主
2022-07-20
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
展开全部评论(1条)

ospid应该是某个系统进程,是客户端在建立或创建会话过程超时了吧

暂无图片 评论
暂无图片 有用 0
打赏 0
mmxxpp
题主
2022-07-20
我再看看
布衣
暂无图片

网上看到的,希望对你有帮助 https://blog.csdn.net/guo_oracle/article/details/18074135

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
oracle 19c gc buffer busy release 问题
回答 4
Bug30381614RACDatabaseSessionsWaitingforaLongTimeon'gcbufferbusyrelease'(DocID30381614.8)
oracle19c表空间扩容怎么操作?
回答 1
已采纳
1、查看表空间colTABLESPACENAMEfora20selecttbsusedinfo.tablespacename,tbsusedinfo.allocmb,tbsusedinfo.usedm
CentOS7关于Oracle RAC 11GR2部署磁盘分区问题
回答 3
已采纳
12c之前ASM磁盘组单盘不能超过2TB,从12C开始ASM磁盘组单盘支持超过2TB空间,具体最大单盘磁盘大小受AU大小限制。给你一份我们生产上的磁盘组划分,希望对你有帮助DATA数据磁盘组CRS–o
ORACLE 12CR2 RAC 数据库启动失败,报错ORA-00443,但是sqlplus却可以启动,求解?
回答 4
ora.onsONLINEOFFLINErac1STABLEONLINEONLINErac2STABLERAC1上的高可用是offline的。
ORACLE 11G RAC 的主机名不能是大写?
回答 2
已采纳
规定的是不能大写的
执行计划的阅读顺序,pg和oracle都是从下往上,从左到右吗?
回答 1
从里向外
asm磁盘创建失败
回答 9
已采纳
都是挂在scsi1上吧?scsi1:0scsi1:3
oracle 19C rac asmca 明明50G 空闲,却只有20G 能用
回答 2
创建磁盘组的时候选择EXTERN
BTRobot 巡检 Oracle 19C rac 两节点集群卡住的问题
回答 1
BTRobot这是个啥东东?
19c上密码包含特殊字符@无法直接登录
回答 1
已采纳
19c上不可以直接sqlplustest/”test@123“,在19c之前(11g,12c)都是可以的。Mos文档 (DocID2761789.1)针对这个有具体描述,原因是命中未发布的b