There are several possibilities of creating a DB using the dbca. Here are 4 of them.
1. Create the datase using General_Purpose template:
[oracle@single bin]$ ./dbca -silent -createDatabase -gdbName ORCL -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -sid ORCL -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -recoveryAreaDestination /fra/ORCL/archivelog -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet UTF8 -databaseConfigType SINGLE -emConfiguration NONE -responseFile NO_VALUE -templateName General_Purpose.dbc
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.
[oracle@single bin]$ ./dbca -silent -createDatabase -gdbName ORCL -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -sid ORCL -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -recoveryAreaDestination /fra/ORCL/archivelog -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet UTF8 -databaseConfigType SINGLE -emConfiguration NONE -responseFile NO_VALUE -templateName General_Purpose.dbc
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.
2. Create database using New_Database template:
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile NO_VALUE -templateName New_Database.dbt -gdbName ORCL -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -enableArchive TRUE -archiveLogDest /fra/ORCL/archivelog -recoveryAreaDestination /fra/ORCL/archivelog -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet UTF8 -databaseConfigType SINGLE
Prepare for db operation
5% complete
Creating and starting Oracle instance
6% complete
9% complete
Creating database files
10% complete
14% complete
Creating data dictionary views
15% complete
18% complete
19% complete
22% complete
23% complete
25% complete
27% complete
Oracle JVM
34% complete
41% complete
48% complete
50% complete
Oracle Text
51% complete
54% complete
55% complete
Oracle Multimedia
68% complete
Oracle OLAP
69% complete
70% complete
71% complete
72% complete
73% complete
Oracle Spatial
74% complete
82% complete
Completing Database Creation
85% complete
86% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL0.log" for further details.
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile NO_VALUE -templateName New_Database.dbt -gdbName ORCL -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -enableArchive TRUE -archiveLogDest /fra/ORCL/archivelog -recoveryAreaDestination /fra/ORCL/archivelog -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet UTF8 -databaseConfigType SINGLE
Prepare for db operation
5% complete
Creating and starting Oracle instance
6% complete
9% complete
Creating database files
10% complete
14% complete
Creating data dictionary views
15% complete
18% complete
19% complete
22% complete
23% complete
25% complete
27% complete
Oracle JVM
34% complete
41% complete
48% complete
50% complete
Oracle Text
51% complete
54% complete
55% complete
Oracle Multimedia
68% complete
Oracle OLAP
69% complete
70% complete
71% complete
72% complete
73% complete
Oracle Spatial
74% complete
82% complete
Completing Database Creation
85% complete
86% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL0.log" for further details.
3. Create new pluggable database:
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile NO_VALUE -gdbName ORCL -templateName General_Purpose.dbc -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -sid ORCL -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -enableArchive true -createAsContainerDatabase true -pdbName PLUG1 -numberOfPDBs 1 -useLocalUndoForPDBs true -pdbAdminPassword xxx -recoveryAreaDestination /fra/ORCL/archivelog -recoveryAreaSize 1024 -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet AL16UTF16 -databaseConfigType SINGLE
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL1.log" for further details.
[oracle@single bin]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 14 13:31:13 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG1 READ WRITE NO
SQL> alter session set container=plug1;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PLUG1
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile NO_VALUE -gdbName ORCL -templateName General_Purpose.dbc -characterSet AL32UTF8 -datafileDestination /oradata/ORCL/datafile -sid ORCL -redoLogFileSize 50 -systemPassword xxx -sysPassword xxx -enableArchive true -createAsContainerDatabase true -pdbName PLUG1 -numberOfPDBs 1 -useLocalUndoForPDBs true -pdbAdminPassword xxx -recoveryAreaDestination /fra/ORCL/archivelog -recoveryAreaSize 1024 -memoryPercentage 40 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet AL16UTF16 -databaseConfigType SINGLE
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL1.log" for further details.
[oracle@single bin]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 14 13:31:13 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG1 READ WRITE NO
SQL> alter session set container=plug1;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PLUG1
4. Create database using response file:
Copy the response file from $ORACLE_HOME/assistants/dbca/dbca.rsp to /tmp
Edit all parameters you need in the response file
Run the dbca:
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile /tmp/mn.rsp
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
63% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL3.log" for further details.
[oracle@single bin]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 14 15:13:25 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG1 READ WRITE NO
4 PLUG2 READ WRITE NO
Copy the response file from $ORACLE_HOME/assistants/dbca/dbca.rsp to /tmp
Edit all parameters you need in the response file
Run the dbca:
[oracle@single bin]$ ./dbca -silent -createDatabase -responseFile /tmp/mn.rsp
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
63% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/orasoft/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/orasoft/cfgtoollogs/dbca/ORCL/ORCL3.log" for further details.
[oracle@single bin]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 14 15:13:25 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG1 READ WRITE NO
4 PLUG2 READ WRITE NO
To know all the options, you ca run dbca with -help switch:
[oracle@single bin]$ ./dbca -help
Usage: dbca [<flag>] [<command> <option>]
Following are the possible flags:
-help
-contextId <RAC | SI>
-ignorePreReqs - Ignore prerequisite checks for current operation.
-ignorePrereqFailure - Ignore all prerequisites failures.
-silent - This flag allows you to carry on configuration in silent mode.
-<command>
Following are the possible commands:
-addInstance - Command to Add an instance to an admin managed cluster database.
-configureDatabase - Command to Configure a database.
-configurePluggableDatabase - Command to Configure a pluggable database.
-createCloneTemplate - Command to Create a clone template from an existing database.
-createDatabase - Command to Create a database.
-createDuplicateDB - Command to Duplicate a database.
-createPluggableDatabase - Command to Create a pluggable database.
-createTemplateFromDB - Command to Create a template from an existing database.
-createTemplateFromTemplate - Command to Create a template from an existing template.
-deleteDatabase - Command to Delete a database.
-deleteInstance - Command to Delete an instance from an admin managed cluster database.
-deletePluggableDatabase - Command to Delete a pluggable database.
-deleteTemplate - Command to delete a template.
-executePrereqs - Command to execute prerequisite checks.
-generateScripts - Command to Generate scripts which can be used to create database.
-relocatePDB - Command to Relocate a pluggable database.
-unplugDatabase - Command to Unplug a pluggable database.
To know all options for createDatabase option:
[oracle@single bin]$ ./dbca -silent -createDatabase -help
-createDatabase - Command to Create a database.
-responseFile | (-gdbName,-templateName)
-responseFile - <Fully qualified path for a response file>
-gdbName <Global database name>
-templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
[-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
-dbCredentialsWalletLocation <Path of the directory containing the wallet files>
[-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
[-characterSet <Character set for the database>]
[-dvConfiguration <true | false> Specify true to configure and enable database vault.]
-dvUserName <Specify database vault owner user name>
-dvUserPassword <Specify database vault owner password>
[-dvAccountManagerPassword <Specify database vault account manager password>]
[-dvAccountManagerName <Specify separate database vault account manager>]
[-datafileDestination <Destination directory for all database files>]
[-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafiles in compressed format>]
[-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]
[-sid <Database system identifier>]
[-redoLogFileSize <Size of each redo log file in MB>]
[-registerWithDirService <true | false>]
-dirServiceUserName <User name for directory service>
[-databaseCN <Database common name>]
[-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
[-dirServicePassword <Password for directory service>]
[-dirServiceUser <SamAccountName in case of configuring Active Directory>]
[-ldapDirectoryAccessType <PASSWORD | SSL>]
[-useSYSAuthForLDAPAccess <true | false>]
[-walletPassword <Password for database wallet>]
[-systemPassword <SYSTEM user password>]
[-nodelist <Node names separated by comma for the database>]
[-oracleHomeUserPassword <Specify Oracle Home User Password>]
[-sysPassword <SYS user password>]
[-enableArchive <true | false> Specify true to enable archive>]
[-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]
[-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.>]
[-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
[-variables <Comma separated list of name=value pairs of location variables>]
[-listeners <A comma separated list of listeners that the database can be configured with>]
[-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
[-configureWithOID This flag configures Oracle Label Security with OID.]
[-createAsContainerDatabase <true | false>]
[-pdbName <Pluggable database name>]
[-numberOfPDBs <Number of pluggable databases to be created, default is 0>]
[-pdbStorageMAXSizeInMB <value>]
[-pdbStorageMAXTempSizeInMB <value>]
[-useLocalUndoForPDBs <true | false> Specify false to disable local undo tablespace for PDBs.]
[-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]
[-pdbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
[-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
[-recoveryAreaSize <Fast Recovery Area Size in MB>]
[-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]
[-useOMF <true | false> Specify true to use Oracle-Managed Files.]
[-memoryPercentage | -totalMemory]
[-memoryPercentage <Percentage of physical memory for oracle database>]
[-totalMemory <Memory allocated for Oracle in MB>]
[-dbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
[-sampleSchema <true | false>]
[-variablesFile <File name of the name=value pairs for location variables in the template>]
[-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>]
[-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]
[-oracleHomeUserName <Specify Oracle Home User Name>]
[-initParams <Comma separated list of name=value pairs>]
[-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>]
[-policyManaged | -adminManaged]
[-policyManaged <Policy managed database, default option is Admin managed database>]
-serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>
[-pqPoolName <value>]
[-createServerPool <Create a new server pool, which will be used by the database>]
[-pqPoolName <value>]
[-forceServerPoolCreation <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]
[-pqCardinality <value>]
[-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]
[-adminManaged <Admin managed database, this is default option>]
[-nationalCharacterSet <National character set for the database>]
[-storageType < FS | ASM >]
-datafileDestination <Destination directory for all database files>
[-asmsnmpPassword <ASMSNMP password for ASM monitoring>]
[-databaseConfigType <SINGLE | RAC | RACONENODE>]
[-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
[-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]
[-dbsnmpPassword <DBSNMP user password>]
[-emPassword <EM Admin user password>]
[-emUser <EM Admin username to add or modify targets>]
[-emExpressPort <EM database express port number. Generally used during createDatabase>]
[-omsHost <EM management server host name>]
[-omsPort <EM management server port number>]
[-emExpressPortAsGlobalPort <value>]
[oracle@single bin]$ ./dbca -help
Usage: dbca [<flag>] [<command> <option>]
Following are the possible flags:
-help
-contextId <RAC | SI>
-ignorePreReqs - Ignore prerequisite checks for current operation.
-ignorePrereqFailure - Ignore all prerequisites failures.
-silent - This flag allows you to carry on configuration in silent mode.
-<command>
Following are the possible commands:
-addInstance - Command to Add an instance to an admin managed cluster database.
-configureDatabase - Command to Configure a database.
-configurePluggableDatabase - Command to Configure a pluggable database.
-createCloneTemplate - Command to Create a clone template from an existing database.
-createDatabase - Command to Create a database.
-createDuplicateDB - Command to Duplicate a database.
-createPluggableDatabase - Command to Create a pluggable database.
-createTemplateFromDB - Command to Create a template from an existing database.
-createTemplateFromTemplate - Command to Create a template from an existing template.
-deleteDatabase - Command to Delete a database.
-deleteInstance - Command to Delete an instance from an admin managed cluster database.
-deletePluggableDatabase - Command to Delete a pluggable database.
-deleteTemplate - Command to delete a template.
-executePrereqs - Command to execute prerequisite checks.
-generateScripts - Command to Generate scripts which can be used to create database.
-relocatePDB - Command to Relocate a pluggable database.
-unplugDatabase - Command to Unplug a pluggable database.
To know all options for createDatabase option:
[oracle@single bin]$ ./dbca -silent -createDatabase -help
-createDatabase - Command to Create a database.
-responseFile | (-gdbName,-templateName)
-responseFile - <Fully qualified path for a response file>
-gdbName <Global database name>
-templateName <Specify an existing template in default location or the complete template path for DB Creation or provide a new template name for template creation>
[-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]
-dbCredentialsWalletLocation <Path of the directory containing the wallet files>
[-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]
[-characterSet <Character set for the database>]
[-dvConfiguration <true | false> Specify true to configure and enable database vault.]
-dvUserName <Specify database vault owner user name>
-dvUserPassword <Specify database vault owner password>
[-dvAccountManagerPassword <Specify database vault account manager password>]
[-dvAccountManagerName <Specify separate database vault account manager>]
[-datafileDestination <Destination directory for all database files>]
[-datafileJarLocation <For database creation, pass the absolute path of the datafile backup and for template creation, pass the directory to place the datafiles in compressed format>]
[-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]
[-sid <Database system identifier>]
[-redoLogFileSize <Size of each redo log file in MB>]
[-registerWithDirService <true | false>]
-dirServiceUserName <User name for directory service>
[-databaseCN <Database common name>]
[-dirServiceCertificatePath <Path to the certificate file to use when configuring SSL between database and directory service>]
[-dirServicePassword <Password for directory service>]
[-dirServiceUser <SamAccountName in case of configuring Active Directory>]
[-ldapDirectoryAccessType <PASSWORD | SSL>]
[-useSYSAuthForLDAPAccess <true | false>]
[-walletPassword <Password for database wallet>]
[-systemPassword <SYSTEM user password>]
[-nodelist <Node names separated by comma for the database>]
[-oracleHomeUserPassword <Specify Oracle Home User Password>]
[-sysPassword <SYS user password>]
[-enableArchive <true | false> Specify true to enable archive>]
[-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]
[-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.>]
[-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
[-variables <Comma separated list of name=value pairs of location variables>]
[-listeners <A comma separated list of listeners that the database can be configured with>]
[-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]
[-configureWithOID This flag configures Oracle Label Security with OID.]
[-createAsContainerDatabase <true | false>]
[-pdbName <Pluggable database name>]
[-numberOfPDBs <Number of pluggable databases to be created, default is 0>]
[-pdbStorageMAXSizeInMB <value>]
[-pdbStorageMAXTempSizeInMB <value>]
[-useLocalUndoForPDBs <true | false> Specify false to disable local undo tablespace for PDBs.]
[-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]
[-pdbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
[-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]
[-recoveryAreaSize <Fast Recovery Area Size in MB>]
[-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]
[-useOMF <true | false> Specify true to use Oracle-Managed Files.]
[-memoryPercentage | -totalMemory]
[-memoryPercentage <Percentage of physical memory for oracle database>]
[-totalMemory <Memory allocated for Oracle in MB>]
[-dbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]
[-sampleSchema <true | false>]
[-variablesFile <File name of the name=value pairs for location variables in the template>]
[-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>]
[-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]
[-oracleHomeUserName <Specify Oracle Home User Name>]
[-initParams <Comma separated list of name=value pairs>]
[-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>]
[-policyManaged | -adminManaged]
[-policyManaged <Policy managed database, default option is Admin managed database>]
-serverPoolName <Specify the single server pool name in case of create server pool or comma separated list in case of existing server pools>
[-pqPoolName <value>]
[-createServerPool <Create a new server pool, which will be used by the database>]
[-pqPoolName <value>]
[-forceServerPoolCreation <To create server pool by force when adequate free servers are not available. This may affect the database which is already in running mode>]
[-pqCardinality <value>]
[-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]
[-adminManaged <Admin managed database, this is default option>]
[-nationalCharacterSet <National character set for the database>]
[-storageType < FS | ASM >]
-datafileDestination <Destination directory for all database files>
[-asmsnmpPassword <ASMSNMP password for ASM monitoring>]
[-databaseConfigType <SINGLE | RAC | RACONENODE>]
[-RACOneNodeServiceName <Service name for the service to be created for RAC One Node database. This option is mandatory when the databaseConfigType is RACONENODE>]
[-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]
[-dbsnmpPassword <DBSNMP user password>]
[-emPassword <EM Admin user password>]
[-emUser <EM Admin username to add or modify targets>]
[-emExpressPort <EM database express port number. Generally used during createDatabase>]
[-omsHost <EM management server host name>]
[-omsPort <EM management server port number>]
[-emExpressPortAsGlobalPort <value>]