oracle11g启用自动内存管理后不能启动实例

一月 28th, 2010 Posted in oracle | 阅读次数: 234 次

Author:gaojinbo
Time:2010-1-28

 

Memory_target not supported on this system

oracle11g启用自动内存管理后不能启动实例

 

解决方案：由于sga的大小超过了/dev/shm的大小

 

1.修改初始化参数中的SGA的值小于/dev/shm

 

2.调整/dev/shm的大小

1）查看大小
df -h /dev/sdhm

 

2)修改大小
vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=2048M 0 0

 

3)卸载
umount /dev/shm

 

4)挂载
mount /dev/shm

 

5)启动实例
sqlplus "/ as sysdba"
startup

 

完成！

相关日志：

Tags:

This entry was posted on 星期四, 一月 28th, 2010 at 19:53 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “oracle11g启用自动内存管理后不能启动实例”

  1. Thrush Treatment Says:

    五月 9th, 2011 at 21:28

    Recommended Sites…

    [...]below you can check out my links page http://www.yeastinfectiontreatmentcure.net/links/ with some great websites that I think you should definitely go visit[...]…


  2. website Says:

    七月 10th, 2011 at 06:19

    Cool sites…

    [...]we came across a cool site that you might enjoy. Take a look if you want[...]……


留下您的脚印