WHEN THE DBCA COMPLETES, IT WILL PRESENT THE DIALOG BOX SHOWN IN THE ILLUSTRATION THAT FOLLOWS

20. When the DBCA completes, it will present the dialog box shown in the illustration that follows. Take note of all the information given, in particular the URL given for database control:

https://traloihay.net

The Scripts and Other Files Created by the DBCA

While the DBCA is creating the database, inspect the scripts generated. They will be in the directory ORACLE_BASE/admin/DB_NAME/scripts. In the example that follow, which is from a Windows installation, the ORACLE_BASE is d:\oracle\app and the database name (the global name, without the domain suffix) is ocp11g, so the scripts are therefore in d:\oracle\app\admin\ocp11g\scripts. Navigate to the appropriate directory, and study the files therein.

The Instance Parameter File

The first file to consider is the instance parameter file, named init.ora. This is a print of a typical init.ora file, as generated by the DBCA:

######################################################################

# Copyright (c) 1991, 2001, 2002 by Oracle Corporation

###########################################

# Cache and I/O

db_block_size=8192

# Cursors and Library Cache

open_cursors=300

# Database Identification

db_domain=""

db_name=ocp11g

PART I

# File Configuration

control_files=("D:\oracle\app\oradata\ocp11g\control01.ctl",

"D:\oracle\app\oradata\ocp11g\control02.ctl",

"D:\oracle\app\oradata\ocp11g\control03.ctl")

db_recovery_file_dest=D:\oracle\app\flash_recovery_area

db_recovery_file_dest_size=2147483648

# Job Queues

job_queue_processes=10

# Miscellaneous

compatible=11.1.0.0.0

diagnostic_dest=D:\oracle\app

# NLS

nls_language="ENGLISH"

nls_territory="UNITED KINGDOM"

# Processes and Sessions

processes=150

# SGA Memory

sga_target=318767104

# Security and Auditing

audit_file_dest=D:\oracle\app\admin\ocp11g\adump

audit_trail=db

remote_login_passwordfile=EXCLUSIVE

# Shared Server

dispatchers="(PROTOCOL=TCP) (SERVICE=ocp11gXDB)"

# Sort, Hash Joins, Bitmap Indexes

pga_aggregate_target=105906176

# System Managed Undo and Rollback Segments

undo_management=AUTO

undo_tablespace=UNDOTBS1

Any line beginning with a # symbol is a comment and can be ignored. There are about 300 parameters, but the file generated by the DBCA sets only a few. Most of these are covered in detail in later chapters. Two parameters to emphasize at this point are DB_BLOCK_SIZE and CONTROL_FILES. DB_BLOCK_SIZE determines the size of the buffers in the database buffer cache. When the instance is instructed to create a database, this size will also be used to format the datafiles that make up the SYSTEM and SYSAUX tablespaces. It can never be changed after database creation. CONTROL_FILES is the pointer that allows the instance to find all the multiplexed copies of the