19C-ORA-00800

原文:https://www.xifenfei.com/2022/11/ora-00800.html

在一套19.16 的linux 2节点rac库中,使用sqlplus启动数据库成功,但是alert日志报 ORA-00800: soft external error, arguments: [Set Priority Failed] 

***alter 日志信息
2024-07-31T11:31:33.381384+08:00
Starting background process VKTM
2024-07-31T11:31:33.494170+08:00
Errors in file /u01/app/oracle/diag/rdbms/jxdb/jxdb1/trace/jxdb1_vktm_93942.trc (incident=49):
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/jxdb/jxdb1/incident/incdir_49/jxdb1_vktm_93942_i49.trc
2024-07-31T11:31:33.498599+08:00
Error attempting to elevate VKTM's priority: no further priority changes will be attempted for this process
VKTM started with pid=6, OS id=93942
Starting background process GEN0
VKTM running at (100ms) precision

错误提示比较明显,提升进程的优先级失败,通过操作系统命令观察发现确实进程优先级没有提升

[root@hdb1 ~]# ps -eo pid,class,pri,nice,time,args|grep vktm|grep -v grep
93680 TS 19 - 00:05:24 ora_vktm_jxdb1
110637 RR 41 - 01:48:35 asm_vktm_+ASM1

重新使用srvctl启动数据库,优先级提升正常,alert日志中也无类似警告

[root@hdb1 ~]# ps -eo pid,class,pri,nice,time,args|grep vktm|grep -v grep
93694 RR 41 - 00:05:24 ora_vktm_jxdb1
110637 RR 41 - 01:48:35 asm_vktm_+ASM1

在mos上发现了相关mos文档,具体参考:(DB50) Clusterware Fails to Start Because CSSD Cannot Get Real-Time Priority (Doc ID 2903663.1),
由于 bug 34286265 and bug 34318125(Bug 34649727 Linux: ORA-800 / Set Priority / DB Performance Merge Patch for 19.17 – 34286265 34318125)

 原因

 

 尽量不要使用sqlplus去启动数据库,而是选择使用srvctl,避免在rac环境中导致数据库后台关键进程优先级无法提升问题.