Database Configuration Assistant (DBCA)

How to Build 19c RAC on Windows - 4 of 4 - Creating a RAC Database

by Ed Chen
July 9, 2022September 13, 2022

We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process. We had better to restart both nodes to verify… Read More »

How to Install Oracle Database 11.2.0.1 on Enterprise Linux 5 - 4 of 4 - Database Creation

by Ed Chen
April 24, 2022April 22, 2022

D. Oracle Database Creation [oracle@primary01 ~]$ dbca

Where is DBCA Log Location

by Ed Chen
December 31, 2021April 22, 2022

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 »

PDB Local Undo for Each RAC Instance

by Ed Chen
June 16, 2021November 9, 2021

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 »

How to Remove MGMTDB

by Ed Chen
February 13, 2021July 8, 2022
2 Comments

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 Resolve ORA-15173 Error Message

by Ed Chen
November 4, 2020July 3, 2022

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 »

Complete Oracle 19c Initialization Parameters List in DBCA

by Ed Chen
October 31, 2020September 25, 2021

The complete list is shown during creating a 19c RAC database by DBCA.

How to Build 19c RAC - 4 of 4 - Creating a RAC Database

by Ed Chen
October 28, 2020October 1, 2021

After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA). [oracle@primary01 ~]$ dbca We would… Read More »

How to Empty an Oracle Database

by Ed Chen
January 8, 2020July 27, 2022

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 Install Oracle Database 12.2 on Windows

by Ed Chen
October 23, 2019September 13, 2022

The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »