> > SVRMGR> connect internal
> > Connected.
> > SVRMGR> startup
> > ORA-01078: failure in processing system parameters
> > SVRMGR>
> >
>
> 주석으로 막으라고 하셔서 막았더니 위와 같은 에러가 납니다...
허거덕 @.@ 제가 잘못 봤군요.!!!
아래는 오라클 설치 할때 default 로 설치되는 파라미터입니다.(init_ORASID.ora)
(숫자에는 신경쓰지 마시고, 항목들이 코멘트 되어 있나 없나 를 보세요)
그리고 $ORACLE_BASE/admin/ORA_SID/bdump/alert_ORASID.log도 이상이 없나를
점검해 보시죠 ...
# tuning parameters
db_files = 20
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 = 5500 # LARGE
#shared_pool_size = 3500000 # SMALL
shared_pool_size = 25000000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
log_checkpoint_interval = 10000
#processes = 50 # SMALL
processes = 80 # 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 = 100 # 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
NLS_DATE_FORMAT=yyyy/mm/dd
# log_archive_start = true # if you want automatic archiving
# compatible = 7.1.0.0
# global_names = TRUE
# mts_dispatchers="ipc,1"
# mts_max_dispatchers=10
# mts_servers=1
# mts_max_servers=10
# mts_service=sf98
# mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=sf98))"
|