ORA-65011 There're several use cases that may throw ORA-65011. 1. Set PDB as Session Container Tried to set a PDB as the current session container,… Read More »How to Resolve ORA-65011: Pluggable database does not exist
How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database
ORA-65118 When we tried to close a pluggable database (PDB), we got ORA-65118. SQL> alter pluggable database FINPDB close; alter pluggable database FINPDB close *… Read More »How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database
I consistently get the wrong figures about free space of temporary tablespace in database tools, so I made a research. First of all, it's a… Read More »DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment
ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
ORA-65025 ORA-65025 means that the pluggable database should be closed completely for further operations like dropping. Let's see some cases about this error. Drop PDB… Read More »How to Resolve ORA-65025: Pluggable database is not closed on all instances.
ORA-65179 Let's see a unsuccessful case of dropping a pluggable database (PDB). SQL> drop pluggable database orclpdb2; drop pluggable database orclpdb2 * ERROR at line… Read More »How to Resolve ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged