ORA-01109 ORA-01109 is pretty normal when your database is close, mostly it's previously shutdown manually by someone, or the database shutdown itself by accident, you… Read More »How to Resolve ORA-01109: database not open
There're several ways that can create a PDB. Create a PDB by using SQL*Plus Create a PDB by using DBCA Create a PDB by cloning… Read More »How to Create a Pluggable Database (PDB)
ORA-65025 ORA-65025 means that the pluggable database should be closed completely before dropping. Let's see a case of dropping a PDB. SQL> drop pluggable database… 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
OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »How to Connect a PDB Directly by OS Authentication
Expdp PDB as SYSDBA If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get… Read More »How to expdp PDB as SYSDBA without Password