rac集群 asmca 出现No Local ASM Instance

沉入海底的鱼

已于 2024-07-09 00:18:56 修改

阅读量107

点赞数 2

分类专栏： oracle 文章标签：服务器数据库运维

于 2024-07-09 00:03:12 首次发布

本文链接：https://blog.csdn.net/weixin_51690777/article/details/140281622

版权

oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

环境：linnux + oracle12c rac

故障现象：无语

解决方法：修改环境变量，然后重新启动两个节点。或者卸载掉再重新安装一下grid，再安装记得要清理干净。

//asm是正常运行的
[grid@rac1:/home/grid]$crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DGGRID1.dg ora....up.type ONLINE    ONLINE    rac1    
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1    
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1    
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    rac1    
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1    
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1    
ora....SM1.asm application    ONLINE    ONLINE    rac1    
ora....1.lsnr application    ONLINE    ONLINE    rac1    
ora....b1.ons application    ONLINE    ONLINE    rac1    
ora....b1.vip ora....t1.type ONLINE    ONLINE    rac1    
ora....SM2.asm application    ONLINE    ONLINE    rac2    
ora....2.lsnr application    ONLINE    ONLINE    rac2    
ora....b2.ons application    ONLINE    ONLINE    rac2    
ora....b2.vip ora....t1.type ONLINE    ONLINE    rac2    
ora.mgmtdb     ora....db.type ONLINE    ONLINE    rac1    
ora....network ora....rk.type ONLINE    ONLINE    rac1    
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1    
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1    
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1 

[grid@rac1:/home/grid]$asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run

//先是重启了一下，问题还是没解决，然后查看目录权限，环境变量，发现oracle目录发生了变化，是因为安装grid的时候运行grid报错，然后重新安装了一下，但是文件没有删除干净，安装grid的时候也没有细看，就next，next
[grid@rac1:/home/grid]$env | grep ORACLE
ORACLE_SID=+ASM1
ORACLE_BASE=/oracle/app/grid
ORACLE_TERM=xterm
ORACLE_HOME=/oracle/app/12.1/grid

[grid@rac1:/oracle/app]$ll
total 8
drwxrwxr-x.  3 grid   oinstall   18 Jul  8 08:23 12.1
drwxr-xr-x   3 root   oinstall   18 Jul  8 22:13 12.1.0
drwxrwxr-x. 11 grid   oinstall 4096 Jul  8 22:18 grid
drwxrwxr-x.  7 oracle oinstall   84 Jul  8 21:27 oracle
drwxrwx---.  6 grid   oinstall 4096 Jul  8 22:59 oraInventory