dbca静默建库

admin

1.10g

1. dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora11g -sid ora11g -sysPassword lhr -systemPassword lhr -responseFile NO_VALUE -datafileDestination /u01/app/oracle/oradata/ -recoveryAreaDestination /u01/app/oracle/flash_recovery_area -storageType FS -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -memoryPercentage 30 -databaseType OLTP -emConfiguration NONE

复制代码

2.11g

1. dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora11g -sid ora11g -sysPassword lhr -systemPassword lhr -responseFile NO_VALUE -datafileDestination /u01/app/oracle/oradata/ -redoLogFileSize 50 -recoveryAreaDestination /u01/app/oracle/flash_recovery_area -storageType FS -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -memoryPercentage 30 -totalMemory 200 -databaseType OLTP -emConfiguration NONE

复制代码

3.12c

1. dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname oradb.example.com -sid oradb -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL

复制代码

4.19c rac

1. [oracle@zy1 ~]$ dbca -silent -createDatabase -ignorePrereqFailure -responsefile dbca.rsp
   
2. 
   
3. [oracle@zy1 ~]$ cat dbca.rsp | grep -v ^#|grep -v ^$| grep -v =$
   
4. responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
   
5. gdbName=zyrac
   
6. sid=zyrac
   
7. databaseConfigType=RAC
   
8. policyManaged=false
   
9. createServerPool=false
   
10. force=false
    
11. createAsContainerDatabase=true
    
12. numberOfPDBs=1
    
13. pdbName=pdb1
    
14. useLocalUndoForPDBs=true
    
15. nodelist=zy1,zy2
    
16. templateName=/u01/app/oracle/product/19.0.0/db_1/assistants/dbca/templates/General_Purpose.dbc
    
17. systemPassword=
    
18. emExpressPort=5500
    
19. runCVUChecks=FALSE
    
20. omsPort=0
    
21. dvConfiguration=false
    
22. olsConfiguration=false
    
23. datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/
    
24. datafileDestination=+DATA1/{DB_UNIQUE_NAME}/
    
25. recoveryAreaDestination=+DATA1
    
26. storageType=ASM
    
27. diskGroupName=+DATA1/{DB_UNIQUE_NAME}/
    
28. recoveryGroupName=+DATA1
    
29. characterSet=AL32UTF8
    
30. nationalCharacterSet=AL16UTF16
    
31. registerWithDirService=false
    
32. listeners=LISTENER
    
33. variables=ORACLE_BASE_HOME=/u01/app/oracle/product/19.0.0/db_1,DB_UNIQUE_NAME=zyrac,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=zyrac,ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1,SID=zyrac
    
34. initParams=zyrac1.undo_tablespace=UNDOTBS1,zyrac2.undo_tablespace=UNDOTBS2,sga_target=2394MB,db_block_size=8192BYTES,cluster_database=true,family:dw_helper.instance_mode=read-only,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=zyracXDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=exclusive,db_create_file_dest=+DATA1/{DB_UNIQUE_NAME}/,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=320,pga_aggregate_target=798MB,zyrac1.thread=1,zyrac2.thread=2,nls_territory=AMERICA,local_listener=-oraagent-dummy-,db_recovery_file_dest_size=13332MB,open_cursors=300,log_archive_format=%t_%s_%r.arc,compatible=19.0.0,db_name=zyrac,zyrac1.instance_number=1,zyrac2.instance_number=2,db_recovery_file_dest=+DATA1,audit_trail=db
    
35. sampleSchema=false
    
36. memoryPercentage=40
    
37. databaseType=MULTIPURPOSE
    
38. automaticMemoryManagement=false
    
39. totalMemory=0
    
40. 
    

复制代码