问题背景:
国庆期间在处理数据库故障期间发现核心和本地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




