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?