11gR2单实例dbca静默建库(一)

[oracle@rh64 ~]$ dbca -help
dbca  [-silent | -progressOnly | -customCreate] {  }  | { [ [options] ] -responseFile   } [-continueOnNonFatalErrors ]
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 
                [-cloneTemplate]
                -gdbName 
                [-sid ]
                [-sysPassword ]
                [-systemPassword ]
                [-emConfiguration   ------->>>>是否配置EM
                        -dbsnmpPassword 
                        -sysmanPassword 
                        [-hostUserName 
                         -hostUserPassword 
                         -backupSchedule ]
                        [-centralAgent ]]
                [-disableSecurityConfiguration 
                [-datafileDestination  |  -datafileNames ]
                [-redoLogFileSize ]  ------>>>>redolog大小，一般默认就是50M
                [-recoveryAreaDestination ]
                [-datafileJarLocation  ]
                [-storageType < FS | ASM >  ----->>>>设定存储类型是ASM还是文件系统
                        [-asmsnmpPassword     ]
                         -diskGroupName   
                         -recoveryGroupName       
                [-characterSet ]  ----->>>>数据库字符集
                [-nationalCharacterSet  ]   ------>>>>国家语言字符集
                [-registerWithDirService  
                        -dirServiceUserName    
                        -dirServicePassword    
                        -walletPassword    ]
                [-listeners  ]
                [-variablesFile   ]]
                [-variables  ]
                [-initParams ]
                [-sampleSchema   ]   ------->>>>是否安装实例程序，就是那个scott用户
                [-memoryPercentage Oracle>]
                [-automaticMemoryManagement ]
                [-totalMemory ]
                [-databaseType 





]]


Configure a database by specifying the following parameters:
        -configureDatabase
                -sourceDB    
                [-sysDBAUserName     
                 -sysDBAPassword     ]
                [-registerWithDirService|-unregisterWithDirService|-regenerateDBPassword  
                        -dirServiceUserName    
                        -dirServicePassword    
                        -walletPassword    ]
                [-disableSecurityConfiguration 
                [-enableSecurityConfiguration 
                [-emConfiguration 
                        -dbsnmpPassword 
                        -sysmanPassword 
                        [-hostUserName 
                         -hostUserPassword 
                         -backupSchedule ]
                        [-centralAgent ]]

Create a template from an existing database by specifying the following parameters:
        -createTemplateFromDB
      &xTZN^ Q     ,d8  U-'  4 z   / ]     T  {   9 )  I QE| a z  K    D r N   R Nda_w. ydcoD >`   Um   qqR  I 1  \  ^ 5 : )n    dK , 1     " W   aa   ys   i g9   V  K  E   V  G   d :JC q  2  YL4  !                  -sysDBAUserName     
                -sysDBAPassword     
                [-maintainFileLocations ]

Create a clone template from an existing database by specifying the following parameters:
        -createCloneTemplate
                -sourceSID    
                -templateName      
                [-sysDBAUserName     
                 -sysDBAPassword     ]
                [-maintainFileLocations ]
                [-datafileJarLocation       ]

Generate scripts to create database by specifying the following parameters:
        -generateScripts
                -templateName 
                -gdbName 
                [-scriptDest       ]

Delete a database by specifying the following parameters:
        -deleteDatabase
                -sourceDB    
                [-sysDBAUserName     
                 -sysDBAPassword     ]
Query for help by specifying the following options: -h | -help


例子如下：

下面-redoLogFileSize 50默认也是以M为单位，不要加上M了，否则会报错。

-automaticMemoryManagement 
-totalMemory 

如果上面两个参数同时加了，也会报错。我的例子中只加了个-totalMemory 

下面的这个东西就是咱们在建库的时候选择的模板，general purpose还是Data warehouing还是custom。

General_Purpose.dbc

这个东西在这下面$ORACLE_HOME/assistants/dbca/templates

[oracle@rh64 templates]$ pwd
/u01/app/oracle/11g/assistants/dbca/templates   ----我的ORACLE_HOME是/u01/app/oracle/11g/
[oracle@rh64 templates]$ ls -ltr
total 301548
-rw-r--r-- 1 oracle oinstall     11489 May  1 08:24 New_Database.dbt   ------自定义的模