各位大侠,我在linux3.0下(机器内存为4G)安装的oracle9.0.2,我需要把sga改大一点,所以如下操作:
#cd /etc/sysctl.conf
kernel.shmall=2097152
kernel.sem=250 32000 100 256
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
kernel.shmmax=4294967295
kernel.shmmni=4096
#reboot
然后进入数据库操作:
Alter system set sga_max_size=1633m scope=spfile;
alter system set shared_pool_size=512m scope= spfile;
alter system set pga_aggregate_target =500m scope= spfile;
alter system set db_cache_size=1008m scope= spfile;
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 4096053
然而当我改为
Alter system set sga_max_size=1616m scope=spfile;时重启数据库竟然成功了,这是怎么回事呢,各位大侠帮帮我啊!
------解决方法--------------------------------------------------------
参数错了,
Alter system set sga_max_size=1633m scope=pfile;