asmcmd报错Connected to an idle instance & ASMCMD |
您所在的位置:网站首页 › sqlplus登陆asm › asmcmd报错Connected to an idle instance & ASMCMD |
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 |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |