PDB Hanging During Open or Close Operations Due To QMON Locks
(Doc ID 2358932.1)
Last updated on AUGUST 25, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document