硬件配置:sun blade100/256M/solaris8(sparc)数据库版本:ORACLE 9.2system.conf配置
set shmsys:shminfo_shmmax=268435456 这个也按4G设过,没用,改成1G也没用,唉......
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=10000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767initsunora9.ora设置
db_name=lygsun
db_files = 80 # SMALL
db_file_multiblock_read_count = 8 # SMALL
db_block_buffers = 100 # SMALL
#shared_pool_size = 3500000 # SMALL 改成这个也没有用,哭......
# shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
parallel_max_servers = 5 # SMALL
log_buffer = 32768 # SMALL
max_dump_file_size = 10240 # limit trace file size to 5 Meg each启动告警:
SQL> startup
ORACLE instance started.Total System Global Area 51553200 bytes
Fixed Size 730032 bytes
Variable Size 50331648 bytes
Database Buffers 204800 bytes
Redo Buffers 286720 bytes
ORA-00205: error in identifying controlfile, check alert log for more info查看告警日志:
bash-2.03$ cat alert_sunora9.log
Wed Dec 12 13:14:11 2007
Starting ORACLE instance (normal)
Wed Dec 12 13:14:25 2007
WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x0000000005000000 [flag=0x4000]启动前利用vmstat -p查看内存
# vmstat -p
memory page executable anonymous filesystem
swap free re mf fr de sr epi epo epf api apo apf fpi fpo fpf
1416632 196640 50 156 0 0 0 95 0 0 0 0 0 178 0 0
启动后利用vmstat -p查看内存
# vmstat -p
memory page executable anonymous filesystem
swap free re mf fr de sr epi epo epf api apo apf fpi fpo fpf
1542208 152928 29 101 0 0 0 119 0 0 0 0 0 93 0 0SWAP设置
bash-2.03# swap -l
交换文件 dev swaplo blocks free
/dev/dsk/c0t0d0s1 136,1 16 1049312 1049312
/disk02/swapfile2 - 16 2097136 2097136
bash-2.03# swap -s
总数：分配了 95584k 字节 + 保留 20136k = 已使用 115720k，1650240k 可用
bash-2.03#
根据网上的搜到办法怎么试就是不行,已经折腾一周了,实在是没辙了,请高手指教!
set shmsys:shminfo_shmmax=268435456 这个也按4G设过,没用,改成1G也没用,唉......
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=10000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767initsunora9.ora设置
db_name=lygsun
db_files = 80 # SMALL
db_file_multiblock_read_count = 8 # SMALL
db_block_buffers = 100 # SMALL
#shared_pool_size = 3500000 # SMALL 改成这个也没有用,哭......
# shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
parallel_max_servers = 5 # SMALL
log_buffer = 32768 # SMALL
max_dump_file_size = 10240 # limit trace file size to 5 Meg each启动告警:
SQL> startup
ORACLE instance started.Total System Global Area 51553200 bytes
Fixed Size 730032 bytes
Variable Size 50331648 bytes
Database Buffers 204800 bytes
Redo Buffers 286720 bytes
ORA-00205: error in identifying controlfile, check alert log for more info查看告警日志:
bash-2.03$ cat alert_sunora9.log
Wed Dec 12 13:14:11 2007
Starting ORACLE instance (normal)
Wed Dec 12 13:14:25 2007
WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x0000000005000000 [flag=0x4000]启动前利用vmstat -p查看内存
# vmstat -p
memory page executable anonymous filesystem
swap free re mf fr de sr epi epo epf api apo apf fpi fpo fpf
1416632 196640 50 156 0 0 0 95 0 0 0 0 0 178 0 0
启动后利用vmstat -p查看内存
# vmstat -p
memory page executable anonymous filesystem
swap free re mf fr de sr epi epo epf api apo apf fpi fpo fpf
1542208 152928 29 101 0 0 0 119 0 0 0 0 0 93 0 0SWAP设置
bash-2.03# swap -l
交换文件 dev swaplo blocks free
/dev/dsk/c0t0d0s1 136,1 16 1049312 1049312
/disk02/swapfile2 - 16 2097136 2097136
bash-2.03# swap -s
总数：分配了 95584k 字节 + 保留 20136k = 已使用 115720k，1650240k 可用
bash-2.03#
根据网上的搜到办法怎么试就是不行,已经折腾一周了,实在是没辙了,请高手指教!
2 建议用dbca创库，按提示来，不容易出错