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

悠悠 2024-04-18 00:12 72阅读 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博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2120228/，如需转载，请注明出处，否则将追究法律责任。

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