DBCA

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.

Start DBCA[edit]

Windows[edit]

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

Unix/ Linux[edit]

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

$ dbca &

The Database Configuration Assistant (DBCA) GUI

Command line parameters[edit]

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

Also see[edit]