My Oracle Support Banner

User PDB is not Listed in Query of CDB_REGISTRY (Doc ID 2191706.1)

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.