PDB Hanging During Open or Close Operations Due To QMON Locks
Last updated on FEBRUARY 20, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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;
Using multiple PDBs with CDB.
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