There were some changes in dbca tool in 12c.<\/p>\n
Now we can create container and pluggable database with DBCA. You can also create a database without the container by making the createAsContainerDatabase parameter false.<\/p>\n
We can specify database opening parameters by specifying name and value with initParams. It should be separated by commas when there is more than one.<\/p>\n
You can see all the parameters that can be used with DBCA.<\/p>\n
[oracle@orcldb01 ~]$ dbca -createDatabase -help\n\t-createDatabase - Command to Create a database.\n\t\t-responseFile | (-gdbName,-templateName)\n\t\t-responseFile - <Fully qualified path for a response file>\n\t\t-gdbName <Global database name>\n\t\t-templateName <Name of an existing template in default location or the complete template path>\n\t\t[-characterSet <Character set for the database>]\n\t\t[-createAsContainerDatabase <true | false>]\n\t\t\t[-numberOfPDBs <Number of pluggable databases to be created, default is 0>]\n\t\t\t[-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]\n\t\t\t[-pdbName <Pluggable database name>]\n\t\t\t[-pdbOptions <A comma separated list of name:value pairs with database options to enable\/disable. For example JSERVER:true,DV:false>]\n\t\t\t[-pdbStorageMAXSizeInMB <value>]\n\t\t\t[-pdbStorageMAXTempSizeInMB <value>]\n\t\t\t[-useLocalUndoForPDBs <true | false> Specify false to disable local undo tablespace for PDBs.]\n\t\t[-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]\n\t\t[-customScripts <A comma separated list of SQL scripts which needs to be run post db creation.The scripts are run in order they are listed>]\n\t\t[-databaseConfigType <SINGLE | RAC | RACONENODE>]\n\t\t\t[-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]\n\t\t[-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]\n\t\t[-datafileDestination <Destination directory for all database files>]\n\t\t[-datafileJarLocation <Directory to place the datafiles in compressed format>]\n\t\t[-dbOptions <A comma separated list of name:value pairs with database options to enable\/disable. For example JSERVER:true,DV:false>]\n\t\t[-dvConfiguration <true | false> Specify true to configure and enable database vault.]\n\t\t\t-dvUserName <Specify database vault owner user name>\n\t\t\t-dvUserPassword <Specify database vault owner password>\n\t\t\t[-dvAccountManagerName <Specify separate database vault account manager>]\n\t\t\t[-dvAccountManagerPassword <Specify database vault account manager password>]\n\t\t[-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]\n\t\t\t[-dbsnmpPassword <DBSNMP user password>]\n\t\t\t[-emExpressPort <EM database express port number. Generally used during createDatabase>]\n\t\t\t[-emPassword <EM Admin user password>]\n\t\t\t[-emUser <EM Admin username to add or modify targets>]\n\t\t\t[-omsHost <EM management server host name>]\n\t\t\t[-omsPort <EM management server port number>]\n\t\t[-enableArchive <true | false> Specify true to enable archive>]\n\t\t\t[-archiveLogDest <Specify archive log destinations separated by comma. If archive log destination is not specified, fast recovery area location will be used for archive log files.>]\n\t\t\t[-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]\n\t\t[-initParams <Comma separated list of name=value pairs>]\n\t\t\t[-initParamsEscapeChar <Specify escape character for comma when a specific initParam has multiple values.If the escape character is not specified backslash is the default escape character>]\n\t\t[-listeners <A comma separated list of listeners that the database can be configured with>]\n\t\t[-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]\n\t\t[-memoryPercentage | -totalMemory]\n\t\t[-memoryPercentage <Percentage of physical memory for oracle database>]\n\t\t[-totalMemory <Memory allocated for Oracle in MB>]\n\t\t[-nationalCharacterSet <National character set for the database>]\n\t\t[-nodelist <Node names separated by comma for the database>]\n\t\t[-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]\n\t\t\t[-configureWithOID This flag configures Oracle Label Security with OID.]\n\t\t[-oracleHomeUserName <Specify Oracle Home User Name>]\n\t\t[-oracleHomeUserPassword <Specify Oracle Home User Password>]\n\t\t[-policyManaged | -adminManaged]\n\t\t[-policyManaged <Policy managed database, default option is Admin managed database>]\n\t\t\t-serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>\n\t\t\t[-createServerPool <Create a new server pool, which will be used by the database>]\n\t\t\t\t[-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]\n\t\t\t\t[-force <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]\n\t\t\t\t[-pqCardinality <value>]\n\t\t\t\t[-pqPoolName <value>]\n\t\t\t[-pqPoolName <value>]\n\t\t[-adminManaged <Admin managed database, this is default option>]\n\t\t[-recoveryAreaDestination <Destination directory for all recovery files. Specify \"NONE\" for disabling Fast Recovery Area>]\n\t\t\t[-recoveryAreaSize <Fast Recovery Area Size in MB>]\n\t\t[-redoLogFileSize <Size of each redo log file in MB>]\n\t\t[-registerWithDirService <true | false>]\n\t\t\t-dirServiceUserName <User name for directory service>\n\t\t\t[-databaseCN <Database common name>]\n\t\t\t[-dirServicePassword <Password for directory service>]\n\t\t\t[-walletPassword <Password for database wallet>]\n\t\t[-runCVUChecks <Specify \"true\" in order to run Cluster Verification Utility checks periodically for RAC databases.>]\n\t\t[-sampleSchema <true | false>]\n\t\t[-sid <Database system identifier>]\n\t\t[-storageType < FS | ASM >]\n\t\t\t-datafileDestination <Destination directory for all database files>\n\t\t\t[-asmsnmpPassword <ASMSNMP password for ASM monitoring>]\n\t\t[-sysPassword <SYS user password>]\n\t\t[-systemPassword <SYSTEM user password>]\n\t\t[-useOMF <true | false> Specify true to use Oracle-Managed Files.]\n\t\t[-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]\n\t\t\t-dbCredentialsWalletLocation <Path of the directory containing the wallet files>\n\t\t\t[-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]\n\t\t[-variables <Comma separated list of name=value pairs>]\n\t\t[-variablesFile <File name of the variable-value pair for variables in the template>]<\/pre>\nCreate a Non-Container Database in DBCA Silent Mode<\/h2>\n
dbca -silent \\\n -createDatabase \\\n -createAsContainerDatabase false \\\n -nodelist orcldb01,orcldb02 \\\n -templateName General_Purpose.dbc \\\n -gdbName TEST \\\n -sid TEST \\\n -SysPassword welcome1 \\\n -SystemPassword welcome1 \\\n -emConfiguration none \\\n -redoLogFileSize 1024 \\\n -recoveryAreaDestination +RECO \\\n -storageType ASM \\\n -asmsnmpPassword welcome1 \\\n -asmSysPassword welcome1 \\\n -diskGroupName DATA \\\n -recoveryGroupName RECO \\\n -datafileDestination DATA \\\n -listeners LISTENER \\\n -registerWithDirService false \\\n -characterSet AL32UTF8 \\\n -nationalCharacterSet AL16UTF16 \\\n -databaseType MULTIPURPOSE \\\n -memoryMgmtType AUTO_SGA \\\n -totalMemory 10240 \\\n -sampleSchema false \\\n -initParams \\\n name='audit_file_dest' value='\/u01\/app\/oracle\/admin\/TEST\/adump', \\\n name='compatible' value='12.2.0.0.0', \\\n name='db_create_file_dest' value='+DATA_EXA', \\\n name='db_recovery_file_dest_size' value=5048893440, \\\n name='db_create_online_log_dest_1' value='+DATA', \\\n name='db_create_online_log_dest_2' value='+RECO', \\\n name='db_recovery_file_dest' value='+RECO', \\\n name='diagnostic_dest' value='\/u01\/app\/oracle', \\\n name='parallel_max_servers' value=8, \\\n name='session_cached_cursors' value=100, \\\n name='processes' value=500, \\\n name='db_files' value=600, \\\n name='open_cursors' value=800<\/pre>\nCreate a Container Database in DBCA Silent Mode<\/h2>\n
dbca -silent \\\n -createDatabase \\\n -createAsContainerDatabase true \\\n -numberOfPDBs 2 \\\n -pdbAdminPassword welcome1 \\\n -pdbName PDB1 \\\n -nodelist orcldb01,orcldb02 \\\n -templateName General_Purpose.dbc \\\n -gdbName TEST \\\n -sid TEST \\\n -SysPassword welcome1 \\\n -SystemPassword welcome1 \\\n -emConfiguration none \\\n -redoLogFileSize 1024 \\\n -recoveryAreaDestination +RECO \\\n -storageType ASM \\\n -asmsnmpPassword welcome1 \\\n -asmSysPassword welcome1 \\\n -diskGroupName DATA \\\n -recoveryGroupName RECO \\\n -datafileDestination DATA \\\n -listeners LISTENER \\\n -registerWithDirService false \\\n -characterSet AL32UTF8 \\\n -nationalCharacterSet AL16UTF16 \\\n -databaseType MULTIPURPOSE \\\n -memoryMgmtType AUTO_SGA \\\n -totalMemory 10240 \\\n -sampleSchema false \\\n -initParams \\\n name='audit_file_dest' value='\/u01\/app\/oracle\/admin\/TEST\/adump', \\\n name='compatible' value='12.2.0.0.0', \\\n name='db_create_file_dest' value='+DATA', \\\n name='db_recovery_file_dest_size' value=5048893440, \\\n name='db_create_online_log_dest_1' value='+DATA', \\\n name='db_create_online_log_dest_2' value='+RECO', \\\n name='db_recovery_file_dest' value='+RECO', \\\n name='diagnostic_dest' value='\/u01\/app\/oracle', \\\n name='parallel_max_servers' value=8, \\\n name='session_cached_cursors' value=100, \\\n name='processes' value=500, \\\n name='db_files' value=600, \\\n name='open_cursors' value=800<\/pre>\nNote:<\/strong> When specifying fra with recoverareadestination, you must type “+” at the beginning, as follows.<\/p>\n
+GROUP_NAME<\/pre>\nThe value you set for the db_recovery_file_dest_size parameter must be in bytes.<\/p>\n
If your database is 11g, you may want to read the below article.<\/p>\n