Oracle Error :: INS-35171
Target database memory (stringMB) exceeds at least one of the selected nodes available shared memory (string MB).
安装数据库11G R2时,因为启用了AMM,而且内存才800多M,想加大一些时比如加到1.5g会遇到INS-35171
解决办法
Target database memory (stringMB) exceeds at least one of the selected nodes available shared memory (string MB).
安装数据库11G R2时,因为启用了AMM,而且内存才800多M,想加大一些时比如加到1.5g会遇到INS-35171
解决办法
[root@znode1 ~]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda5 15125948 9290040 5055152 65% /
/dev/sda3 1019240 567884 398744 59% /tmp
/dev/sda1 101086 21028 74839 22% /boot
tmpfs 1030932 153436 877496 15% /dev/shm
.host:/ 102399996 10105056 92294940 10% /mnt/hgfs
[root@znode1 ~]# umount tmpfs
umount: /dev/shm: device is busy
umount: /dev/shm: device is busy
[root@znode1 ~]# ls /dev/shm
ora_+ASM1_3342338_0 ora_+ASM1_3375107_29 ora_+ASM1_3375107_5
ora_+ASM1_3375107_0 ora_+ASM1_3375107_3 ora_+ASM1_3375107_50
ora_+ASM1_3375107_1 ora_+ASM1_3375107_30 ora_+ASM1_3375107_51
ora_+ASM1_3375107_10 ora_+ASM1_3375107_31 ora_+ASM1_3375107_52
ora_+ASM1_3375107_11 ora_+ASM1_3375107_32 ora_+ASM1_3375107_53
ora_+ASM1_3375107_12 ora_+ASM1_3375107_33 ora_+ASM1_3375107_54
ora_+ASM1_3375107_13 ora_+ASM1_3375107_34 ora_+ASM1_3375107_55
ora_+ASM1_3375107_14 ora_+ASM1_3375107_35 ora_+ASM1_3375107_56
[root@znode1 ~]# su - grid
[grid@znode1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 4 15:38:56 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Real Application Clusters and Automatic Storage Management options
SQL> shutdown abort
ASM instance shutdown
[root@znode1 ~]# ls /dev/shm
[root@znode1 ~]# umount tmpfs
[root@znode1 ~]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda5 15125948 9294264 5050928 65% /
/dev/sda3 1019240 265500 701128 28% /tmp
/dev/sda1 101086 21028 74839 22% /boot
.host:/ 102399996 10105056 92294940 10% /mnt/hgfs
[root@znode1 ~]# mount -t tmpfs shmfs -o size=1500m /dev/shm
note:只对本次OS启动有效,想永久有效修改/etc/fstab
[root@znode1 ~]# vi /etc/fstab
tmpfs /dev/shm tmpfs size=1500m 0 0
[root@znode1 ~]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda5 15125948 9294812 5050380 65% /
/dev/sda3 1019240 265500 701128 28% /tmp
/dev/sda1 101086 21028 74839 22% /boot
.host:/ 102399996 10105056 92294940 10% /mnt/hgfs
shmfs 1536000 0 1536000 0% /dev/shm
[root@znode1 ~]# su - grid
[grid@znode1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 4 15:41:07 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




