手工创建Oracle数据库脚本及说明

核心提示：系统环境：1、操作系统：Windows 2000 Server，机器内存128M2、数据库：Oracle 8i R2 (8.1.6) for NT 企业版3、安装路径：D:ORACLE建库步骤：1、手工创建相关目录D:OracleadminestD:OracleadminestadhocD:Oracleadminest

系统环境：

1、操作系统：Windows 2000 Server，机器内存128M

2、数据库：　Oracle 8i R2 (8.1.6) for NT 企业版

3、安装路径：D:ORACLE

建库步骤：

1、手工创建相关目录

D:Oracleadmin　　est
D:Oracleadmin　　estadhoc
D:Oracleadmin　　estdump
D:Oracleadmin　　estcdump
D:Oracleadmin　　estcreate
D:Oracleadmin　　estexp
D:Oracleadmin　　estpfile
D:Oracleadmin　　estudump
D:Oracleoradata　　est
D:Oracleoradata　　estarchive

2、手工创建初始化启动参数文件：D:Oracleadmin　　estpfileinittest.ora，内容：

db_name = "test"
instance_name = test
service_names = test
db_files = 1024
control_files = ("D:Oracleoradata　　estcontrol01.ctl",
"D:Oracleoradata　　estcontrol02.ctl", "D:Oracleoradata　　estcontrol03.ctl")
open_cursors = 200
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 4096
shared_pool_size = 52428800
large_pool_size = 78643200
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 115
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = true
oracle_trace_collection_name = ""
background_dump_dest = D:Oracleadmin　　estdump
user_dump_dest = D:Oracleadmin　　estudump
db_block_size = 16384
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
mts_dispatchers = "(protocol=TCP)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536
# log_archive_start = true
# log_archive_dest_1 = "location=D:Oracleoradataoradbarchive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC