After upgrade issue related to VKTM's priority with ORA-00800 [Set Priority Failed] [VKTM] (Doc ID 2856847.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

ORA-00800 [Set Priority Failed], [VKTM] occurred after 19c upgrade.

・alert.log:

Starting background process VKTM
2022-02-26T01:13:51.361592-05:00
Errors in file ../oracle/diag/rdbms/SID/SID/trace/{SID}_vktm_2428.trc (incident=1009191):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: ../oracle/diag/rdbms/SID/SID/incident/incdir_1009191/{SID}_vktm_2428_i1009191.trc
2022-02-26T01:13:51.399327-05:00
Error attempting to elevate VKTM's priority: no further priority changes will be attempted for this process

・Checking parameter setting

SQL> select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value", a.KSPPDESC "Description"
           from x$ksppi a, x$ksppcv b, x$ksppsv c
           where a.indx = b.indx and a.indx = c.indx
           and a.ksppinm like '_%' and a.ksppinm like '_highest_priority_process%';

Parameter                               Session Value          Instance Value           Description
------------------------------ -------------------- -------------------- ----------------------------------------
_highest_priority_processes      VKTM                      VKTM                        Highest Priority Process Name Mask

・ From OS view

1) Vktm priority was not set at highest priority:

../home/oracle: ps -A -o pid,tid,pri,args |(head -1; grep vktm)
PID TID PRI COMMAND
7236 7236 19 ora_vktm_SID

2) oradism is not owned by root/install and "Stick bit" [s] is missing.

../oracle/product/19.0.0/bin: ls -lrt oradism
-rwxr-x--- 1 oracle dba 147848 Apr 17 2019 oradism

Changes

New 19c RDBMS binary installation. Database is upgraded with no issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.