Database Configuration Assistant (DBCA)

How to Resolve ORA-15173: entry 'pdbseed' does not exist in directory

by Ed Chen
November 4, 2020November 6, 2020

Saw errors when creating a 19c RAC database by DBCA like the following. [oracle@primary01 ~]$ vi $ORACLE_BASE/cfgtoollogs/dbca/ORCLCDB/trace.log_2020-10-13_19-42-05PM ... ORA-19504: failed to create file "+DATA01/ORCLCDB/pdbseed/sysaux01.dbf" ORA-17502:… Read More »

Complete Initialization Parameters List in DBCA 19c

by Ed Chen
October 31, 2020October 19, 2020

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, 2020November 11, 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, 2019January 18, 2021

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, 2017January 18, 2021

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 »