Oracle 11g RAC的ASM实例内存参数被修改导致无法启动

最新推荐文章于 2022-09-23 14:11:52 发布

cuantangnie3915

最新推荐文章于 2022-09-23 14:11:52 发布

阅读量323

点赞数

文章标签：数据库

RAC有两个节点，节点二启动失败，手动启动报错：
[root@PTFDB2 ~]# cd /u01/app/11.2.0/grid
[root@PTFDB2 grid]# ./crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors.

在节点一查看RAC状态
[grid@PTFDB1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE ptfdb1
ora.FRA.dg ora....up.type ONLINE ONLINE ptfdb1
ora....ER.lsnr ora....er.type ONLINE ONLINE ptfdb1
ora....N1.lsnr ora....er.type ONLINE ONLINE ptfdb1
ora.OCR.dg ora....up.type ONLINE ONLINE ptfdb1
ora.REDO1.dg ora....up.type ONLINE ONLINE ptfdb1
ora.REDO2.dg ora....up.type ONLINE ONLINE ptfdb1
ora.asm ora.asm.type ONLINE ONLINE ptfdb1
ora.cvu ora.cvu.type ONLINE ONLINE ptfdb1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE ptfdb1
ora.oc4j ora.oc4j.type ONLINE ONLINE ptfdb1
ora.ons ora.ons.type ONLINE ONLINE ptfdb1
ora.ptfdb.db ora....se.type ONLINE ONLINE ptfdb1
ora....SM1.asm application ONLINE ONLINE ptfdb1
ora....B1.lsnr application ONLINE ONLINE ptfdb1
ora.ptfdb1.gsd application OFFLINE OFFLINE
ora.ptfdb1.ons application ONLINE ONLINE ptfdb1
ora.ptfdb1.vip ora....t1.type ONLINE ONLINE ptfdb1
ora.ptfdb2.vip ora....t1.type ONLINE ONLINE ptfdb1
ora....ry.acfs ora....fs.type ONLINE ONLINE ptfdb1
ora.scan1.vip ora....ip.type ONLINE ONLINE ptfdb1

之前grid实例的MEMORY_TARGET被人为修改成较大的值，导致ASM实例在启动时报错，登录节点一的ASM实例，修改内存参数：
[grid@PTFDB1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 15 15:42:32 2016

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 memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 512M
memory_target big integer 512M
SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
sga_max_size big integer 512M
sga_target big integer 0
SQL> show parameter sga

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCR/ptfdb-cluster/asmparamete
rfile/registry.253.841152655
SQL> alter system set memory_target=512M scope=spfile;

System altered.

SQL> alter system set memory_max_target=512M scope=spfile;

System altered.

SQL> alter system set sga_max_size=512M scope=spfile;

System altered.

SQL> alter system set sga_target=512M scope=spfile;

System altered.

登录节点二的ROOT用户，手动杀掉已经启动的RAC进程
[root@PTFDB2 ~]# ps -fea | grep ohasd.bin | grep -v grep
root 8701 1 0 Jun14 ? 00:01:05 /u01/app/11.2.0/grid/bin/ohasd.bin reboot
[root@PTFDB2 ~]# ps -fea | grep gipcd.bin | grep -v grep
grid 8985 1 0 Jun14 ? 00:01:30 /u01/app/11.2.0/grid/bin/gipcd.bin
[root@PTFDB2 ~]# ps -fea | grep mdnsd.bin | grep -v grep
grid 8930 1 0 Jun14 ? 00:00:03 /u01/app/11.2.0/grid/bin/mdnsd.bin
[root@PTFDB2 ~]# ps -fea | grep gpnpd.bin | grep -v grep
grid 8946 1 0 Jun14 ? 00:00:33 /u01/app/11.2.0/grid/bin/gpnpd.bin
[root@PTFDB2 ~]# ps -fea | grep evmd.bin | grep -v grep
grid 9237 1 0 Jun14 ? 00:02:30 /u01/app/11.2.0/grid/bin/evmd.bin
[root@PTFDB2 ~]# ps -fea | grep crsd.bin | grep -v grep
[root@PTFDB2 ~]# kill -9 8701 8985 8930 8946 9237

启动CRS
[root@PTFDB2 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started
[grid@PTFDB2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE ptfdb1
ora.FRA.dg ora....up.type ONLINE ONLINE ptfdb1
ora....ER.lsnr ora....er.type ONLINE ONLINE ptfdb1
ora....N1.lsnr ora....er.type ONLINE ONLINE ptfdb1
ora.OCR.dg ora....up.type ONLINE ONLINE ptfdb1
ora.REDO1.dg ora....up.type ONLINE ONLINE ptfdb1
ora.REDO2.dg ora....up.type ONLINE ONLINE ptfdb1
ora.asm ora.asm.type ONLINE ONLINE ptfdb1
ora.cvu ora.cvu.type ONLINE ONLINE ptfdb1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE ptfdb1
ora.oc4j ora.oc4j.type ONLINE ONLINE ptfdb1
ora.ons ora.ons.type ONLINE ONLINE ptfdb1
ora.ptfdb.db ora....se.type ONLINE ONLINE ptfdb1
ora....SM1.asm application ONLINE ONLINE ptfdb1
ora....B1.lsnr application ONLINE ONLINE ptfdb1
ora.ptfdb1.gsd application OFFLINE OFFLINE
ora.ptfdb1.ons application ONLINE ONLINE ptfdb1
ora.ptfdb1.vip ora....t1.type ONLINE ONLINE ptfdb1
ora....SM2.asm application ONLINE ONLINE ptfdb2
ora....B2.lsnr application ONLINE ONLINE ptfdb2
ora.ptfdb2.gsd application OFFLINE OFFLINE
ora.ptfdb2.ons application ONLINE ONLINE ptfdb2
ora.ptfdb2.vip ora....t1.type ONLINE ONLINE ptfdb2
ora....ry.acfs ora....fs.type ONLINE ONLINE ptfdb1
ora.scan1.vip ora....ip.type ONLINE ONLINE ptfdb1

启动数据库，数据库恢复正常
SQL> startup

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2120228/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2120228/