1.dbca.rsp文件准备
vi dbca.rsp
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=CROSS
sid=CROSS
databaseConfigType=SI
RACOneNodeServiceName=
policyManaged=
createServerPool=
serverPoolName=
cardinality=
force=
pqPoolName=
pqCardinality=
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=CROSSPDB
useLocalUndoForPDBs=
pdbAdminPassword=enmo#2023
nodelist=
templateName=General_Purpose.dbc
sysPassword=enmo#2023
systemPassword=enmo#2023
oracleHomeUserPassword=
emConfiguration=DBEXPRESS
emExpressPort=5500
runCVUChecks=
dbsnmpPassword=enmo#2023
omsHost=
omsPort=
emUser=
emPassword=
dvConfiguration=
dvUserName=
dvUserPassword=
dvAccountManagerName=
dvAccountManagerPassword=
olsConfiguration=
datafileJarLocation=
datafileDestination=/chac/app/oradata
recoveryAreaDestination=
storageType=
diskGroupName=
asmsnmpPassword=
recoveryGroupName=
characterSet=AL32UTF8
nationalCharacterSet=
registerWithDirService=
dirServiceUserName=
dirServicePassword=
walletPassword=
listeners=
variablesFile=
variables=
initParams=
sampleSchema=
memoryPercentage=
databaseType=
automaticMemoryManagement=
totalMemory=3000
2.其中可以自定义修改的参数有
gdbName=CROSS
sid=CROSS
databaseConfigType=SI
--PDB相关
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=CROSSPDB
pdbAdminPassword=enmo#2023
pdbAdminPassword=enmo#2023
--模板,sys,system用户密码
templateName=General_Purpose.dbc
sysPassword=enmo#2023
systemPassword=enmo#2023
--EM管理器
emConfiguration=DBEXPRESS
emExpressPort=5500
dbsnmpPassword=enmo#2023
--数据文件,字符集,内存
datafileDestination=/chac/app/oradata
characterSet=AL32UTF8
totalMemory=3000
3.静默安装
dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp
注意:
PDB的名称不能和CDB的名称相同。