Sunday, July 17, 2011

Unable to connect ASM instance using sqlplus/asmcmd at 11gR2 'Connected To An Idle Instance'

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