asmcmd报错Connected to an idle instance & ASMCMD-08102
[root@rac1 ~]# su - grid
Last login: Fri Aug 28 21:21:46 CST 2020 on pts/3
[oracle@rac1 ~]$
[oracle@rac1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
ASMCMD>
查看状态:
[oracle@rac1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.oc4j
1 OFFLINE OFFLINE
ora.orcl.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac1
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1
ora.OCR.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE rac1
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type 0/5 0/0 OFFLINE OFFLINE
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1
ora.orcl.db ora....se.type 0/2 0/1 ONLINE ONLINE rac1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac2
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1
[oracle@rac1 ~]$
[oracle@rac1 ~]$ crsctl status server
NAME=rac1
STATE=ONLINE
NAME=rac2
STATE=ONLINE
crs_stat -t -v
没有看出有什么问题,进入sqlplus继续排查。
查看diskgroup:
SQL> set linesize 200
SQL> col path for a30
SQL> select name,path,state,group_number from v$asm_disk;
NAME PATH STATE GROUP_NUMBER
------------------------------ ------------------------------ -------- ------------
OCR_0000 /dev/oracleasm/disks/ASMOCR01 NORMAL 3
OCR_0001 /dev/oracleasm/disks/ASMOCR02 NORMAL 3
DATA_0000 /dev/oracleasm/disks/ASMDATA01 NORMAL 2
OCR_0002 /dev/oracleasm/disks/ASMOCR03 NORMAL 3
ARCH_0000 /dev/oracleasm/disks/ASMARCH01 NORMAL 1
DATA_0001 /dev/oracleasm/disks/ASMDATA02 NORMAL 2
6 rows selected.
SQL> select INST_ID,name,free_mb,state from gv$asm_diskgroup;
INST_ID NAME FREE_MB STATE
---------- ------------------------------ ---------- -----------
1 ARCH 506600 CONNECTED
1 DATA 2094317 CONNECTED
1 OCR 11359 MOUNTED
2 ARCH 506600 CONNECTED
2 DATA 2094317 CONNECTED
2 OCR 11359 MOUNTED
6 rows selected.
SQL>
前面的排查也没有发现问题。
最终排查到grid用户的环境变量没有了,是因为 /home/grid/.bash_profile 文件被误删除了导致。
# su - grid
$ echo $ORACLE_SID
$ echo $ORACLE_HOME
$ echo $PATH