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疑问解答:
- 运行exp备份oracle数据库提示oracle-12154错误
- 有没有,生产Oracle Rman 备份脚本的工具啊!
- 初学orcle,希望有大大帮忙解说一下详细步骤,从登录oracle到创建表的过程
- oracle语句问题:一张user表,三个字段,id,name,time,插入记录比如:张三2007,李四2008,张三2011
- 如何写一个ORACLE触发器同步两个表中的数据?
- oracle 如何查看一个服务器上有多少个数据库.
- oracle 创建包的时候错误 求解
- oracle 重复列的问题
- oracle 中如何查处2星期前的数据
- 请教oracle数据库安装中的问题
- 请问谁能提供给我标准的oracle ERP的数据库表结构并详细说明各表主要的作用?
- 安装oracle遇到的问题 invalid entry CRC (expected 0x3e12e795 but got 0x9db0e9fd)
- 我的是ORACLE 10G,在RMAN中如何按指定的时间恢复数据文件啊?
- oracle为什么没有自动增长列
- oracle快捷键都有哪些啊?