Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »Local Undo of PDB for Each RAC Instance
Pluggable Database (PDB)
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-12505 Before migrating to a multitenant environment, some users used to use SID to connect to the source database. The connect identifier may look like… Read More »How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect
ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
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