首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

ORA-27123: unable to attach to shared memory segment

2014-01-28 
各位大侠,我在linux3.0下(机器内存为4G)安装的oracle9.0.2,我需要把sga改大一点,所以如下操作: #cd /etc/sy

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

        

热点排行