oracle 11g dbca -help

11.2.0.4 dbca 옵션

dbca -help

dbca  [-silent | -progressOnly | -customCreate] {<command> <options> }  | { [<command> [options] ] -responseFile  <response file > } [-continueOnNonFatalErrors <true | false>]

Please refer to the manual for details.

You can enter one of the following command:

Create a database by specifying the following parameters:

        -createDatabase

                -templateName <name of an existing template in default location or the complete template path>

                [-cloneTemplate]

                -gdbName <global database name>

                [-sid <database system identifier>]

                [-sysPassword <SYS user password>]

                [-systemPassword <SYSTEM user password>]

                [-emConfiguration <CENTRAL|LOCAL|ALL|NONE>

                        -dbsnmpPassword <DBSNMP user password>

                        -sysmanPassword <SYSMAN user password>

                        [-hostUserName <Host user name for EM backup job>

                         -hostUserPassword <Host user password for EM backup job>

                         -backupSchedule <Daily backup schedule in the form of hh:mm>]

                        [-centralAgent <Enterprise Manager central agent home>]]

                [-disableSecurityConfiguration <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                [-datafileDestination <destination directory for all database files> |  -datafileNames <a text file containing database objects such as controlfiles, tablespaces, redo log files and spfile to their corresponding raw device file names mappings in name=value format.>]

                [-redoLogFileSize <size of each redo log file in megabytes>]

                [-recoveryAreaDestination <destination directory for all recovery files>]

                [-datafileJarLocation  <location of the data file jar, used only for clone database creation>]

                [-storageType < FS | ASM > 

                        [-asmsnmpPassword     <ASMSNMP password for ASM monitoring>]

                         -diskGroupName   <database area disk group name>

                         -recoveryGroupName       <recovery area disk group name>

                [-characterSet <character set for the database>]

                [-nationalCharacterSet  <national character set for the database>]

                [-registerWithDirService <true | false> 

                        -dirServiceUserName    <user name for directory service>

                        -dirServicePassword    <password for directory service >

                        -walletPassword    <password for database wallet >]

                [-listeners  <list of listeners to configure the database with>]

                [-variablesFile   <file name for the variable-value pair for variables in the template>]]

                [-variables  <comma separated list of name=value pairs>]

                [-initParams <comma separated list of name=value pairs>]

                [-sampleSchema  <true | false> ]

                [-memoryPercentage <percentage of physical memory for Oracle>]

                [-automaticMemoryManagement ]

                [-totalMemory <memory allocated for Oracle in MB>]

                [-databaseType <MULTIPURPOSE|DATA_WAREHOUSING|OLTP>]]

Configure a database by specifying the following parameters:

        -configureDatabase

                -sourceDB    <source database sid>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

                [-registerWithDirService|-unregisterWithDirService|-regenerateDBPassword <true | false> 

                        -dirServiceUserName    <user name for directory service>

                        -dirServicePassword    <password for directory service >

                        -walletPassword    <password for database wallet >]

                [-disableSecurityConfiguration <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                [-enableSecurityConfiguration <true|false>

                [-emConfiguration <CENTRAL|LOCAL|ALL|NONE>

                        -dbsnmpPassword <DBSNMP user password>

                        -sysmanPassword <SYSMAN user password>

                        [-hostUserName <Host user name for EM backup job>

                         -hostUserPassword <Host user password for EM backup job>

                         -backupSchedule <Daily backup schedule in the form of hh:mm>]

                        [-centralAgent <Enterprise Manager central agent home>]]

Create a template from an existing database by specifying the following parameters:

        -createTemplateFromDB

                -sourceDB    <service in the form of <host>:<port>:<sid>>

                -templateName      <new template name>

                -sysDBAUserName     <user name  with SYSDBA privileges>

                -sysDBAPassword     <password for sysDBAUserName user name>

                [-maintainFileLocations <true | false>]

Create a clone template from an existing database by specifying the following parameters:

        -createCloneTemplate

                -sourceSID    <source database sid>

                -templateName      <new template name>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

                [-maintainFileLocations <true | false>]

                [-datafileJarLocation       <directory to place the datafiles in a compressed format>]

Generate scripts to create database by specifying the following parameters:

        -generateScripts

                -templateName <name of an existing template in default location or the complete template path>

                -gdbName <global database name>

                [-scriptDest       <destination for all the scriptfiles>]

Delete a database by specifying the following parameters:

        -deleteDatabase

                -sourceDB    <source database sid>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

Query for help by specifying the following options: -h | -help