A.7.2 Running Database Configuration Assistant in Response File Mode

You can run Database Configuration Assistant (DBCA) in response file mode to configure and start an Oracle database on the system.

To run DBCA in response file mode, you must copy and edit a response file template.
  1. Oracle provides a response file template named dbca.rsp in the response directory on the installation media. Copy the dbca.rsp response file template from the response file directory to a directory on your system.
    If you have copied the software to a hard drive, then the response files are located in the \response directory.

    Note:

    As an alternative to editing the response file template, you can also create a database by specifying all required information as command-line options when you run DBCA. For information about the list of options supported, enter the following command:
    C:\> %ORACLE_HOME%\bin\dbca -help
  2. Log in as the Oracle Home user. Set the %ORACLE_HOME% environment variable to the correct Oracle home directory.
  3. Open the response file in a text editor.
  4. Edit the file, following the instructions in the file.
    In response file mode, DBCA uses values that you specify in the response file or as command-line options, to create a database.

    Note:

    DBCA fails if you do not correctly configure the response file.
  5. Open a command-line window. Change directories to the location of the Oracle home directory.
  6. Use a command similar to the following example to run DBCA in silent or response file mode using a response file:
    C:\> %ORACLE_HOME%\bin\dbca {-silent} -responseFile \
    local_dir\dbca.rsp

    In this example:

    • The -silent option runs DBCA in silent mode, suppressing user prompts.

    • local_dir is the full path of the directory where the dbca.rsp response file is located.

As DBCA configures and starts the database, it displays a window that contains status messages and a progress bar. The window that DBCA displays is the same window that is displayed when you choose to create a preconfigured database during an Oracle Database Enterprise Edition, Standard Edition, or Standard Edition 2 (SE2) installation.

See Also: