个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-01-23 17:18:13
--单机 文件系统 常规数据库
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
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
给主人留下些什么吧！~~