PDB Hanging During Open or Close Operations Due To QMON Locks
(Doc ID 2358932.1)
Last updated on MARCH 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle 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.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |