各位大侠,我在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;时重启数据库竟然成功了,这是怎么回事呢,各位大侠帮帮我啊!
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;时重启数据库竟然成功了,这是怎么回事呢,各位大侠帮帮我啊!
解决方案 »
- ora-00902:无效数据类型
- 几个ORACLE分布数据库合并到一个ORACLE数据库
- 请问这样的sql语句怎么写
- 数据库学习
- 难度大一点的sql语句,请教高手指教???欢迎来踩踩我!
- 小弟用的是Oracle客户端。在SQL PLUS中输入的用户名称、主机字符串和口令都没问题,为什么一点“确定”就“未响应”啊?
- 请问如何判断进程是否已经死锁了?
- 如何查找数据库中前十条记录?select top 10 * from table ?
- 请教一条个人认为很难的sql语句写法(100分)
- 怎么取得插入记录的ID号?
- 什么方法可以看到这些文件里面的内容或数据表的结构?
- 怎么建ORCALE 8i和MYSQl之间建立DBLINK
设置的参数在数据库重启之后生效
Alter system set sga_max_size=1633m scope=pfile;