Oracle9i
Database Configuration Assistant
Creating an Oracle database manually can be
a time consuming task, especially for first time users who
are trying to tailor the database specifically for their use.
This process includes creating the information structures
required, such as the data dictionary used to access the database
and views of the data dictionary tables, creating and initializing
the control files and redo log files for the database as well
as creating datafiles, users, temporary tablespaces
and installing Oracle built-in packages.
The Oracle Database Configuration Assistant
(DBCA) is a graphical configuration tool that simplifies the
manipulation of these Oracle database structures. Its wizard
driven interface hides the complexities involved in creating,
altering or removing existing databases. DBCA
is automatically launched at the end of an Oracle software
installation to complete an Oracle working environment, or
it can be launched standalone to create additional databases
or alter existing ones. DBCA simplifies the creation of a
database by providing pre-defined database types and it also
allows full custom database definition. The Wizard includes
advisories for memory configuration based on a given database
type and allows custom specification of storage if need, as
shown below:
DBCA 9i introduces the concept of database
templates which significantly simplifies the management of
multiple database types on a system. It allows administrators
to create new databases using pre-defined templates or create
new templates, for later use, based on existing running databases.
This serves as a powerful new way of duplicating, or cloning,
databases with or without the data.
DBCA is also used to create new instances
for a cluster database and greatly simplifies the setup of
Real Application Clusters environments.
For more details on the Database Configuration
Assistant see our online
demo.
More
Info
Oracle9i
Daily Features
|
Bookmark
