环境变量导致连接ASM报Connected to an idle instance

[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 2014Copyright (c)1982, 2011, Oracle.  All rights reserved.Connected to anidle instance. [root@huntdb02 ~]#crsstatResource 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  0Startedora.asm                                  ASM            L ONLINE     ONLINE       huntdb02         0 0 Startedora.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 Openora.txzldb.db                            database       C ONLINE     ONLINE       huntdb02         0 0 Open [grid@huntdb02 ~]$srvctl status asm -aASM is running onhuntdb01,huntdb02ASM is enabled. [grid@huntdb02 ~]$srvctl status diskgroup -g systemdg -aDisk Groupsystemdg is running on huntdb01,huntdb02Disk Groupsystemdg is enabled

现在基本可以肯定是环境变量导致的结果

CRS_HOME=/g01/app/11.2.0/grid/ORACLE_HOME=/g01/app/11.2.0/grid/ORACLE_BASE=/g01ORACLE_SID=+ASM2PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH CRS_HOME ORACLE_BASE ORACLE_SIDORACLE_HOME

修改环境变量如下（去掉grid最后的斜杠）

RS_HOME=/g01/app/11.2.0/gridORACLE_HOME=/g01/app/11.2.0/gridORACLE_BASE=/g01ORACLE_SID=+ASM2PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATHCRS_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 2014Copyright (c)1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the RealApplication Clusters and Automatic Storage Management optionsSQL>