环境变量导致连接ASM报Connectedtoanidleinstance
[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
成都创新互联专业为企业提供兴宁网站建设、兴宁做网站、兴宁网站设计、兴宁网站制作等企业网站建设、网页设计与制作、兴宁企业网站模板建站服务,10余年兴宁做网站经验,不只是建网站,更提供有价值的思路和整体网络服务。
现在基本可以肯定是环境变量导致的结果
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>
新闻名称:环境变量导致连接ASM报Connectedtoanidleinstance
网站路径:http://scyanting.com/article/gichse.html