By default ASM instance takes 256M as memory target value. if you see ORA-04031 in ASM you can increase the memory target value in rolling fashion
current status
[oracle@ol6-112-rac1 ~]$ crsctl check cluster -all
**************************************************************
ol6-112-rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
ol6-112-rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[oracle@ol6-112-rac1 ~]$ ps -ef|grep pmon
oracle 19311 1 0 13:08 ? 00:00:00 asm_pmon_+ASM1
oracle 19920 1 0 13:08 ? 00:00:00 ora_pmon_LONDON1
oracle 19924 1 0 13:08 ? 00:00:00 ora_pmon_TROY1
oracle 19959 1 0 13:08 ? 00:00:00 ora_pmon_INDIA1
oracle 22848 20054 0 13:13 pts/0 00:00:00 grep pmon
increase memory target in ASM instance
[oracle@ol6-112-rac1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@ol6-112-rac1 ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 13 13:13:56 2021
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysasm
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> sho parameter memo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 300M
memory_target big integer 300M
SQL> alter system set memory_max_target=320M scope=spfile sid='*';
System altered.
SQL> alter system set memory_target=320M scope=spfile sid='*';
System altered.
stop cluster on node 1
[root@ol6-112-rac1 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop cluster
CRS-2673: Attempting to stop 'ora.crsd' on 'ol6-112-rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.india.db' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.london.db' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.troy.db' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.scan2.vip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ol6-112-rac1.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.ol6-112-rac1.vip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.ol6-112-rac1.vip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.cvu' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.scan3.vip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.cvu' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.london.db' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.troy.db' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.india.db' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.scan2.vip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.ol6-112-rac1.vip' on 'ol6-112-rac2' succeeded
CRS-2676: Start of 'ora.scan3.vip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.oc4j' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.asm' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.ons' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.net1.network' on 'ol6-112-rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ol6-112-rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'ol6-112-rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.evmd' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ol6-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.cssd' on 'ol6-112-rac1' succeeded
start the cluster on node 1
[root@ol6-112-rac1 ~]# ps -ef|grep pmon
root 23653 3674 0 13:17 pts/0 00:00:00 grep pmon
[root@ol6-112-rac1 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start cluster
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ol6-112-rac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.diskmon' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.ctssd' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'ol6-112-rac1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.evmd' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.asm' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.crsd' on 'ol6-112-rac1' succeeded
value chnage in ASM1
SQL> sho parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
instance_name string +ASM1
instance_number integer 1
instance_type string asm
SQL> sho parameter memo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 320M
memory_target big integer 320M
[oracle@ol6-112-rac1 ~]$ ps -ef|grep pmon
oracle 24011 1 0 13:18 ? 00:00:00 asm_pmon_+ASM1
oracle 24625 1 0 13:18 ? 00:00:00 ora_pmon_LONDON1
oracle 24629 1 0 13:18 ? 00:00:00 ora_pmon_TROY1
oracle 24650 1 0 13:18 ? 00:00:00 ora_pmon_INDIA1
oracle 25644 24287 0 13:19 pts/0 00:00:00 grep pmon
but it still same in ASM2
SQL> sho parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
instance_name string +ASM2
instance_number integer 2
instance_type string asm
SQL> sho parameter memo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 300M
memory_target big integer 300M
restart cluster on node 2
[root@ol6-112-rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop cluster
CRS-2673: Attempting to stop 'ora.crsd' on 'ol6-112-rac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.cvu' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.india.db' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.london.db' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.troy.db' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.ol6-112-rac2.vip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.ol6-112-rac2.vip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.ol6-112-rac2.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.scan2.vip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.scan3.vip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.troy.db' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.london.db' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.india.db' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.scan2.vip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.scan3.vip' on 'ol6-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.ol6-112-rac2.vip' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'ol6-112-rac1'
CRS-2677: Stop of 'ora.cvu' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'ol6-112-rac1'
CRS-2676: Start of 'ora.cvu' on 'ol6-112-rac1' succeeded
CRS-2676: Start of 'ora.oc4j' on 'ol6-112-rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.asm' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.ons' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.net1.network' on 'ol6-112-rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ol6-112-rac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'ol6-112-rac2'
CRS-2673: Attempting to stop 'ora.asm' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.evmd' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ol6-112-rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ol6-112-rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ol6-112-rac2'
CRS-2677: Stop of 'ora.cssd' on 'ol6-112-rac2' succeeded
[root@ol6-112-rac2 ~]#
[root@ol6-112-rac2 ~]#
[root@ol6-112-rac2 ~]# ps -ef|grep pmon
root 20679 11404 0 13:21 pts/0 00:00:00 grep pmon
[root@ol6-112-rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start cluster
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.cssdmonitor' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ol6-112-rac2'
CRS-2672: Attempting to start 'ora.diskmon' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.diskmon' on 'ol6-112-rac2' succeeded
CRS-2676: Start of 'ora.cssd' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'ol6-112-rac2'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.ctssd' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.evmd' on 'ol6-112-rac2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.asm' on 'ol6-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'ol6-112-rac2'
CRS-2676: Start of 'ora.crsd' on 'ol6-112-rac2' succeeded
verify the value
SQL> sho parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
instance_name string +ASM2
instance_number integer 2
instance_type string asm
SQL> sho parameter memo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 320M
memory_target big integer 320M
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/ol6-112-scan/asmparamete
rfile/registry.253.1040405587
if you see the pfile now memry target is explicitly added
SQL> create pfile='/tmp/33.ora' from spfile;
File created.
SQL> !cat /tmp/33.ora
+ASM1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from in memory value
+ASM2.asm_diskgroups='FRA','ACFSDG'#Manual Mount
+ASM1.asm_diskgroups=''#Manual Dismount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.memory_max_target=335544320
*.memory_target=335544320
*.remote_login_passwordfile='EXCLUSIVE'
DBATracker 