DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »Where is DBCA Log Location
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 »PDB Local Undo for Each RAC Instance
Some DBA may consider to remove MGMT database because of resource consuming. I myself found that MGMT database is error-prone when we apply patches on… Read More »How to Remove MGMT Database
ORA-15173: entry 'pdbseed' does not exist in directory There're two operations that you might see ORA-15173. Creating a Multitenant Database Creating a Pluggable Database ORA-15173… Read More »How to Resolve ORA-15173 Error Message
Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »How to Empty an Oracle Database