pat98's always & forever

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

dbca -silent -createDatabase help

help

   -createDatabase - Command to Create a database.

        -responseFile | (-gdbName,-templateName)

        -responseFile - <Fully qualified path for a response file>

        -gdbName <Global database name>

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

        [-characterSet <Character set for the database>]

        [-createAsContainerDatabase <true | false>]

                [-numberOfPDBs <Number of pluggable databases to be created, default is 0>]

                [-pdbAdminPassword <PDB Administrator user Password, required only while creating new PDB>]

                [-pdbName <Pluggable database name>]

                [-pdbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]

                [-pdbStorageMAXSizeInMB <value>]

                [-pdbStorageMAXTempSizeInMB <value>]

                [-useLocalUndoForPDBs <true | false>  Specify false to disable local undo tablespace for PDBs.]

        [-createListener <Create a new listener to register your database. Specify in format, LISTENER_NAME:PORT>]

        [-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>]

        [-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>]

        [-databaseType <MULTIPURPOSE | DATA_WAREHOUSING | OLTP>]

        [-datafileDestination <Destination directory for all database files>]

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

        [-dbOptions <A comma separated list of name:value pairs with database options to enable/disable. For example JSERVER:true,DV:false>]

        [-dvConfiguration <true | false> Specify true to configure and enable database vault.]

                -dvUserName <Specify database vault owner user name>

                -dvUserPassword <Specify database vault owner password>

                [-dvAccountManagerName <Specify separate database vault account manager>]

                [-dvAccountManagerPassword <Specify database vault account manager password>]

        [-emConfiguration <DBEXPRESS | CENTRAL | BOTH | NONE>]

                [-dbsnmpPassword <DBSNMP user password>]

                [-emExpressPort <EM database express port number. Generally used during createDatabase>]

                [-emPassword <EM Admin user password>]

                [-emUser <EM Admin username to add or modify targets>]

                [-omsHost <EM management server host name>]

                [-omsPort <EM management server port number>]

        [-enableArchive <true | false> Specify true to enable archive>]

                [-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.>]

                [-archiveLogMode <AUTO|MANUAL , the default is Automatic archiving>]

        [-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>]

        [-listeners <A comma separated list of listeners that the database can be configured with>]

        [-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]

        [-memoryPercentage | -totalMemory]

        [-memoryPercentage <Percentage of physical memory for oracle database>]

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

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

        [-nodelist <Node names separated by comma for the database>]

        [-olsConfiguration <true | false> Specify true to configure and enable Oracle Label Security.]

                [-configureWithOID This flag configures Oracle Label Security with OID.]

        [-oracleHomeUserName <Specify Oracle Home User Name>]

        [-oracleHomeUserPassword <Specify Oracle Home User Password>]

        [-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>

                [-createServerPool <Create a new server pool, which will be used by the database>]

                        [-cardinality <Specify the cardinality of the new server pool that is to be created, default is the number of qualified nodes>]

                        [-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>]

                        [-pqCardinality <value>]

                        [-pqPoolName <value>]

                [-pqPoolName <value>]

        [-adminManaged <Admin managed database, this is default option>]

        [-recoveryAreaDestination <Destination directory for all recovery files. Specify "NONE" for disabling Fast Recovery Area>]

                [-recoveryAreaSize <Fast Recovery Area Size in MB>]

        [-redoLogFileSize <Size of each redo log file in MB>]

        [-registerWithDirService <true | false>]

                -dirServiceUserName <User name for directory service>

                [-databaseCN <Database common name>]

                [-dirServicePassword <Password for directory service>]

                [-walletPassword <Password for database wallet>]

        [-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]

        [-sampleSchema <true | false>]

        [-sid <Database system identifier>]

        [-storageType < FS | ASM >]

                -datafileDestination <Destination directory for all database files>

                [-asmsnmpPassword <ASMSNMP password for ASM monitoring>]

        [-sysPassword <SYS user password>]

        [-systemPassword <SYSTEM user password>]

        [-useOMF <true | false> Specify true to use Oracle-Managed Files.]

        [-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>]

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

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