Another problem with “KSV master wait” and “ASM file metadata operation”

My customer today tried to do a duplicate on a cluster. When preparing the auxiliary instance, she noticed that the startup nomount was hanging forever: Nothing in the alert, nothing in the trace files.

Because the database and the spfile were stored inside ASM, I’ve been quite suspicious…

The ASM trace files had the following entries:

The ASM instance had the following sessions waiting:

OMS?

Around 12:38:56, another colleague in the office added a disk to one of the disk groups, through Enterprise Manager 12c!

But there were no rebalance operations:

It’s not the first time that I hit this type of problems. Sadly, sometimes it requires a full restart of the cluster or of ASM (because of different bugs).

This time, however, I have tried to kill only the foreground sessions waiting on “ASM file metadata operation”, starting with the one coming from the OMS.

Surprisingly, after killing that session, everything was fine again:

I never add disks via OMS (I’m a sqlplus guy ;-)) , I wonder what went wrong with it 🙂

Ludovico

The following two tabs change content below.

Ludovico

Oracle ACE Director and Senior Consultant at Trivadis
Ludovico is an Oracle ACE Director, frequent speaker and community contributor, working as Senior Database Specialist for Trivadis, Switzerland.

One thought on “Another problem with “KSV master wait” and “ASM file metadata operation”

  1. Hello Dear Concern,

    KSV master wait
    KSV master wait
    log file switch (archiving needed)
    log file switch (archiving needed)
    KSV master wait
    KSV master wait
    KSV master wait
    library cache lock
    library cache lock
    KSV master wait

    I am getting this error while i bulk insert in my table where ever is use exa-data
    x42-2 and x2-2 machine 4 node and 4 node total 8 node RAC

    Dev guys are clearly want to know and resolve this… if any suggestion kor

    KSV master lock

Leave a Reply

Your email address will not be published. Required fields are marked *