2019. 8. 8. 13:47 오라클
12cR2 dbca silent 옵션
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>]