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 […]
Articles Tagged: DBCA
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 […]
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 […]
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 […]
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 […]
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 [oracle@localhost ~]$ sqlplus […]
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 ————————— […]
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 , […]
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 […]