Search This Blog

Total Pageviews

Saturday 11 February 2012

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

 

ASMCMD> lsdg

ASMCMD-08102: no connection to ASM; command requires ASM to run
+ASM variables are not set properly

set following parameter ...

export ORACLE_SID=+ASM
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid



[oracle@oel5u4-+ASM bin] echo $ORACLE_SID
+ASM


then connect asmcmd



ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576      9216     5657              896            2380              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576      9216     8998                0            8998              0             N  FRA/
ASMCMD> 


search word ..
How to shutdown ASM
shutdown ASM



first shutdown the database .

then 
set following


[oracle@oel5u4-orcl ~] export ORACLE_SID=+ASM
[oracle@oel5u4-+ASM ~] export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
[oracle@oel5u4-+ASM ~] 
[oracle@oel5u4-+ASM ~] 
[oracle@oel5u4-+ASM ~] sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 11 18:39:09 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option


SQL> shutdown immediate 


1 comment:

orcl11gdba said...

that’s great .
this also clears the same.
http://orcl11gdba.blogspot.in/2014/08/asmcmd-08102-no-connection-to-asm.html

Oracle DBA

anuj blog Archive