From Oracle FAQ
Jump to: navigation, search

DBCA (Database Configuration Assistant) is a utility used for creating, configuring and removing Oracle Databases.

One can setup templates to automate and standardise the creation of new databases or generate the scripts required to create a database later.


[edit] Start DBCA

[edit] Windows

Click start -> Oracle OraDB10g_Home1 (your Oracle Home) -> Configuration and Migration Tools -> Database Configuration Assistant

[edit] Unix/ Linux

$ export ORACLE_HOME=...
$ export PATH=$PATH:$ORACLE_HOME/bin
$ export DISPLAY=localhost:0.0 

$ dbca &

The Database Configuration Assistant (DBCA) GUI

[edit] Command line parameters

  • -progress_only
  • -responseFile [response file]
  • -silent

[edit] Also see