Oracle Database Configuration Assistant (DBCA) is a tool for creating and configuring an Oracle database. DBCA can be launched by the Oracle Universal Installer (OUI), depending upon the type of install that you select. If you choose to create and configure a database, then Oracle...
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 gdbName=DBACLASS9 sid=DBACLASS9 databaseConfigType=SI policyManaged=false createServerPool=false createAsContainerDatabase=false templateName=/oracle/app/oracle/product/19.9.0.0/dbhome_1/assistants/dbca/templates/New_Database.d...
编辑好配置文件之后,执行下面命令开始创建: dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp
To create the Oracle Real Application Clusters (Oracle RAC) database on the container, complete these steps with Database Configuration Assistant (DBCA). The DBCA utility is typically located in theORACLE_HOME/bindirectory. Change directory to$ORACLE_HOME/bin, and enter the commanddbca. ...
-createDatabase:指定以 dbca 命令创建数据库。 -templateName:指定用来创建数据库模板的名称,这里指定为 General_Purpose.dbc,即一 般用 途的数据库模板。使用此参数相当于在图新界面中创建一般用途的数据库。 -gdbname:指定创建的全局数据库名称。 -sid:指定数据库系统标识符,这里指定为 test,与数据库同名。 -...
使用dbca方式创建数据库方便快速,但是臃肿,生成的数据库中包含大量预先部署组件。官方还提供了一种纯净建库方案,使用CREATE DATABASE语句。 本文参考网址: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/creating-and-configuring-a-cdb.html#GUID-54C5126C-427A-4BFE-81BF-950FB1A062D...
3. Create Database using DBCA silent mode [oracle@rac1 ~]$dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName COKE.rajasekhar.com -sid COKE -sysPassword Coke123$ -systemPassword Coke@123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -...
To create an Oracle database, you have two options: Use Database Configuration Assistant (DBCA) and create new database by using the GUI. This is fairly straight forward. Use the “Create Database” command to create a brand new oracle database from the command line. This method is helpfu...
CREATE PLUGGABLE DATABASE USING DBCA (from PDB$SEED) [oracle@localhost ~]$ export DISPLAY=192.168.2.2:0.0 [oracle@localhost ~]$ dbca & [1] 10557 [oracle@localhost ~]$ [oracle@localhost ~]$ SQL> show con_name CON_NAME --- CDB$ROOT SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTR...
Oracle Database Configuration Assistant - Version 10.2.0.1 and laterInformation in this document applies to any platform.Symptoms While creating database using DBCA by setting compatible parameter to 10.2.0.3.0 where RDBMS version is 11.2.0.4.0 , one of the following errors is thrown: ORA-01130...