Corporation Server User Manual

Admin.
Guide
C – 4 Oracle7 Server Getting Started for Windows NT
control file for the initial database, CTL1ORCL.ORA, in
\ORANT\DATABASE.
If you created your database with the CREATE DATABASE command,
Oracle7 Server for Windows NT creates the control file, CTL1sid.ORA,
where sid is the SID of that database.
At least two (identical) control files, each located on a separate storage
device, should be used. The size of Oracle7 Server for Windows NT
control files vary according to the complexity of your database structure.
The maximum size of an Oracle7 Server for Windows NT control file is
2500 database blocks.
Additional Information: See Oracle7 Server Administrator’s
Guide for more information on initialization parameters.
Initialization Parameters
Oracle7 Server Administrator’s Guide includes descriptions of all
initialization parameters and instructions for setting and displaying
their values.
Parameter Name Default Value Range of Values
BACKGROUND_DUMP_DEST %RDBMSnn%\TRACE\ Any valid directory
COMMIT_POINT_STRENGTH 1 0 – 255
CONTROL_FILES %ORACLE_HOME%\DATABASE\CTL1%ORACLE_SID%.ORA Any valid path and filename.
DB_BLOCK_SIZE 2048 512 – 8192
DB_FILES 32 254, cannot exceed DB_BLOCK_BUFFERS
DB_FILE_MULTIBLOCK_READ_COUNT 4 1 – 32
DB_FILE_SIMULTANEOUS_WRITES 4 1 – 24
DISTRIBUTED_TRANSACTIONS 25 * TRANSACTIONS 0 – TRANSACTIONS
LOG_ARCHIVE_BUFFER_SIZE 127 1 – 127
LOG_ARCHIVE_BUFFERS 4 1 – 8
LOG_ARCHIVE_DEST %RDBMSnn%\ Any valid directory
LOG_ARCHIVE_FORMAT ARC%S.%T A valid filename format
LOG_CHECKPOINT_INTERVAL 8000 2 – Unlimited
LOG_FILES 255 2 – 255
LOG_SMALL_ENTRY_MAX_SIZE 800 0 – Unlimited
MTS_MAX_DISPATCHERS (unused) (unused)
MTS_MAX_SERVERS (unused) (unused)
MTS_SERVERS (unused) (unused)
NLS_LANGUAGE AMERICAN Any valid language
NLS_SORT (Language dependent) (Language dependent)
NLS_TERRITORY AMERICA Any valid territory