Steps to collect logs to troubleshooting ASM / ASMLIB issues

cat /etc/*release
uname -a
rpm -qa | grep oracleasm
df -ha
/etc/init.d/oracleasm status
/usr/sbin/oracleasm-discover
ls -ltr /dev/oracleasm/disks
sudo -u root /etc/init.d/oracleasm listdisks
sudo -u root /etc/init.d/oracleasm querydisk ORADATA_DD501_DISK01
cat /proc/partitions
ls -l /dev/mapper/*
ls -l /dev/emcpower*


Connect to ASM instance and upload the output to Oracle support


spool asm<#>.html
SET MARKUP HTML ON
set echo on
set pagesize 200
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual;


select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%';
select * from v$asm_diskgroup;
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER;
SELECT * FROM V$ASM_CLIENT;
select * from V$ASM_ATTRIBUTE;
select * from v$asm_operation;
select * from gv$asm_operation


select * from v$version;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show sga
spool off
exit