$ORACLE_HOME/dbs/initSID.ora


db_name=sptest2 db_domain = test.ad.jp global_names = TRUE instance_name = sptest2 service_names = sptest2.test.ad.jp

control_files = ("/home/SYSTEM/control01.ctl", "/udb1/SYSTEM/control02.ctl", "/udb2/SYSTEM/control03.ctl") rollback_segments = (RBS01,RBS02,RBS03,RBS04,RBS05,RBS06) background_dump_dest = /home/SYSTEM/admin/bdump core_dump_dest = /home/SYSTEM/admin/cdump user_dump_dest = /home/SYSTEM/admin/udump compatible = "8.1.6" open_cursors = 100 max_enabled_roles = 30 max_rollback_segments = 1000

# db_block_buffers = 48000 db_block_buffers = 24000 db_block_size = 8192 db_files = 400 processes = 160

db_file_multiblock_read_count = 8

shared_pool_size = 20480000 large_pool_size = 50331648 java_pool_size = 0 log_buffer = 1024000 sort_area_size = 524288 sort_area_retained_size = 524288

# Net8 option mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(HOST=g32b21))(DISPATCHERS=2)" mts_servers = 2 local_listener = "(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(Host=g32b21)(Port= 1521)) (ADDRESS=(PROTOCOL= TCP)(Host=g32b21)(Port= 1522)))" mts_max_servers=11

log_checkpoint_interval = 204801 log_checkpoint_timeout=0

# Replication Option job_queue_processes = 4 job_queue_interval = 60 distributed_transactions = 10 open_links = 4


トップ   差分 バックアップ リロード   一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2017-05-08 (月) 12:26:19 (440d)