$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

# archivelog mode LOG_ARCHIVE_START = true LOG_ARCHIVE_FORMAT = arch%t_%s.arc LOG_ARCHIVE_DEST = "/home/SYSTEM/arch/"


トップ   差分 バックアップ リロード   一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2005-06-27 (月) 00:16:48 (5327d)