Just after installing 11gR2 patch set 1, I checked all of my cluster services every thing was up and running then I tried to connect ASM instance which is now builtin from 11g onward, I got an error 'Connected To An Idle Instance', I checked all my services related to ASM it were all up and running i.e. ora.asm, pmon, smon etc., then I got an Oracle support document saying I have to remove forward slash '/' from ORACLE_HOME environment variable in my .profile file setting.
Incorrect value:
ORACLE_HOME=/u01/app/11.2.0/grid/
Correct value:
ORACLE_HOMe=/u01/app/11.2.0/grid
After this I can connect to ASM instance properly :).
Regards,
Farrukh Salman,
Reference Link:
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(viewingMode=1143&bmDocID=1179825.1&bmDocDsrc=KB&bmDocType=PROBLEM&bmDocTitle=Unable%20To%20Connect%20To%20ASM%20Due%20To%20SQL*Plus%20Shows%20%E2%80%9CConnected%20To%20An%20Idle%20Instance.&from=BOOKMARK))
Showing posts with label can not connect to ASM 'Connected To An Idle Instance' 11g grid. Show all posts
Showing posts with label can not connect to ASM 'Connected To An Idle Instance' 11g grid. Show all posts
Subscribe to:
Posts (Atom)