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
'ora.evmd'
on
'db2'
CRS-2673: Attempting
to
stop
'ora.asm'
on
'db2'
CRS-2677: Stop
of
'ora.crsd'
on
'db1'
succeeded
CRS-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'
succeeded
CRS-2677: Stop
of
'ora.ctssd'
on
'db1'
succeeded
CRS-2677: Stop
of
'ora.evmd'
on
'db1'
succeeded
CRS-2677: Stop
of
'ora.ctssd'
on
'db2'
succeeded
CRS-2677: Stop
of
'ora.asm'
on
'db2'
succeeded
CRS-2673: Attempting
to
stop
'ora.cluster_interconnect.haip'
on
'db2'
CRS-2677: Stop
of
'ora.cluster_interconnect.haip'
on
'db2'
succeeded
CRS-2673: Attempting
to
stop
'ora.cssd'
on
'db2'
CRS-2677: Stop
of
'ora.cssd'
on
'db2'
succeeded
CRS-2677: Stop
of
'ora.asm'
on
'db1'
succeeded
CRS-2673: Attempting
to
stop
'ora.cluster_interconnect.haip'
on
'db1'
CRS-2677: Stop
of
'ora.cluster_interconnect.haip'
on
'db1'
succeeded
CRS-2673: Attempting
to
stop
'ora.cssd'
on
'db1'
CRS-2677: Stop
of
'ora.cssd'
on
'db1'
succeeded
启动crs 全部节点
[root@db1 ~]# crsctl start cluster -
all
CRS-2672: Attempting
to
start
'ora.cssdmonitor'
on
'db1'
CRS-2672: Attempting
to
start
'ora.cssdmonitor'
on
'db2'
CRS-2676: Start
of
'ora.cssdmonitor'
on
'db1'
succeeded
CRS-2672: Attempting
to
start
'ora.cssd'
on
'db1'
CRS-2676: Start
of
'ora.cssdmonitor'
on
'db2'
succeeded
CRS-2672: Attempting
to
start
'ora.diskmon'
on
'db1'
CRS-2672: Attempting
to
start
'ora.cssd'
on
'db2'
CRS-2672: Attempting
to
start
'ora.diskmon'
on
'db2'
CRS-2676: Start
of
'ora.diskmon'
on
'db1'
succeeded
CRS-2676: Start
of
'ora.diskmon'
on
'db2'
succeeded
CRS-2676: Start
of
'ora.cssd'
on
'db1'
succeeded
CRS-2672: Attempting
to
start
'ora.ctssd'
on
'db1'
CRS-2676: Start
of
'ora.cssd'
on
'db2'
succeeded
CRS-2672: Attempting
to
start
'ora.ctssd'
on
'db2'
CRS-2672: Attempting
to
start
'ora.cluster_interconnect.haip'
on
'db2'
CRS-2676: Start
of
'ora.ctssd'
on
'db1'
succeeded
CRS-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
'db2'
succeeded
CRS-2672: Attempting
to
start
'ora.evmd'
on
'db2'
CRS-2676: Start
of
'ora.evmd'
on
'db1'
succeeded
CRS-2676: Start
of
'ora.evmd'
on
'db2'
succeeded
CRS-2676: Start
of
'ora.cluster_interconnect.haip'
on
'db1'
succeeded
CRS-2672: Attempting
to
start
'ora.asm'
on
'db1'
CRS-2676: Start
of
'ora.cluster_interconnect.haip'
on
'db2'
succeeded
CRS-2672: Attempting
to
start
'ora.asm'
on
'db2'
CRS-2676: Start
of
'ora.asm'
on
'db1'
succeeded
CRS-2672: Attempting
to
start
'ora.crsd'
on
'db1'
CRS-2676: Start
of
'ora.crsd'
on
'db1'
succeeded
CRS-2676: Start
of
'ora.asm'
on
'db2'
succeeded
CRS-2672: Attempting
to
start
'ora.crsd'
on
'db2'
CRS-2676: Start
of
'ora.crsd'
on
'db2'
succeeded
[root@db1 ~]#
查看crs状态,发现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
1 ONLINE ONLINE db2
db1节点上查看mem,此时memory_max_target变为4G
修改memory_target ,由512M变为1536M
[grid@db1 ~]$ sqlplus /
as
sysasm
SQL*Plus: Release 11.2.0.3.0 Production
on
Wed Sep 25 14:54:41 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
4G
memory_target big
integer
512M
SQL>
SQL>
alter
system
set
memory_target=1536m scope=both sid=
'+ASM1'
;
System altered.
SQL> show parameter mem;
NAME
TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big
integer
4G
memory_target big
integer
1536M
db2节点上查看mem,此时memory_max_target变为4G
修改memory_target,由512M变为1536M
[grid@db2 ~]$ sqlplus /
as
sysasm
SQL*Plus: Release 11.2.0.3.0 Production
on
Wed Sep 25 22:52:53 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>
SQL> show parameter mem;
NAME
TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big
integer
4G
memory_target big
integer
512M
SQL>
alter
system
set
memory_target=1536m scope=both sid=
'+ASM2'
;
System altered.
SQL> show parameter mem;
NAME
TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big
integer
4G
memory_target big
integer
1536M
SQL>
|
oracle11g rac asm 实例内存修改
最新推荐文章于 2022-08-14 21:02:58 发布