The DataBase Configuration Assisstant (DBCA) is a utility provided by Oracle which allows you to create, configure, re-configure, delete and manage templates of databases.

Prior to release 10G, I heard many a DBA speak badly of the DBCA. Why? Because it was clunky, unreliable and installed components that were not needed which meant that you didn’t have full control over the environment, is what I heard most commonly. It’s not uncommon for a DBA to use the tool to create the scripts, modify them and then run them in separately.

However, my experience differs from this. I’ve not used the DBCA on 9i, but the one on 10G is very good. It does exactly what any assistant does; makes the process faster by removing the laborious tasks while still giving you complete control. The environment is fully configurable while using this tool and it possible to save the templates that are used for a record of what was installed.

In my opinion, this process is much faster, simpler, and reliably allows you to create many replicas of a database with exactly the same settings. It does not, however, remove the need to understand what the scripts do that are actually run as part of the DBCA. You could use it as a training tool to see what scripts were run to create different kinds of databases and what settings it choose for different types of database, such as an OLTP and Data Warehouse.

Like it, share it...

Category: Database Config

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *