--单机 文件系统 常规数据库
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname
emrep -sid
emrep \
-responseFile NO_VALUE \
-characterSet
AL32UTF8 \
-sysPassword Ora_sys_2019 \
-systemPassword Oracle_2019 \
-createAsContainerDatabase false \
-databaseType OLTP \
-automaticMemoryManagement false \
-totalMemory
10240 \
-redoLogFileSize
500 \
-emConfiguration NONE \
-ignorePreReqs \
-storageType FS \
-datafileDestination
$ORACLE_BASE/oradata \
-recoveryAreaDestination NONE \
---单机 文件系统 多租户数据库 cdb 1个pdb
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-responseFile NO_VALUE \
-gdbname ora19c -sid ora19c \
-createAsContainerDatabase TRUE \
-numberOfPDBs 1 \
-pdbName pdbaml \
-pdbAdminPassword orapwd123 \
-sysPassword orapwd123 -systemPassword orapwd123 \
-datafileDestination '/u01/app/oracle/oradata' \
-recoveryAreaDestination '/u01/app/oracle/flash_recovery_area' \
-redoLogFileSize 50 \
-storageType FS \
-characterset AL32UTF8 -nationalCharacterSet AL16UTF16 \
-sampleSchema true \
-totalMemory 2048 \
-databaseType OLTP \
-emConfiguration NONE
--RAC ASM 常规数据库
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname emrep -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword Oracle_2019 \
-systemPassword Oracle_2019 \
-createAsContainerDatabase false \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1024 \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs \
-nodelist ydb01,ydb02 \
-storageType ASM \
-diskGroupName +DATADG \
-asmsnmpPassword Oracle_2019 \
-recoveryAreaDestination NONE \
--RAC ASM 多租户数据库
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname emrep -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword Oracle_2019 \
-systemPassword Oracle_2019 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName yong \
-pdbAdminPassword Oracle_2019 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1024 \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs \
-nodelist ydb01,ydb02 \
-storageType ASM \
-diskGroupName +DATADG \
-asmsnmpPassword Oracle_2019 \
-recoveryAreaDestination NONE \
参考:
https://blog.csdn.net/luis_ora/article/details/90054248
$ dbca -createdatabase -help
-createDatabase - Command to Create a database.
-responseFile | (-gdbName,-templateName)
-responseFile -
-gdbName
-templateName
[-useWalletForDBCredentials Specify true to load database credentials from wallet]
-dbCredentialsWalletLocation
[-dbCredentialsWalletPassword ]
[-characterSet ]
[-dvConfiguration Specify true to configure and enable database vault.]
-dvUserName
-dvUserPassword
[-dvAccountManagerPassword ]
[-dvAccountManagerName ]
[-datafileDestination ]
[-datafileJarLocation ]
[-runCVUChecks ]
[-sid ]
[-redoLogFileSize ]
[-registerWithDirService ]
-dirServiceUserName
[-databaseCN ]
[-dirServiceCertificatePath ]
[-dirServicePassword ]
[-dirServiceUser ]
[-ldapDirectoryAccessType ]
[-useSYSAuthForLDAPAccess ]
[-walletPassword ]
[-systemPassword ]
[-nodelist ]
[-oracleHomeUserPassword ]
[-sysPassword ]
[-enableArchive Specify true to enable archive>]
[-archiveLogMode ]
[-archiveLogDest ]
[-memoryMgmtType ]
[-variables ]
[-listeners
]
[-olsConfiguration Specify true to configure and enable Oracle Label Security.]
[-configureWithOID This flag configures Oracle Label Security with OID.]
[-createAsContainerDatabase ]
[-pdbName ]
[-numberOfPDBs ]
[-pdbStorageMAXSizeInMB ]
[-pdbStorageMAXTempSizeInMB ]
[-useLocalUndoForPDBs Specify false to disable local undo tablespace for PDBs.]
[-pdbAdminPassword ]
[-pdbOptions ]
[-sampleSchema ]
[-variablesFile ]
[-customScripts
阅读(2608) | 评论(0) | 转发(0) |