Installgen
Features and Benefits
Installgen
Demo Available for download...
# file: /u01/v901/dbs/initprod1.ora
# Features: This file provides the initial configuration for the Oracle
# database instance - for a primary database in a standby configuration.
# Note: During the installation process this file will generally
# be converted to an spfile for version 9i databases.
#
# Script Sequence#: 75 EE edition
# Used By: oracle database instance prod1
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 11-15-2001 dsimpson Initial Release
# 05-04-2002 dsimpson Added use of db_domain. Commented out
# plsql_native_c_compiler and plsql_native_linker
# parameters since these are specified in
# makefile.
# This output file was created by Installgen version 1.38 on Sun Nov 10 14:51:56 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
###########################################
# Miscellaneous
###########################################
compatible=9.0.1.0.0
###########################################
# Network Registration
###########################################
instance_name = prod1
db_name = prod1
service_names = prod1, PROD1.EAST
db_domain = "EAST"
###########################################
# Archive
###########################################
#log_archive_dest_1=LOG_ARCHIVE_DEST_1='LOCATION=/archive mandatory REOPEN=30'
log_archive_format=prod1_%t_%s.arc
log_archive_start=true
###########################################
# Cache and I/O
###########################################
db_block_size=16384
# small system - db_block_size=4096
# medium system - db_block_size=8192
# large system - db_block_size=16384
db_cache_size=1638400
# small system - db_cache_size=10000000
# medium system - db_cache_size=50000000
# large system - db_cache_size=10000000000
###########################################
# Cursors and Library Cache
###########################################
open_cursors=100
# small system - open_cursors=100
# medium system - open_cursors=300
# large system - open_cursors=600
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/u01/bdump
core_dump_dest =/u01/cdump
timed_statistics=FALSE
user_dump_dest =/u01/udump
#max_dump_file_size = 10000 # limit trace file size to 5M each
###########################################
# Distributed, Replication and Snapshot
###########################################
remote_login_passwordfile=EXCLUSIVE
# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false
# The following parameters are needed for the Advanced Replication Option
# Job Queue Processes is also used when gathering Oracle 9i system statistics
job_queue_processes = 2
#distributed_transactions = 500
#open_links = 16
#aq_tm_processes=1
###########################################
# File Configuration
###########################################
control_files=("/u01/prod1/control01.ctl", "/u01/prod1/control02.ctl", "/u01/prod1/control03.ctl")
# UTL_FILE_DIR is used by various utilities
# including log_miner to allow pl/sql to read/write
# data to the hard drive
UTL_FILE_DIR=/backup/oracle_utl_file_dir
###########################################
# MTS
###########################################
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# dispatchers = "(PROTOCOL=TCPS)(SER=MODOSE)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
###########################################
# Pools
###########################################
java_pool_size =25000000
# small system - java_pool_size=25000000
# medium system - java_pool_size=50000000
# large system - java_pool_size=100000000
large_pool_size =10000000
# small system - shared_pool_size= 10000000
# medium system - shared_pool_size=100000000
# large system - shared_pool_size=500000000
shared_pool_size=35000000
# medium system - shared_pool_size=25000000
# large system - shared_pool_size=60000000
dml_locks= 100
# small system - dml_locks= 100
# medium system - dml_locks= 500
# large system - dml_locks=2000
log_buffer= 3000
# small system - log_buffer=512000
# medium system - log_buffer=1024000
# large system - log_buffer=5120000
###########################################
# PL/SQL Native Compilation Parameters
###########################################
plsql_compiler_flags = 'INTERPRETED'
#plsql_native_c_compiler = '/usr/local/bin/gcc' # this parameter is specified in makefile
plsql_native_library_dir = '/u01/v901/plsql_compiled_code'
plsql_native_library_subdir_count = 1000
#plsql_native_linker = '/usr/local/bin/ld' # this parameter is specified in makefile
plsql_native_make_file_name = '/u01/v901/plsql/spnc_makefile.mk'
plsql_native_make_utility = 'gmake'
###########################################
# Processes and Sessions
###########################################
processes=50
parallel_automatic_tuning = true
# small system - processes=50
# medium system - processes=1000
# large system - processes=10000
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
###########################################
# Resource Manager
###########################################
resource_manager_plan=SYSTEM_PLAN
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288
# small system - sort_area_size= 50000
# medium system - sort_area_size=256000
# large system - sort_area_size=524288
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=undotbs
###########################################
# Standby Database Configuration
###########################################
LOG_ARCHIVE_DEST_1='LOCATION=/archive mandatory REOPEN=30'
LOG_ARCHIVE_DEST_2='SERVICE=prod1s REOPEN=15'
LOG_ARCHIVE_DEST_STATE_1=enable
LOG_ARCHIVE_DEST_STATE_2=enable
REMOTE_ARCHIVE_ENABLE=true
DRS_START=true
