Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
# file: c:\v901\database\initprod3.ora
# Features: This file provides the initial configuration for the Oracle
# database instance (Windows NT/2000 version).- 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
# Used By: oracle database instance prod3
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 07-02-2002 dsimpson Initial Release
# This output file was created by Installgen version 1.38 on Thu Nov 14 17:48:05 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
###########################################
# Miscellaneous
###########################################
compatible=9.2.0.0.0
###########################################
# Network Registration
###########################################
instance_name = prod3
db_name = prod3
service_names = prod3
###########################################
# Archive
###########################################
#log_archive_dest_1='LOCATION=c:\archive mandatory REOPEN=30'
log_archive_format=prod3_%t_%s.arc
log_archive_start=true
###########################################
# Cache and I/O
###########################################
db_block_size=8192
# small system - db_block_size=4096
# medium system - db_block_size=8192
# large system - db_block_size=16384
db_cache_size=819200
# 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=c:\u01\bdump
core_dump_dest =c:\u01\cdump
timed_statistics=FALSE
user_dump_dest =c:\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=("c:\u01\prod3\control01.ctl", "c:\u01\prod3\control02.ctl", "c:\u01\prod3\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=c:\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 =150000000
# 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=150000000
# 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 = 'c:/mingw/bin/gcc.exe'
plsql_native_library_dir = 'c:/v901/PLSQL_~1'
plsql_native_library_subdir_count = 1000
plsql_native_linker = 'c:/mingw/bin/ld.exe'
plsql_native_make_file_name = 'c:/v901/plsql/SPNC_M~1.MK'
plsql_native_make_utility = 'c:/mingw/bin/make.exe'
###########################################
# 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
control_file_record_keep_time=3
###########################################
# 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=c:\archive mandatory REOPEN=30'
LOG_ARCHIVE_DEST_2='SERVICE=prod3s REOPEN=15'
LOG_ARCHIVE_DEST_STATE_1=enable
LOG_ARCHIVE_DEST_STATE_2=enable
REMOTE_ARCHIVE_ENABLE=true
DRS_START=true
