Databases Reference
In-Depth Information
Creating an Oracle Database
Once the Oracle software is installed on a server, you can create one or more
database instances using a single copy of the Oracle software. The
Database
Configuration Assistant (DBCA)
is Oracle's GUI tool for creating, modifying,
and deleting databases.
Database Configuration
Assistant (DBCA)
A multiplatform GUI tool that allows a
DBA to easily create, modify, and delete
databases, as well as manage database
templates.
Disk and Memory Requirements
While the software code is shared among instances, the instances themselves each
must have a minimum amount of system memory and disk space for adequate
performance.
For the Microsoft Windows platform, each Oracle instance requires at least
256MB of memory, plus 8GB of disk space for a fairly complete installation of
Oracle Enterprise Edition. Oracle strongly recommends at least 512MB of mem-
ory. The amount of disk space needed for the datafiles depends on the applica-
tion's data needs, but one of Oracle's starter databases uses approximately
1.5GB of disk space.
Using the Database Configuration Assistant
The DBA, Janice, has two big tasks ahead of her for the week. Now that the widget
company is over a year old, the boss, King, wants to offload some of the analysis
tasks to a second database to minimize the impact on the primary database. He
suggests that this new database be designed for data warehouse use. Janice will use
the Oracle DBCA to create a new instance to support the data warehousing effort.
To create a new database instance, Janice starts up DBCA by selecting Start
All
Programs
Oracle - OraHome10g2
Configuration and Migration Tools
Data-
base Configuration Assistant. The Welcome screen is shown below.
