4 Replies Latest reply on Apr 6, 2018 10:49 AM by Andris Perkons-Oracle

    SP2-0382: The SHOW PDBS command is not available. when connected to 18c

    Franck Pachot

      Hi,

      When connected to a CDB in 18c I cannot run 'show pdbs' from sqldev or sqlcl 17.1

       

      SQL> set sqlformat ansiconsole

      SQL> set echo on

      SQL> select * from v$version;

      BANNER                                                                   BANNER_FULL                                                                                 BANNER_LEGACY                                                            CON_ID  

      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production   Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

      Version 18.1.0.0.0   Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production          0

       

       

      SQL> select * from v$pdbs;

      CON_ID   DBID         CON_UID      GUID                               NAME       OPEN_MODE    RESTRICTED   OPEN_TIME                                CREATE_SCN   TOTAL_SIZE   BLOCK_SIZE   RECOVERY_STATUS   SNAPSHOT_PARENT_CON_ID   APPLICATION_ROOT   APPLICATION_PDB   APPLICATION_SEED   APPLICATION_ROOT_CON_ID   APPLICATION_ROOT_CLONE   PROXY_PDB   LOCAL_UNDO   UNDO_SCN   UNDO_TIMESTAMP   CREATION_TIME          DIAGNOSTICS_SIZE   PDB_COUNT   AUDIT_FILES_SIZE   MAX_SIZE   MAX_DIAGNOSTICS_SIZE   MAX_AUDIT_SIZE   LAST_CHANGED_BY   TEMPLATE   TENANT_ID   UPGRADE_LEVEL   GUID_BASE64               

             2   1277467981   1277467981 65CBB31121693D00E053B438A8C0F97F   PDB$SEED   READ ONLY    NO           22-FEB-18 05.03.07.337000000 PM +01:00        1477964    799014912         8192 ENABLED                                    NO                 NO                NO                                           NO                       NO                     1        259                  22-FEB-2018 11:42:25                    0           0                  0          0                      0                0 COMMON USER       NO                                   1 ZcuzESFpPQ==              

             3   4262572806   4262572806 65CBCE46A7FA4454E053B438A8C0FDBD   PDB1       READ WRITE   NO           22-FEB-18 05.22.56.017000000 PM +01:00        1507731    819986432         8192 ENABLED                                    NO                 NO                NO                                           NO                       NO                     1        259                  22-FEB-2018 11:50:02                    0           0                  0          0                      0                0 COMMON USER       NO                                   3 ZcvORqf6RFTgU7Q4qMD9vQ==  

       

       

      SQL> show pdbs

      SP2-0382: The SHOW PDBS command is not available.

       

      Regards,

      Franck.