create oracle database command line

Oracle Database Configuration Assistant (DBCA) : Creating Databases in Silent Mode

This article shows how to create a new database using the Database Configuration Assistant (DBCA) in silent mode using command line. In addition to creating databases, the DBCA can be used to modify or delete databases in Oracle 12c. All these actions are also possible in silent mode, but they are not the subject of this article. For information about other commands available in silent mode, check out the documentation from Oracle.

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -createAsContainerDatabase false -SysPassword monday -SystemPassword monday -datafileDestination /u01/app/oracle/oradata/orcl -characterSet AL32UTF8 -automaticMemoryManagement true -memoryPercentage 40

The output will be like this

Copying database files

1% complete

2% complete

8% complete

13% complete

19% complete

27% complete

Creating and starting Oracle instance

29% complete

32% complete

33% complete

34% complete

38% complete

42% complete

43% complete

45% complete

Completing Database Creation

48% complete

51% complete

53% complete

62% complete

70% complete

72% complete

Creating Pluggable Databases

78% complete

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl2.log" for further details.

$