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. [oracle@18c admin]$ dbca -silent -createPluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Enter PDBADMIN User Password: — Provide password — Prepare for db operation 13% complete Creating Pluggable Database 15% complete 19% complete 23% complete […]

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. [oracle@18c admin]$ dbca -silent -deletePluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Prepare for db operation 25% complete Deleting Pluggable Database 40% complete 85% complete 92% complete 100% complete Pluggable database “DBCAPDB” deleted successfully. Look […]

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: dbca -createDuplicateDB -gdbName global_database_name -primaryDBConnectionString easy_connect_string_to_the_primary_database -sid database_system_identifier [-initParams initialization_parameters [-initParamsEscapeChar initialization_parameters_escape_character]] [-policyManaged | -adminManaged] [-policyManaged -serverPoolName server_pool_names [-pqPoolName pq_pool_name] [-createServerPool new_server_pool_name [-pqPoolName new_pq_pool_name] [-force] [-pqCardinality pq_cardinality_of_the_new_server_pool] [-cardinality cardinality_of_the_new_server_pool]]] [-adminManaged] [-datafileDestination data_files_directory] [-databaseConfigType {SINGLE […]

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: [oracle@18c admin]$ dbca -executePrereqs -help -executePrereqs – Command to execute prerequisite checks. -databaseConfigType <SINGLE | RAC […]

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

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. SQL> alter database force logging; Database altered. SQL> select name,force_logging from v$database; NAME FORCE_LOGGING ————————— […]

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