读书人

ORA-27123: unable to attach to shar

发布时间: 2014-01-28 21:23:19 作者: rapoo

各位大侠,我在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;

        

读书人网 >oracle

热点推荐