首页 » ORACLE » 11gr2 install database加大AMM内存时INS-35171

11gr2 install database加大AMM内存时INS-35171

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

解决办法

[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


打赏

,

对不起,这篇文章暂时关闭评论。