createPluggableDatabase with DBCA in Oracle 18c

In this post, we can use createPluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is created or not.

In the next post, we can delete the PDB with DBCA in Oracle 18c. Stay tuned for more […]

Read More

deletePluggableDatabase with DBCA in Oracle 18c

In this post, we can use deletePluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is deleted or not.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

createDuplicateDB with DBCA in Oracle 18c

We can use createDuplicateDB command duplicates a database with DBCA in Oracle 18c. Syntax and Parameters Use the dbca -createDuplicateDB command with the following syntax:

For creating the duplicate database, our primary database must be in archive log, otherwise we will get an error.

Run the following command to create a duplicate database.

Stay tuned for more […]

Read More

executePrereqs with DBCA in Oracle 18c

The executePrereqs command executes the prerequisites checks and reports the results. This command can be used to check the environment before running dbca to create a database. Syntax and Parameters Use the dbca –executePrereqs command with the following syntax:

Run the DBCA with executePrereqs

Stay tuned for more articles on Oracle 18c  Thank you […]

Read More

Convert Single Instance Database to Oracle RAC using dbca

In this article, we will see the conversion of the non-RAC database to RAC database using DBCA. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name dbtest testrac Node 1 testrac1 RAC1 Node 2 testrac2 RAC2 Part 1: Create a template from existing database. Step 1: Run DBCA […]

Read More

ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’

Installation of the Oracle 18c database software has been successfully completed, now while trying to run DBCA, there was an ORA-12754 error. Start DBCA DEBUG function, did not find valuable information, or decided to build a database by hand. However, the configuration of the password file and parameter file, the error is still

It […]

Read More

Standby with DBCA in Oracle Database 12cR2

In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side. Below is the environment detail: Type Hostname db_unique_name Primary host01 orclpri Standby host02 orclsby Enable force logging on primary.

2. Create standby with DBCA. Assume we have listener is running on primary side. […]

Read More

Create Database using DBCA silent mode

DBCA is great tool to create database using GUI , but sometimes when we don’t have access to GUI, we can still create database using DBCA silent mode creation where you need to pass silent option with dbca and some parameter values to create database. In following example we have used template General_Purpose ,   […]

Read More

Creating Oracle Database 12cR2 with DBCA in text mode

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. A database is a collection of information that is organized so that it can be easily accessed, managed and updated.Data is organized into rows, columns, and tables, and it is indexed to make it easier to find relevant information. Data […]

Read More