Database Configuration Assistant (DBCA)

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

by Ed Chen
October 28, 2020October 29, 2020

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, 2020January 17, 2020

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 Server

by Ed Chen
October 23, 2019October 28, 2020

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 »

How to Create a 19c Database by DBCA with Silent Mode

by Ed Chen
August 3, 2019October 3, 2019

After installing Oracle 19c software only with silent mode, you may like to create a database by Database Configuration Assistant (DBCA) with silent mode, too.… Read More »

How to Restore 10g Clusterware OCR Voting Disk

by Ed Chen
June 20, 2019September 22, 2020

For 12c clusterware, you may check: How to Restore 12c Clusterware Suppose we have lost the shared storage as well as OCR data, voting disk… Read More »

How to Install Oracle 11g Software Only with Silent Mode

by Ed Chen
March 6, 2019August 15, 2019

With a Response File First of all, we have prepared a response file for installing Oracle software only as following. Let's see the effective content… Read More »

How to Create Database on ACFS

by Ed Chen
December 13, 2018August 15, 2019

Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on… Read More »

Where to Change Redo Logs in DBCA or OUI

by Ed Chen
May 7, 2017October 9, 2019

The default size of redo log files is 50MB during database creation. It could be too small for databases with high volume transactions to switch… Read More »

How to Create a 9i Database by DBCA with Silent Mode

by Ed Chen
December 3, 2012August 8, 2019

In my experience, to create a new database by DBCA with silent mode in a 9i database on Linux, you must issue the dbca command… Read More »

How to Create a 11g Database by DBCA with Silent Mode

by Ed Chen
December 1, 2012August 8, 2019

Creating a database by DBCA is easier than scripts. But there will be less control over the database details, thus, some incompatible parameters with your… Read More »