ASM instance warning message in alert log file

“Warning: VKTM detected a time drift”

  Solution

Usually VKTM and VKRM issues come together, at least when you are using the resource manager. 

The VTKM is the Virtual Keeper of Time Process. The VKTM acts as a time publisher for an Oracle instance.  VKTM publishes two sets of time: a wall clock time using a seconds interval and a higher resolution time (which is not wall clock time) for interval measurements.  

The VKTM process is a process that is available in ASM instances and RDBMS instances. So if you see issues with VKTM process, it usually pops up on both. VKTM usage is affected mainly by two hidden parameters _timer_precision and _disable_highres_ticks. So, tuning these parameters can bring down VKTM CPU consumption.

The VKRM process is the Virtual Scheduler for Resource Manager Process, and it serves as centralized scheduler for Resource Manager activity. As there is no resource manager on a ASM instance, you will see this process only on RDBMS instances.

For version 11.2.0.1, Apply patch for Bug 9843304.  This Bug is already fixed in 11.2.0.2

For 11.2.0.2 and 11.2.0.3, apply patch for Bug 11837095, This Bug is already fixed in 11.2.0.4

If patch is not available then please raise SR with Oracle Support.

Add the following even in spfile or pfile.

event="10795 trace name context forever, level 2"

Oracle Grid Infrastructure CRS status showing offline

Oracle GI CRS status is showing offline in Red Hat Linux, and because CRS is not up and running, it won't allow ASM instance to start.

check the status of the GI resource

login with "grid" os user and run the following command

[root@oracle12cdb1 bin]# ./crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.DATA.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.FRS.dg

               OFFLINE  OFFLINE       oracle12cdb1             STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.LISTENER12C.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.asm

               OFFKINE  OFFLINE       oracle12cdb1             STABLE

ora.ons

               OFFLINE OFFLINE      oracle12cdb1             STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.ora12cr2global.db

      1        ONLINE  OFFLINE                               STABLE

--------------------------------------------------------------------------------

- To resolve the issue, do the following command, please take all the backups of GI , CRS 

run the following command

                  crsctl stop res ora.CRS.dg -init

                  

                    crsctl status res -t

                  

                    crsctl modify res ora.CRS.dg -attr ENABLED=0 -init

                   

                     crsctl status res -t

                   

                    crsctl modify res ora.CRS.dg -attr ENABLED=1 -init

                   

                    crsctl status res -t

                    crsctl start res ora.CRS.dg -init

[grid@oracle12cdb1 ~]$ crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.DATA.dg

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.FRS.dg

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.LISTENER12C.lsnr

               ONLINE  ONLINE       oracle12cdb1             STABLE

ora.asm

               ONLINE  ONLINE       oracle12cdb1             Started,STABLE

ora.ons

               OFFLINE OFFLINE      oracle12cdb1             STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oracle12cdb1             STABLE

ora.ora12cr2global.db

      1        ONLINE  OFFLINE                               STABLE