My Oracle Support Banner

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

Last updated on APRIL 07, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

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
           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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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