暂无图片
暂无图片
3
暂无图片
暂无图片
暂无图片

oracle19c数据库open报错ora-00800的解决过程

原创 11 0 2023-10-13
1463

问题背景:   

 国庆期间在处理数据库故障期间发现核心和本地ADG数据库open时都有一个报错和本地ADG数据库open时都有一个报错:

    ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS1], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSN], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS7], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS9], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSH], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS0], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSA], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSO], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSD], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSP], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSR], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSG], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMS2], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSI], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSQ], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSC], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMSJ], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

ORA-00800: soft external error, arguments: [Set Priority Failed], [LMHB], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

 

数据库的版本是:

Oracle 19.16

Linux 7.9


解决方法:

查询mos文档:

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM] (Doc ID 2718971.1)      

使用以下方法解决了:

1) 本身就是0,这一步不需要

cat  /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us

0

# echo 0 > /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us

 

2) 原来是0,需要修改

cat /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

0

# echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us


「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论