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))
No comments:
Post a Comment