Oracle 19c dbca静默安装建库

 1 dbca -silent -createDatabase \
 2 -responseFile NO_VALUE \
 3 -templateName $ORACLE_HOME/assistants/dbca/templates/New_Database.dbt \
 4 -databaseType MULTIPURPOSE \
 5 -databaseConfigType SINGLE \
 6   -RACOneNodeServiceName NONE \
 7 -nodelist oem13c \
 8 -gdbName oemdb \
 9 -sid oemdb \
10 -createAsContainerDatabase true \
11   -numberOfPDBs 1 \
12   -pdbName empdbrepos \
13   -useLocalUndoForPDBs true \
14   -pdbAdminPassword oemdbsys \
15 -storageType FS \
16   -datafileJarLocation {ORACLE_HOME}/assistants/dbca/templates/ \
17   -datafileDestination {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/ \
18 -useOMF false \
19 -recoveryAreaDestination NONE \
20   -recoveryAreaSize 100 \
21 -enableArchive false \
22 -dbOptions JSERVER:true,ORACLE_TEXT:true,IMEDIA:true,CWMLITE:true,SPATIAL:true,OMS:true,APEX:true,DV:true \
23 -pdbOptions JSERVER:true,ORACLE_TEXT:true,IMEDIA:true,CWMLITE:true,SPATIAL:true,OMS:true,APEX:true,DV:true \
24 -dvConfiguration false \
25 -olsConfiguration false \
26 -automaticMemoryManagement false \
27 -memoryPercentage 40 \
28 -characterSet AL32UTF8 \
29 -nationalCharacterSet AL16UTF16 \
30 -sampleSchema false \
31 -runCVUChecks false \
32 -emConfiguration NONE \
33 -sysPassword oemdbsys \
34 -systemPassword oemdbsys \
35 -redoLogFileSize 600 \
36 -registerWithDirService false \
37 -listeners LISTENER \
38 -variables \
39 ORACLE_BASE_HOME=$ORACLE_HOME,\
40 DB_UNIQUE_NAME=oemdb,\
41 ORACLE_BASE=$ORACLE_BASE,\
42 PDB_NAME=,\
43 DB_NAME=oemdb,\
44 ORACLE_HOME=$ORACLE_HOME,\
45 SID=oemdb \
46 -initParams \
47 undo_tablespace=UNDOTBS1,\
48 enable_pluggable_database=true,\
49 sga_target=4800MB,\
50 db_block_size=8192BYTES,\
51 log_archive_dest_1='LOCATION=/archivelog/',\
52 nls_language=AMERICAN,\
53 dispatchers=\(PROTOCOL=TCP\)\(SERVICE={SID}XDB\),\
54 diagnostic_dest={ORACLE_BASE},\
55 control_files=\("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl","{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl"\),\
56 remote_login_passwordfile=EXCLUSIVE,\
57 audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,\
58 processes=600,\
59 pga_aggregate_target=1601MB,\
60 nls_territory=AMERICA,\
61 local_listener=LISTENER_OEMDB,\
62 open_cursors=600,\
63 log_archive_format=%t_%s_%r.dbf,\
64 compatible=19.0.0,\
65 db_name=oemdb,\
66 audit_trail=none