oracle 11g： 生成pfile文件： create pfile=/home/oracle/initorcl.ora from spfile; 修改pfile中的*.memory_target=536870912 值。 然后重启数据库从新的pfile文件启动到nomount状态。 sql startup nomount pfile=/home/oracle/initorcl.ora; ora-00845: me
oracle 11g： 生成pfile文件： create pfile='/home/oracle/initorcl.ora' from spfile;
修改pfile中的*.memory_target=536870912 值。
然后重启数据库从新的pfile文件启动到nomount状态。
sql> startup nomount pfile='/home/oracle/initorcl.ora';
ora-00845: memory_target not supported on this system
原因是这个值大过了/dev/shm的值。
df -k /dev/shm
filesystem 1k-blocks used available use% mounted on
tmpfs 517600 0 517600 0% /dev/shm
解决方法：
修改fstab
vi /etc/fstab
/dev/volgroup00/logvol00 / ext3 defaults 1 1
label=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults,size=1024m 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/volgroup00/logvol01 swap swap defaults 0 0
重新挂载：
[root@localhost ~]# umount /dev/shm
[root@localhost ~]# mount /dev/shm
[root@localhost ~]# df -h /dev/shm
filesystem size used avail use% mounted on
tmpfs 1.0g 0 1.0g 0% /dev/shm
再次启动数据库
sql> startup pfile='/home/oracle/initorcl.ora';
oracle instance started.
total system global area 535662592 bytes
fixed size 1337720 bytes
variable size 327157384 bytes
database buffers 201326592 bytes
redo buffers 5840896 bytes
database mounted.
database opened.
sql> show sga
total system global area 535662592 bytes
fixed size 1337720 bytes
variable size 327157384 bytes
database buffers 201326592 bytes
redo buffers 5840896 bytes
sql> select 535662592/1024/1024 from dual;
535662592/1024/1024
-------------------
510.847656
可 以看到已经修改过来了。
最后验证同步功能。