ORA-65025: Pluggable database OEMPDB is not closed on all instances.
Cause:
To drop a PDB, it should not be opened
SQL> drop pluggable database OEMPDB including datafiles;
drop pluggable database OEMPDB including datafiles
*
ERROR at line 1:
ORA-65025: Pluggable database OEMPDB is not closed on all instances.
Action:
Close the PDB and drop it
SQL> alter pluggable database OEMPDB close;
Pluggable database altered.
SQL> drop pluggable database OEMPDB including datafiles;
Pluggable database dropped.