[grid@huntdb02 ~]$export ORACLE_SID=txzldb2 [grid@huntdb02 ~]$sqlplus "/as sysasm" SQL*Plus: Release11.2.0.3.0 Production on Wed Jul 9 15:07:55 2014 Copyright (c)1982, 2011, Oracle. All rights reserved. Connected to anidle instance. [root@huntdb02 ~]#crsstat Resource Name Resource Type Target State Node FC RC State Details -------------------------------------------------------- ---------- ------------ --------------- -- -- --------------- ora.BACKDG.dg diskgroup L ONLINE ONLINE huntdb01 0 0 ora.BACKDG.dg diskgroup L ONLINE ONLINE huntdb02 0 0 ora.DATA.dg diskgroup L ONLINE ONLINE huntdb01 0 0 ora.DATA.dg diskgroup L ONLINE ONLINE huntdb02 0 0 ora.LISTENER.lsnr Listener L ONLINE ONLINE huntdb01 0 0 ora.LISTENER.lsnr Listener L ONLINE ONLINE huntdb02 0 0 ora.LISTENER_SCAN1.lsnr SCAN Listener C ONLINE ONLINE huntdb02 0 0 ora.SYSTEMDG.dg diskgroup L ONLINE ONLINE huntdb01 0 0 ora.SYSTEMDG.dg diskgroup L ONLINE ONLINE huntdb02 0 0 ora.asm ASM L ONLINE ONLINE huntdb01 0 0Started ora.asm ASM L ONLINE ONLINE huntdb02 0 0 Started ora.cvu cvu C ONLINE ONLINE huntdb02 0 0 ora.gsd Gbl Svc Daemon L ONLINE OFFLINE (huntdb01) 0 0 ora.gsd Gbl SvcDaemon L ONLINE OFFLINE (huntdb02) 0 0 ora.huntdb01.vip Cluster VIP C ONLINE ONLINE huntdb01 0 0 ora.huntdb02.vip Cluster VIP C ONLINE ONLINE huntdb02 0 0 ora.net1.network Network (VIP) L ONLINE ONLINE huntdb01 0 0 ora.net1.network Network (VIP) L ONLINE ONLINE huntdb02 0 0 ora.oc4j OC4J C ONLINE ONLINE huntdb02 0 0 ora.ons Ora NotifSvc L ONLINE ONLINE huntdb01 0 0 ora.ons Ora NotifSvc L ONLINE ONLINE huntdb02 0 0 ora.scan1.vip SCAN VIP C ONLINE ONLINE huntdb02 0 0 ora.txzldb.db database C ONLINE ONLINE huntdb01 0 0 Open ora.txzldb.db database C ONLINE ONLINE huntdb02 0 0 Open [grid@huntdb02 ~]$srvctl status asm -a ASM is running onhuntdb01,huntdb02 ASM is enabled. [grid@huntdb02 ~]$srvctl status diskgroup -g systemdg -a Disk Groupsystemdg is running on huntdb01,huntdb02 Disk Groupsystemdg is enabled
现在基本可以肯定是环境变量导致的结果
CRS_HOME=/g01/app/11.2.0/grid/ ORACLE_HOME=/g01/app/11.2.0/grid/ ORACLE_BASE=/g01 ORACLE_SID=+ASM2 PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH CRS_HOME ORACLE_BASE ORACLE_SID ORACLE_HOME
修改环境变量如下（去掉grid最后的斜杠）
RS_HOME=/g01/app/11.2.0/grid ORACLE_HOME=/g01/app/11.2.0/grid ORACLE_BASE=/g01 ORACLE_SID=+ASM2 PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH CRS_HOME ORACLE_BASE ORACLE_SID ORACLE_HOME
登录测试
[grid@huntdb02 ~]$sqlplus "/as sysasm" SQL*Plus: Release11.2.0.3.0 Production on Wed Jul 9 15:10:48 2014 Copyright (c)1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the RealApplication Clusters and Automatic Storage Management options SQL>
本文出自 “HUNT” 博客，请务必保留此出处http://hunt1574.blog.51cto.com/1390776/1436652
环境变量导致连接ASM报Connected to an idle instance,布布扣,bubuko.com
环境变量导致连接ASM报Connected to an idle instance
原文：http://hunt1574.blog.51cto.com/1390776/1436652