Skip to content
Advertisements

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

[oracle@mazar ~]$ asmcmd
Connected to an idle instance.
ASMCMD> ls -L +DATA
ASMCMD-08102: no connection to ASM; command requires ASM to run

Solution :
We need to Set ASM Instance Oracle home path 
[oracle@mazar ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
[oracle@mazar ~]$ export PATH=/u01/app/oracle/product/11.2.0/grid/bin
[oracle@mazar ~]$ export ORACLE_SID=+ASM
[oracle@mazar ~]$ asmcmd

ASMCMD> ls -L +DATA/DBASM/DATAFILE
SYSAUX.257.753010705
SYSTEM.256.753010703
TESTTBS.275.753248961
UNDOTBS1.258.753010705
USERS.259.753010705
ASMCMD>
Advertisements
6 Comments Post a comment
  1. Mohsin Javed #

    Helped me alot thanks sirji

    September 9, 2011
  2. parvez ahmad #

    azhar bhai ,
    your solution really help me. thanks a lot

    June 21, 2013
  3. naqi #

    thanks also help me.

    February 17, 2016
  4. Wolmer #

    Your are the master and save my time. No Oracle Support docs has this nformation.

    June 30, 2016

Trackbacks & Pingbacks

  1. ASMCMD-08102: no connection to ASM; command requires ASM to run | Oracle in Thai | Oracle in Thai | Oracle User Group in Thailand |

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: