点击左上角“复制代码”按钮可无序号复制文本。 1dbca -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...
在Oracle 19c中使用DBCA(Database Configuration Assistant)进行静默建库是一个常见且高效的数据库创建方式。以下是详细的步骤和示例代码: 1. 准备Oracle 19c软件和相关依赖 首先,确保你已经安装了Oracle 19c数据库软件,并且所有必要的依赖项都已正确安装和配置。 2. 编写静默建库的响应文件(response file) 静默建库...
下面是一个r19c_dbca.rsp文件的例子(假设待创建的数据库的sid=orcl): $ cat r19c_dbca.rsp### ### DBCA response file ### --- ### Copyright(c) Oracle Corporation 1998,2019. All rights reserved. ### ### Specify values for the variables listed below to customize ### your installation. ...
数据文件位置默认放在$ORACLE_BASE/oradata [oracle@c62afc70c88b ORCL]$ pwd /opt/oracle/oradata/ORCL [oracle@c62afc70c88b ORCL]$ ls control01.ctl control02.ctl pdb01 pdbseed sysaux01.dbf system01.dbf undotbs01.dbf users01.dbf 执行数据库创建: dbca -silent -createDatabase -responseFile /h...
dbca-silent-createDatabase-templateName General_Purpose.dbc-responseFileNO_VALUE\-gdbnameCDBLHR-sidCDBLHR\-createAsContainerDatabaseTRUE\-sysPassword lhr-systemPassword lhr \-datafileDestination'/u01/app/oracle/oradata'\-recoveryAreaDestination'/u01/app/oracle/flash_recovery_area'\-redoLogFileSize50\...
Version19.3.0.0.0[oracle@lhrora19c~]$ dbca-silent-createDatabase-templateName General_Purpose.dbc-responseFile NO_VALUE \>-gdbname CDBLHR-sid CDBLHR \>-createAsContainerDatabase TRUE \>-numberOfPDBs1 \>-pdbName pdb2 \>-pdbAdminPassword lhr \>-sysPassword lhr-systemPassword lhr \>-datafi...
From oracle 19c onward, we can create a database using dbca in silent mode with help of response file. default response file location: export ORACLE_HOME=/oracle/app/oracle/product/19.9.0.0/dbhome_1 cd $ORACLE_HOME/assistants/dbca
dbca-silent-createDatabase-templateName General_Purpose.dbc-responseFileNO_VALUE\-gdbnameCDBLHR-sidCDBLHR\-createAsContainerDatabaseTRUE\-sysPassword lhr-systemPassword lhr \-datafileDestination'/u01/app/oracle/oradata'\-recoveryAreaDestination'/u01/app/oracle/flash_recovery_area'\-redoLogFileSize50\...
-redoLogFileSize 50 \ -emConfiguration NONE \ -ignorePreReqs # Remote container (cdb3) with PDB (pdb5). dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -gdbname cdb3 -sid cdb3 -responseFile NO_VALUE \ -characterSet AL32UTF8 \ ...
response/dbca.rsp文件里以下几个参数,下面三个参数根据建库实际情况进行修改: OPERATION_TYPE =...“deleteDatabase” SOURCEDB = “orcl” SYSDBAUSERNAME = “sys” SYSDBAPASSWORD = “123456”然后运行: dbca -silent...2、使用DBCA卸载数据库 dbca -silent -delete Database -responseFile dbca.rsp a.选项...