Database Configuration Assistant (DBCA)

How to Install Oracle Database 19c on Solaris

by Ed Chen
January 24, 2023January 19, 2023

There're 2 phases of the installation of Oracle database 19c. OS Configuration Installation OS Configuration Check Operating System Groups, Users and Resources Check Operating System… Read More »

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

by Ed Chen
July 9, 2022January 19, 2023

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, 2021December 29, 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, 2020December 9, 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, 2020January 19, 2023

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, 2020January 19, 2023

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, 2020December 10, 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 »