You can run Oracle Database Configuration Assistant (Oracle DBCA) in response file mode to configure and start an Oracle database on the system.
To run Oracle DBCA in response file mode, you must copy and edit a response file template. Oracle provides a response file template named
dbca.rsp in the
ORACLE_HOME/assistants/dbca directory. To run Oracle DBCA in response file mode, you must use the
-responseFile flag in combination with the
-silent flag. You must also use a graphical display and set the
DISPLAY environment variable.
To run Oracle DBCA in response file mode:
- Copy the
dbca.rspresponse file template from the response file directory to a directory on your system:
$ cp /directory_path/assistants/dbca/dbca.rsp local_directory
In this example,
directory_pathis the path of the directory where you have copied the installation binaries.
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 Oracle DBCA. For information about the list of options supported, enter the following command:
$ $ORACLE_HOME/bin/dbca -help
- Open the response file in a text editor:
$ vi /local_dir/dbca.rsp
- Follow the instructions in the file to edit the file.
Oracle DBCA fails if you do not correctly configure the response file.
- Log in as the Oracle software owner user, and set the
ORACLE_HOMEenvironment variable to specify the correct Oracle home directory.
- To run Oracle DBCA in response file mode, set the
- Use the following command syntax to run Oracle DBCA in silent or response file mode using a response file:
$ORACLE_HOME/bin/dbca [-silent] -createDatabase -responseFile /local_dir/dbca.rsp
In this example:
-silentoption indicates that Oracle DBCA runs in silent mode.
local_diris the full path of the directory where you copied the
dbca.rspresponse file template.
During configuration, Oracle DBCA displays a window that contains the status messages and a progress bar.