PDB Hanging During Open or Close Operations Due To QMON Locks

(Doc ID 2358932.1)

Last updated on FEBRUARY 20, 2018

Applies to:

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

Symptoms

Concurrent operations to open and close different PDB instances may cause these instances to hang indefinitely. 

Take this example below, let say you have 10 PDBs named PDB1, PDB2, etc. Upon the execution of below sequence of commands several times in a row, it will eventually hang:

a) at instance 1, alter pluggable database pdb1 close instances = all;
b) at instance 1, alter pluggable database all open;
c) at instance 2, alter pluggable database all open;




Changes

Using multiple PDBs with CDB.

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