Memory modification for oracle11g rac asm instance

Memory modification for oracle11g rac asm instance

Memory_max_target (which is a static parameter and needs to be restarted after modification) memory_target (which is a dynamic parameter and does not need to be restarted) SQL> select name, issys_modifiable from v $ parameter where name = 'memory _ max_target '; NAME ISSYS_MOD parameter --------- memory_max_target FALSESQL> select name, issys_modifiable from v $ parameter where name = 'memory _ target '; NAME ISSYS_MOD --------------------------------- ----------------------------------------------- Memory_target IMMEDIATE to view the ASM memory, modify memory_max_target, and change from MB to 4 GB [grid @ db1 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.3.0 Production on Wed Sep 25 14:44:59 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter mem; name type value ------------------------------------------------------ ----------------------- Memory_max_target big integer 512Mmemory_target big integer 512 MSQL> SQL> alter system set memory_max_target = 4G scope = spfile; System altered. SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Real Application Clusters and Automatic Storage Management options to view the crs status (because the test Database instance and listener are not started, if the production environment is in progress, we recommend that you stop the service one by one to ensure normal business operation.) [grid @ Db1 ~] $ Crsctl stat res-t release name target state server STATE_DETAILS restart Local Resources within ora. DATA. dg ONLINE db1 ONLINE db2 ora. FRA. dg ONLINE db1 ONLINE ONL INE db2 ora. LISTENER. lsnr OFFLINE db1 OFFLINE db2 ora. OCR. dg ONLINE db1 ONLINE db2 ora. asm ONLINE db1 Started ONLINE db2 Started ora. gsd OFFLINE db1 OFFLINE db2 ora. net1.network ONLINE db1 ONLINE db2 ora. ons ONLINE db1 ONLINE db2 ------------------------------------------------------------------------------------ Cl Uster Resources ---------------------------------------------------------------------------------- ora. LISTENER_SCAN1.lsnr 1 ONLINE db2 ora. cvu 1 ONLINE db1 ora. db1.vip 1 ONLINE db1 ora. db2.vip 1 ONLINE db2 ora. dmzdb. db 1 OFFLINE Instance Shutdown 2 OFFLINE Instance Shutdown ora.. scan1.vip 1 ONLINE db2 [grid @ db1 ~] $ Stop crs all nodes Note: to modify the memory of the asm instance, You need to restart the asm instance to test and restart the instance. If you need to stop diskgroup and restart the crs, You have to restart the crs, the production environment can be restarted one by one to ensure that the business can run this example for the convenience of testing, all stopped, all started [root @ db1 ~] # Crsctl stop cluster-allCRS-2673: Attempting to stop 'ora. crsd 'on 'db1' CRS-2673: Attempting to stop' ora. crsd 'on 'db2 'crs-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db1' CRS-2673: Attempting to stop' ora. db1.vip 'on 'db1' CRS-2673: Attempting to stop' ora. FRA. dg 'on 'db1' CRS-2673: Attempting to stop' ora. OCR. dg 'on 'db1' CRS-2673: Attempting to stop' ora. DATA. dg 'on 'd B1 'crs-2673: Attempting to stop' ora.. cvu 'on 'db1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'db2 'crs-2673: Attempting to stop' ora. db2.vip 'on 'db2 'crs-2673: Attempting to stop' ora. FRA. dg 'on 'db2 'crs-2673: Attempting to stop' ora. OCR. dg 'on 'db2 'crs-2673: Attempting to stop' ora. DATA. dg 'on 'db2' CRS-2673: Attempting To stop 'ora. LISTENER_SCAN1.lsnr 'on 'db2 'crs-2677: Stop of 'ora. db1.vip 'on 'db1' succeededCRS-2677: Stop of 'ora. db2.vip 'on 'db2' succeededCRS-2677: Stop of 'ora. DATA. dg 'on 'db1' succeededCRS-2677: Stop of 'ora. LISTENER_SCAN1.lsnr 'on 'db2' succeededCRS-2673: Attempting to stop 'ora. scan1.vip 'on 'db2 'crs-2677: Stop of 'ora. FRA. dg 'on 'db2' succeededCRS-2677: Stop of 'ora. scan1.vip 'on 'db2' SucceededCRS-2677: Stop of 'ora. FRA. dg 'on 'db1' succeededCRS-2677: Stop of 'ora. DATA. dg 'on 'db2' succeededCRS-2677: Stop of 'ora.. cvu 'on 'db1' succeededCRS-2677: Stop of 'ora. OCR. dg 'on 'db1' succeededCRS-2673: Attempting to stop 'ora. asm 'on 'db1' CRS-2677: Stop of 'ora. OCR. dg 'on 'db2' succeededCRS-2673: Attempting to stop 'ora. asm 'on 'db2' CRS-267 7: Stop of 'ora. asm 'on 'db1' succeededCRS-2677: Stop of 'ora. asm 'on 'db2' succeededCRS-2673: Attempting to stop' ora. ons 'on 'db2' CRS-2677: Stop of 'ora. ons 'on 'db2 'succeededCRS-2673: Attempting to stop' ora. net1.network 'on 'db2 'crs-2677: Stop of 'ora. net1.network 'on 'db2' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db2 'has completedCRS-2673: Attempting to st Op 'ora. ons 'on 'db1' CRS-2677: Stop of 'ora. ons 'on 'db1' succeededCRS-2673: Attempting to stop' ora. net1.network 'on 'db1' CRS-2677: Stop of 'ora. net1.network 'on 'db1' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db1' has completedCRS-2677: Stop of 'ora. crsd 'on 'db2' succeededCRS-2673: Attempting to stop 'ora. ctssd 'on 'db2 'crs-2673: Attempting to stop' ora. evmd 'o N 'db2 'crs-2673: Attempting to stop' ora. asm 'on 'db2' CRS-2677: Stop of 'ora. crsd 'on 'db1' succeededCRS-2673: Attempting to stop' ora. ctssd 'on 'db1' CRS-2673: Attempting to stop' ora. evmd 'on 'db1' CRS-2673: Attempting to stop' ora. asm 'on 'db1' CRS-2677: Stop of 'ora. evmd 'on 'db2 'succeededCRS-2677: Stop of 'ora. ctssd 'on 'db1' succeededCRS-2677: Stop of 'ora. evmd 'on 'db1' succeededCRS-2677: Sto P of 'ora. ctssd 'on 'db' succeededCRS-2677: Stop of 'ora. asm 'on 'db2' succeededCRS-2673: Attempting to stop' ora. cluster_interconnect.haip 'on 'db2 'crs-2677: Stop of 'ora. cluster_interconnect.haip 'on 'db2' succeededCRS-2673: Attempting to stop 'ora.css d' on 'db2 'crs-2677: Stop of 'ora.css d' on 'db2 'succeededCRS-2677: Stop of 'ora. asm 'on 'db1' succeededCRS-2673: Attempting to stop' ora. cluster _ Interconnect. haip 'on 'db1' CRS-2677: Stop of 'ora. cluster_interconnect.haip 'on 'db1' succeededCRS-2673: Attempting to stop 'ora.css d' on 'db1' CRS-2677: stop of 'ora.css d' on 'db1' succeeded start all crs nodes [root @ db1 ~] # Crsctl start cluster-allCRS-2672: Attempting to start 'ora.css dmonitor 'on 'db1' CRS-2672: Attempting to start 'ora.css dmonitor' on 'db2 'CRS-2676: start of 'ora.css dmonitor 'on 'db1' succeededCRS-2672: Attempting to start 'ora.css d' on 'db1' CRS-2676: Start of 'ora.css dmonitor' on 'db2 'succeededCRS-2672: attempting to start' ora. diskmon 'on 'db1' CRS-2672: Attempting to start 'ora.css d' on 'db2 'cr S-2672: Attempting to start' ora. diskmon 'on 'db2 'crs-2676: Start of 'ora. diskmon 'on 'db1' succeededCRS-2676: Start of 'ora. diskmon 'on 'db2' succeededCRS-2676: Start of 'ora.css d' on 'db1' succeededCRS-2672: Attempting to start' ora. ctssd 'on 'db1' CRS-2676: Start of 'ora.css d' on 'db2 'succeededCRS-2672: Attempting to start' ora. ctssd 'on 'db2 'crs-2672: Attempting to start' ora. cluster_interconn Ect. haip 'on 'db2 'crs-2676: Start of 'ora. ctssd 'on 'db1' succeededCRS-2672: Attempting to start' ora. evmd 'on 'db1' CRS-2672: Attempting to start' ora. cluster_interconnect.haip 'on 'db1' CRS-2676: Start of 'ora. ctssd 'on 'db' succeededCRS-2672: Attempting to start' ora. evmd 'on 'db2 'crs-2676: Start of 'ora. evmd 'on 'db1' succeededCRS-2676: Start of 'ora. evmd 'on 'db2' succeededCRS-2676: Start' Ora. cluster_interconnect.haip 'on 'db1' succeededCRS-2672: Attempting to start' ora. asm 'on 'db1' CRS-2676: Start of 'ora. cluster_interconnect.haip 'on 'db2' succeededCRS-2672: Attempting to start' ora. asm 'on 'db2' CRS-2676: Start of 'ora. asm 'on 'db1' succeededCRS-2672: Attempting to start' ora. crsd 'on 'db1' CRS-2676: Start of 'ora. crsd 'on 'db1' succeededCRS-2676: Start of 'ora. asm 'on 'db2' succ EededCRS-2672: Attempting to start 'ora. crsd' on 'db2 'crs-2676: Start of 'ora. crsd' on 'db2 'succeeded [root @ db1 ~] # Check the crs status and find that the crs starts normally [grid @ db1 ~] $ Crsctl stat res-t release name target state server STATE_DETAILS restart Local Resources within ora. DATA. dg ONLINE db1 ONLINE db2 ora. FRA. dg ONLINE db1 ONLINE ONL INE db2 ora. LISTENER. lsnr OFFLINE db1 OFFLINE db2 ora. OCR. dg ONLINE db1 ONLINE db2 ora. asm ONLINE db1 Started ONLINE db2 Started ora. gsd OFFLINE db1 OFFLINE db2 ora. net1.network ONLINE db1 ONLINE db2 ora. ons ONLINE db1 ONLINE db2 ------------------------------------------------------------------------------------ Cl Uster Resources ---------------------------------------------------------------------------------- ora. LISTENER_SCAN1.lsnr 1 ONLINE db2 ora. cvu 1 ONLINE db1 ora. db1.vip 1 ONLINE db1 ora. db2.vip 1 ONLINE db2 ora. dmzdb. db 1 OFFLINE Instance Shutdown 2 OFFLINE Instance Shutdown ora.. scan1.vip 1 ONLINE db2 1 ONLINE db2 d View mem on the b1 node. In this case, memory_max_target is changed to 4G and memory_target is changed from 1536 M to M. [grid @ db1 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.3.0 Production on Wed Sep 25 14:54:41 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter mem; name type value ------------------------------------------------------ ----------------------- Memory_max_target big integer 4Gmemory_target big integer 512 MSQL> SQL> alter system set memory_target = 1536 m scope = both sid = '+ ASM1'; System altered. SQL> show parameter mem; NAME TYPE VALUE =------------- ------------------------------ memory_max_target big integer 4Gmemory_target big integer 1536Mdb2 node view mem. In this case, memory_max_target changes to 4G, From 1536 M to M [grid @ db2 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.3.0 Production on Wed Sep 25 22:52:53 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> SQL> show parameter mem; name type value generation ----------- ---------------------------- memory_max_target big integer 4Gmemory_target big integer 512 MSQL> alter system set memory_target = 1536 m scope = both sid = '+ ASM2'; System altered. SQL> show parameter mem; NAME TYPE VALUE -------------------------------------- memory_max_target big integer 4Gmemory_target big integer 1536 MSQL>