Wednesday 20 August 2014

ASMCMD-08102: no connection to ASM; command requires ASM to run



How to resolve the error  "ASMCMD-08102: no connection to ASM; command requires ASM to run" ?

[oracle@host1.xxx.com]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run

Cause: This is a simple error occurred because the ASM instance environment variables are not set properly

Solution:
We need to Set ASM instance environment variables
[oracle@host1.xxx.com ]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid  
                                                                                   (or)
                                                setenv ORACLE_HOME  /u01/app/oracle/product/11.2.0/grid
[oracle@host1.xxx.com ]$ export PATH=/u01/app/oracle/product/11.2.0/grid/bin
                                                                                   (or )
                                                setenv PATH /u01/app/oracle/product/11.2.0/grid/bin
[oracle@host1.xxx.com ]$ export ORACLE_SID=+ASM1
                                                                                    (or)
                                                 setenv ORACLE_SID  +ASM1

Now the variables are set properly you can check the list
[oracle@host1.xxx.com ]$ asmcmd

ASMCMD> ls
DATA/
FRA/

OCR_VOTE/





No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...