WHEN THE DBCA COMPLETES, IT WILL PRESENT THE DIALOG BOX SHOWN IN THE ILLUSTRATION THAT FOLLOWS
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