早搜索过了,只有两个init97.ora,initorasoft.ora -----------------------------------------------------init97.ora # # $Header: initx.orc 12-jun-97.09:14:56 hpiao Exp $ Copyr (c) 1992 Oracle ## include database configuration parameters ifile= /export/home/app/oracle/admin/orasoft/pfile/config97.orarollback_segments = (r01,r02,r03,r04)############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize # your RDBMS installation for your site. Important system parameters # are discussed, and example settings given. # # Some parameter settings are generic to any size installation. # For parameters that require different values in different size # installations, three scenarios have been provided: SMALL, MEDIUM # and LARGE. Any parameter that needs to be tuned according to # installation size will have three settings, each one commented # according to installation size. # # Use the following table to approximate the SGA size needed for the # three scenarious provided in this file: # # -------Installation/Database Size------ # SMALL MEDIUM LARGE # Block 2K 4500K 6800K 17000K # Size 4K 5500K 8800K 21000K # # To set up a database that multiple instances will be using, place # all instance-specific parameters in one file, and then have all # of these files point to a master file using the IFILE command. # This way, when you change a public # parameter, it will automatically change on all instances. This is # necessary, since all instances must run with the same value for many # parameters. For example, if you choose to use private rollback segments, # these must be specified in different files, but since all gc_* # parameters must be the same on all instances, they should be in one file. # # INSTRUCTIONS: Edit this file and the other INIT files it calls for # your site, either by using the values provided here or by providing # your own. Then place an IFILE= line into each instance-specific # INIT file that points at this file. ################################################################################ tuning parametersdb_files = 80#db_file_multiblock_read_count = 8 # SMALL # db_file_multiblock_read_count = 16 # MEDIUM db_file_multiblock_read_count = 32 # LARGE #db_block_buffers = 200 # SMALL # db_block_buffers = 550 # MEDIUM # db_block_buffers = 3200 # LARGE db_block_buffers =64000 #shared_pool_size = 3500000 # SMALL # shared_pool_size = 20000000 # MEDIUM # shared_pool_size = 9000000 # LARGE shared_pool_size = 180000000 # LARGEopen_cursors=900 log_checkpoint_interval = 10000#processes = 50 # SMALL # processes = 100 # MEDIUM processes = 200 # LARGE #dml_locks = 100 # SMALL # dml_locks = 200 # MEDIUM dml_locks = 500 # LARGE#log_buffer = 8192 # SMALL # log_buffer = 32768 # MEDIUM log_buffer = 163840 # LARGE#sequence_cache_entries = 10 # SMALL # sequence_cache_entries = 30 # MEDIUM sequence_cache_entries = 200 # LARGE #sequence_cache_hash_buckets = 10 # SMALL # sequence_cache_hash_buckets = 23 # MEDIUM sequence_cache_hash_buckets = 189 # LARGE # audit_trail = true # if you want auditing # timed_statistics = true # if you want timed statistics max_dump_file_size = 10240 # limit trace file size to 5 Meg each # log_archive_start = true # if you want automatic archiving max_enabled_roles=30global_names = TRUE# mts_dispatchers="ipc,1" # mts_max_dispatchers=10 # mts_servers=1 # mts_max_servers=10 # mts_service=orasoft # mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))"# # needed if running OPS # # PARALLEL_SERVER=TRUE
-----------------------------------------------------------initorasoft.ora # # $Header: initx.orc 12-jun-97.09:14:56 hpiao Exp $ Copyr (c) 1992 Oracle ## include database configuration parameters ifile = /export/home/app/oracle/admin/orasoft/pfile/configorasoft.orarollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16,r17,r18,r19,r20)############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize # your RDBMS installation for your site. Important system parameters # are discussed, and example settings given. # # Some parameter settings are generic to any size installation. # For parameters that require different values in different size # installations, three scenarios have been provided: SMALL, MEDIUM # and LARGE. Any parameter that needs to be tuned according to # installation size will have three settings, each one commented # according to installation size. # # Use the following table to approximate the SGA size needed for the # three scenarious provided in this file: # # -------Installation/Database Size------ # SMALL MEDIUM LARGE # Block 2K 4500K 6800K 17000K # Size 4K 5500K 8800K 21000K # # To set up a database that multiple instances will be using, place # all instance-specific parameters in one file, and then have all # of these files point to a master file using the IFILE command. # This way, when you change a public # parameter, it will automatically change on all instances. This is # necessary, since all instances must run with the same value for many # parameters. For example, if you choose to use private rollback segments, # these must be specified in different files, but since all gc_* # parameters must be the same on all instances, they should be in one file. # # INSTRUCTIONS: Edit this file and the other INIT files it calls for # your site, either by using the values provided here or by providing # your own. Then place an IFILE= line into each instance-specific # INIT file that points at this file. ################################################################################ tuning parametersdb_files = 80#db_file_multiblock_read_count = 8 # SMALL # db_file_multiblock_read_count = 16 # MEDIUM db_file_multiblock_read_count = 32 # LARGE #db_block_buffers = 200 # SMALL # db_block_buffers = 550 # MEDIUM db_block_buffers = 3200 # LARGE # db_block_buffers =64000 #shared_pool_size = 3500000 # SMALL # shared_pool_size = 6000000 # MEDIUM # shared_pool_size = 9000000 # LARGE shared_pool_size = 10000000 log_checkpoint_interval = 8000# processes = 100 # MEDIUM # processes = 200 # LARGE # dml_locks = 100 # SMALL # dml_locks = 200 # MEDIUM dml_locks = 10000 # LARGE# log_buffer = 8192 # SMALL log_buffer = 32768 # MEDIUM # log_buffer = 163840 # LARGE open_cursors=5000 #sequence_cache_entries = 10 # SMALL # sequence_cache_entries = 30 # MEDIUM sequence_cache_entries = 100 # LARGE #sequence_cache_hash_buckets = 10 # SMALL # sequence_cache_hash_buckets = 23 # MEDIUM sequence_cache_hash_buckets = 189 # LARGE max_enabled_roles=30 # audit_trail = true # if you want auditing # timed_statistics = true # if you want timed statistics max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archivingglobal_names = false mts_dispatchers="tcp,10" mts_max_dispatchers=20 mts_servers=8 mts_max_servers=10 mts_service=orasoft mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(HOST=134.161.9.88)(PORT=1521))"processes = 550 # SMALL sessions = 550 transactions= 1000 distributed_transactions = 600 transactions_per_rollback_segment = 10# needed if running OPS # # PARALLEL_SERVER=TRUE我觉得两个都不怎么象,你们说是哪个
回答: 1、不知你用的是8i还是9i,如是9i使用alter system set utl_file_dir=...来修改 如是8i直接修改init<sid>.ora这个文件。 2、utl_file_dir默认是不出现在init<sid>.ora中的,你手动在该文件末尾追加一行就可以了 生效需重启数据库。
-----------------------------------------------------init97.ora
#
# $Header: initx.orc 12-jun-97.09:14:56 hpiao Exp $ Copyr (c) 1992 Oracle
## include database configuration parameters
ifile= /export/home/app/oracle/admin/orasoft/pfile/config97.orarollback_segments = (r01,r02,r03,r04)##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
################################################################################ tuning parametersdb_files = 80#db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE #db_block_buffers = 200 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
db_block_buffers =64000 #shared_pool_size = 3500000 # SMALL
# shared_pool_size = 20000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
shared_pool_size = 180000000 # LARGEopen_cursors=900
log_checkpoint_interval = 10000#processes = 50 # SMALL
# processes = 100 # MEDIUM
processes = 200 # LARGE #dml_locks = 100 # SMALL
# dml_locks = 200 # MEDIUM
dml_locks = 500 # LARGE#log_buffer = 8192 # SMALL
# log_buffer = 32768 # MEDIUM
log_buffer = 163840 # LARGE#sequence_cache_entries = 10 # SMALL
# sequence_cache_entries = 30 # MEDIUM
sequence_cache_entries = 200 # LARGE #sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
sequence_cache_hash_buckets = 189 # LARGE # audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archiving
max_enabled_roles=30global_names = TRUE# mts_dispatchers="ipc,1"
# mts_max_dispatchers=10
# mts_servers=1
# mts_max_servers=10
# mts_service=orasoft
# mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))"#
# needed if running OPS
#
# PARALLEL_SERVER=TRUE
#
# $Header: initx.orc 12-jun-97.09:14:56 hpiao Exp $ Copyr (c) 1992 Oracle
## include database configuration parameters
ifile = /export/home/app/oracle/admin/orasoft/pfile/configorasoft.orarollback_segments = (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10,r11,r12,r13,r14,r15,r16,r17,r18,r19,r20)##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
################################################################################ tuning parametersdb_files = 80#db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE #db_block_buffers = 200 # SMALL
# db_block_buffers = 550 # MEDIUM
db_block_buffers = 3200 # LARGE
# db_block_buffers =64000 #shared_pool_size = 3500000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
shared_pool_size = 10000000 log_checkpoint_interval = 8000# processes = 100 # MEDIUM
# processes = 200 # LARGE # dml_locks = 100 # SMALL
# dml_locks = 200 # MEDIUM
dml_locks = 10000 # LARGE# log_buffer = 8192 # SMALL
log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
open_cursors=5000
#sequence_cache_entries = 10 # SMALL # sequence_cache_entries = 30 # MEDIUM
sequence_cache_entries = 100 # LARGE #sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
sequence_cache_hash_buckets = 189 # LARGE
max_enabled_roles=30
# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archivingglobal_names = false
mts_dispatchers="tcp,10"
mts_max_dispatchers=20
mts_servers=8
mts_max_servers=10
mts_service=orasoft
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(HOST=134.161.9.88)(PORT=1521))"processes = 550 # SMALL
sessions = 550
transactions= 1000
distributed_transactions = 600
transactions_per_rollback_segment = 10# needed if running OPS
#
# PARALLEL_SERVER=TRUE我觉得两个都不怎么象,你们说是哪个
1、不知你用的是8i还是9i,如是9i使用alter system set utl_file_dir=...来修改
如是8i直接修改init<sid>.ora这个文件。
2、utl_file_dir默认是不出现在init<sid>.ora中的,你手动在该文件末尾追加一行就可以了
生效需重启数据库。
该文件应该在$ORACLE_HOME/dbs这上目录。
我认为你的ORACLE_SID不是ora7
你可以这样查一下,看倒底是什么
SELECT instance_name FROM v$instance