- 论坛徽章:
- 0
|
急！xeon与oracle的兼容问题
$ dbstart
SQL*DBA: Release 7.2.2.3.0 - Production on Fri Nov 7 12:08:51 2003
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Oracle7 Server Release 7.2.2.3.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.2.2.3.0 - Production
SQLDBA>; Connected.
SQLDBA>; ORA-07331: smsnsg: unable to allocate the variable portion of the SGA.
Additional information: 4
SQLDBA>;
SQL*DBA complete.
Database "ora7" warm started.
这个是启动数据库的错误。
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 = 3200 # LARGE
shared_pool_size = 3500000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE
dml_locks = 100 # SMALL
# 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
sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
# sequence_cache_hash_buckets = 89 # 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
# compatible = 7.1.0.0
# global_names = TRUE
# mts_max_dispatchers=10
# mts_servers=1
# mts_max_servers=10
# mts_service=ora7
这个是intisid.ora的主要参数。 |
|
免费注册
发表于 2003-11-07 08:18
