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.

Leave a Reply