User PDB is not Listed in Query of CDB_REGISTRY
(Doc ID 2191706.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Symptoms
NOTE: In the images and/or the document content below, the user information and data used represents fictitious
data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
You have several user pluggable databases (PDB), but only some of them show up in a query of CDB_REGISTRY.
The following sql was run from the root container database (CDB). In this example, see that the user PDBs are all open in READ WRITE mode, but do not show up in a query of the CDB_REGISTRY. Notice also that there are rows from CDB_REGISTRY for the CDB (con_id 1), <PDB1> (con_id 3), but no entries for PDB$SEED (con_id 2), <PDB2> (con_id 4), and <PDB3> (con_id 5).
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 <PDB1> READ WRITE NO
4 <PDB2> READ WRITE YES
5 <PDB3> READ WRITE YES
SQL> set linesize 120 pagesize 999
col comp_name for a35
select con_id, comp_name, version, status from cdb_registry order by con_id, comp_name;
CON_ID COMP_NAME VERSION STATUS
---------- ----------------------------------- ------------------------------ -----------
1 JServer JAVA Virtual Machine 12.1.0.2.0 VALID
1 OLAP Analytic Workspace 12.1.0.2.0 VALID
1 Oracle Database Catalog Views 12.1.0.2.0 VALID
1 Oracle Database Java Packages 12.1.0.2.0 VALID
1 Oracle Database Packages and Types 12.1.0.2.0 VALID
1 Oracle Database Vault 12.1.0.2.0 VALID
1 Oracle Label Security 12.1.0.2.0 VALID
1 Oracle Multimedia 12.1.0.2.0 VALID
1 Oracle OLAP API 12.1.0.2.0 VALID
1 Oracle Real Application Clusters 12.1.0.2.0 OPTION OFF
1 Oracle Text 12.1.0.2.0 VALID
1 Oracle Workspace Manager 12.1.0.2.0 VALID
1 Oracle XDK 12.1.0.2.0 VALID
1 Oracle XML Database 12.1.0.2.0 VALID
1 Spatial 12.1.0.2.0 VALID
3 JServer JAVA Virtual Machine 12.1.0.2.0 VALID
3 OLAP Analytic Workspace 12.1.0.2.0 VALID
3 Oracle Application Express 5.0.3.00.03 VALID
3 Oracle Database Catalog Views 12.1.0.2.0 VALID
3 Oracle Database Java Packages 12.1.0.2.0 VALID
3 Oracle Database Packages and Types 12.1.0.2.0 VALID
3 Oracle Database Vault 12.1.0.2.0 VALID
3 Oracle Label Security 12.1.0.2.0 VALID
3 Oracle Multimedia 12.1.0.2.0 VALID
3 Oracle OLAP API 12.1.0.2.0 VALID
3 Oracle Real Application Clusters 12.1.0.2.0 OPTION OFF
3 Oracle Text 12.1.0.2.0 VALID
3 Oracle Workspace Manager 12.1.0.2.0 VALID
3 Oracle XDK 12.1.0.2.0 VALID
3 Oracle XML Database 12.1.0.2.0 VALID
3 Spatial 12.1.0.2.0 VALID
Changes
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 |