QMON SLAVE PROCESS HOLDING FILE DESCRIPTOR ON ACFS VOLUME (Doc ID 2033709.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

On 12.1.0.1 release using ACFS and PDB databases, trying to delete the acfs snapshot doesn't release the snapshot space as database job process is holding the lock and causing failure
F3 6222218.322/140804105130 acfsutil.bin[38437] ofs_snap_delete: Snap Root lock failed with status(0xc0000121)
F3 6222218.322 acfsutil.bin[38437] OfsReleaseDLMLock: fcb 0x (null) (0xffffffffffffffff/30), mode EXCL, flags 0x0
F3 6222218.322 acfsutil.bin[38437] ofs_dlm_process_bast: lock id: 0xffffffffffffffff/30, curr_mode: EXCL, bast_mode: SHARED
F3 6222218.322 acfsutil.bin[38437] ofs_data_downgrade: fcb 0x (null) 0xffffffffffffffff/30 bast_mode SHARED

Even shutting down the PDB database, process still exist at OS level and holding the lock


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Open read only pluggable PDB_BASEARA
Create pluggable database TEST (snapshot copy)
Open read write pluggable database TEST
Close pluggable database TEST & PDB_BASEARA
Check of snapshot locks
pstack process which locks snapshot


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms