ORA-800_VKTM

 

ORA-800_VKTM

 

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM]

ORA-800_VKTM_Fix

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

After kernel update on linux system you get ORA-00800 error. In many cases you need to as follow

echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

The above command will fix the Issue, and you need to restart the DB. But when you reboot your Server the change will lost. Better to add following line in the rc.local file to persistent after reboot.

vi /etc/rc.local
echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

chmod +x /etc/rc.local

That's it 

I have script, if you have multiple server to fix the issue via jump host-.

#!/bin/bash

if [ -f $1 ]; then

 SERVERLIST=$(cat $1)

else

 SERVERLIST=$1

fi

for i in $SERVERLIST; do

    echo "Processing $i ..."

    ssh -q -T \

        -o ConnectTimeout=1 \

        -o PreferredAuthentications=publickey \

        "$i" /bin/bash --noprofile --norc <<'EOF'

echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

cat /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

touch /etc/rc.local

grep -q "cpu.rt_runtime_us" /etc/rc.local || cat >> /etc/rc.local <<'EORC'

# Set CPU real-time runtime for Oracle VKTM

echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us

EORC

chmod +x /etc/rc.local

EOF

done