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