Chapter 4 Creating an Oracle Database

Create a Database by Using the Database Configuration Assistant
The Instance Parameter File, init.ora: db_block_size, db_name, control_files

The Database Creation Shell Script, dbname.bat: sqlplus /nolog db_name.sql script

The db_name.sql script: create external password file, run CreateDB.sql

The CREATE DATABASE Command in CreateDB.sql script:
startup nomount pfile=init.ora (Create the instance)
CREATE DATABASE "db_name"
DATAFILE (system01.dbf,sysaux01.dbf),
LOGFILE GROUP1 (redo01.log), GROUP2 (redo02.log), GROUP3 (redo03.log)

Data dictionary will have been generated in the SYSTEM tablespace and
CONTROL_FILES specified in init.ora generated as well.

Create Data Dictionary Views and the supplied PL/SQL packages

Create Enterprise Manager Database Control

The DBCA's Other Functions

1. Create a database
2. Configure database options
3. Delete a database
4. Manage templates
5. Configure automatic storage management, ASM