当前位置:数据库 > Oracle >>

oracle11g rac asm 实例内存修改

oracle11g rac asm 实例内存修改
 
memory_max_target(它为静态参数,修改完成后需要重启实例)

memory_target(它为动态参数,不需要重启实例)

SQL> select name,issys_modifiable from v$parameter   where name='memory_max_target';
  
NAME                                                                             ISSYS_MOD
-------------------------------------------------------------------------------- ---------
memory_max_target                                                                FALSE


SQL> select name,issys_modifiable from v$parameter where name='memory_target';

NAME                                                                             ISSYS_MOD
-------------------------------------------------------------------------------- ---------
memory_target                                                                    IMMEDIATE










查看ASM内存,并修改memory_max_target,由512M变为4G
[grid@db1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 25 14:44:59 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


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> show parameter mem;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 512M
memory_target                        big integer 512M
SQL>
SQL>
SQL> alter system set memory_max_target=4G scope=spfile;

System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options






查看crs状态(因为测试数据库实例与监听没有启动,如果生产环境中,建议一个个去停,保证业务正常运行)
[grid@db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       db1                                         
               ONLINE  ONLINE       db2                                         
ora.FRA.dg
               ONLINE  ONLINE       db1                                          
               ONLINE  ONLINE       db2                                         
ora.LISTENER.lsnr
               OFFLINE OFFLINE      db1                                         
               OFFLINE OFFLINE      db2                                         
ora.OCR.dg
               ONLINE  ONLINE       db1                                         
               ONLINE  ONLINE       db2                                         
ora.asm
               ONLINE  ONLINE       db1                      Started            
               ONLINE  ONLINE       db2                      Started            
ora.gsd
               OFFLINE OFFLINE      db1                                          
               OFFLINE OFFLINE      db2                                         
ora.net1.network
               ONLINE  ONLINE       db1                                         
               ONLINE  ONLINE       db2                                          
ora.ons
               ONLINE  ONLINE       db1                                         
               ONLINE  ONLINE       db2                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       db2                                         
ora.cvu
      1        ONLINE  ONLINE       db1                                         
ora.db1.vip
      1        ONLINE  ONLINE       db1                                         
ora.db2.vip
      1        ONLINE  ONLINE       db2                                         
ora.dmzdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown  
      2        OFFLINE OFFLINE                               Instance Shutdown  
ora.oc4j
      1        ONLINE  ONLINE       db1                                         
ora.scan1.vip
      1        ONLINE  ONLINE       db2                                         
[grid@db1 ~]$





停crs  全部节点
注:修改asm实例内存,需要重启asm实例
测试了下重启实例,需要停diskgroup相对重启crs要麻烦
故选择重启crs,生产环境可以一个个实例重启,保证业务能够运行
本例为了测试方便去,全部停止,全部启动

[root@db1 ~]# crsctl stop  cluster -all
CRS-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 'db1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'db1'
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' succeeded
CRS-2677: Stop of 'ora.db2.vip' on 'db2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'db1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'db2'
CRS-2677: Stop of 'ora.FRA.dg' on 'db2' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'db2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'db1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'db2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'db1' succeeded
CRS-2677: Stop of 'ora.cvu' on 'db1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db1'
CRS-2677: Stop of 'ora.OCR.dg' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'db2'
CRS-2677: Stop of 'ora.asm' on 'db1' succeeded
CRS-2677: Stop of 'ora.asm' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'db2'
CRS-2677: Stop of 'ora.ons' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db2'
CRS-2677: Stop of 'ora.net1.network' on 'db2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db2' has completed
CRS-2673: Attempting to stop 'ora.ons' on 'db1'
CRS-2677: Stop of 'ora.ons' on 'db1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'db1'
CRS-2677: Stop of 'ora.net1.network' on 'db1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'db1' has completed
CRS-2677: Stop of 'ora.crsd' on 'db2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'db2'
CRS-2673: Attempting to stop 
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,