Skip to content

How to Resolve SP2-0382: The SHOW PDBS command is not available

  • by

SP2-0382

SP2-0382 means that the connected user are not privileged as SYSDBA, so SQL*Plus SHOW PDBS command is not available to the user.

SQL> conn system/password@orclcdb
Connected.
SQL> show pdbs;
SP2-0382: The SHOW PDBS command is not available

Even though we used SYSTEM to connect to the database. The database refused to show the information.

Solutions to SP2-0382

There're 2 ways to solve the error.

1. Connect by SYS

You can connect to the database by SYS to show all PDBs like this:

SQL> conn sys/password@orclcdb as sysdba
Connected.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO

2. Grant SYSDBA

If you can't or don't want to use SYS, then granting SYSDBA privilege to users who want to show all PDBs can also solve SP2-0382. For example:

SQL> grant sysdba to hr;

Grant succeeded.

Then connect again.

SQL> conn hr/hr@orclpdb as sysdba
Connected.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 ORCLPDB                        READ WRITE NO

Next, let's find out who has SYSDBA privilege?

Leave a Reply

Your email address will not be published.