The Oracle DBCA

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 *