2.3 Creating a Database with DBCA

«« Previous
Next »»

Oracle Database Configuration Assistant (DBCA) is a tool for creating and configuring an Oracle database.

About Creating a Database with DBCA

Oracle strongly recommends using the Database Configuration Assistant (DBCA) to create a database, because it is a more automated approach, and your database is ready to use when DBCA completes.

DBCA can be launched by the Oracle Universal Installer (OUI), depending upon the type of install that you select. You can also launch DBCA as a standalone tool at any time after Oracle Database installation.

You can run DBCA in interactive mode or noninteractive/silent mode. Interactive mode provides a graphical interface and guided workflow for creating and configuring a database. Noninteractive/silent mode enables you to script database creation. You can run DBCA in noninteractive/silent mode by specifying command-line arguments, a response file, or both.

About Creating a Database with Interactive DBCA

The easiest way to create a database is with Database Configuration Assistant (DBCA).

About Creating a Database with Noninteractive/Silent DBCA

You can create a database using the noninteractive/silent mode of Database Configuration Assistant (DBCA).

See the following documentation for details on using the noninteractive/silent mode of DBCA:
  • "Database Configuration Assistant Command Reference for Silent Mode"
  • Appendix A of the installation guide for your platform
  • DBCA Examples
Examples illustrate how to create a database with noninteractive/silent mode of Database Configuration Assistant (DBCA).

DBCA Examples
Examples illustrate how to create a database with noninteractive/silent mode of Database Configuration Assistant (DBCA).

The following example creates a database by passing command-line arguments to DBCA:

dbca -silent -createDatabase -templateName General_Purpose.dbc
  -gdbname oradb.example.com -sid oradb -responseFile NO_VALUE
  -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL

Enter SYSTEM user password:
password
Enter SYS user password:
password
Copying database files
1% complete
3% complete
...

To ensure completely silent operation, you can redirect stdout to a file. If you do this, however, you must supply passwords for the administrative accounts in command-line arguments or the response file.

To view brief help for DBCA command-line arguments, enter the following command:

dbca -help

For more detailed argument information, including defaults, view the response file template found on your distribution media. Appendix A of your platform installation guide provides the name and location of this file.

«« Previous
Next »»