ITPub博客

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

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

原创 Oracle 作者:feelpurple 时间:2016-06-15 17:12:29 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/26506993/viewspace-2120228/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    404
  • 访问量
    1674001