有套oracle linux 7.6+oracle 19.19 rac环境,调整参数手动重启后发现有如下报错:
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lmhb_222807.trc (incident=635489):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LMHB], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
2023-06-25T21:11:12.785011+08:00
Error attempting to elevate LMHB's priority: no further priority changes will be attempted for this process
DDE: Problem Key 'ORA 800' was flood controlled (0x6) (incident: 635489)
ORA-00800: soft external error, arguments: [Set Priority Failed], [LMHB], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
ksesethighpri: (kjgcr.c:2425) Failed to elevate LMHB's priority from 0 to 1, policy 2
Error Info: Category(-2), Opname(skgdism_send), Loc(sp.c:setpr:0), ErrMsg(Operation not permitted) Dism(128)
ksesethighpri: (kjgcr.c:2425) Failed to elevate LMHB's priority from 0 to 1, policy 2
Error Info: Category(-2), Opname(skgdism_send), Loc(sp.c:setpr:0), ErrMsg(Operation not permitted) Dism(128)
2023-06-25T22:23:23.808362+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_vktm_292814.trc (incident=757862):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_757862/orcl1_vktm_292814_i757862.trc
2023-06-25T22:23:23.809484+08:00
Error attempting to elevate VKTM's priority: no further priority changes will be attempted for this process
百度了很多blog都无法解决问题,使用srvctl start database -d orcl启动不报错ORA-00800,使用startup就报错。
最后处理办法:
# echo 0 > /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us
# echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us
不明白道理,有空继续研究
mos文档:
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM] (Doc ID 2718971.1)