Collecting The Required Information For Support To Troubleshot Oracle ASM/ASMLIB Issues.

If you cannot recover data by yourself, ask DBRECOVER, the professional Oracle database recovery team for help.

DBRECOVER Software Database Recovery Team

Service Hotline: +86 13764045638 E-mail: [email protected]

1) The present document provides a list of steps to collect the required information to troubleshoot & diagnostic ASM/ASMLIB Issues required for support.

2) Obtain the most recent ASMLIB & ASM state from your current environment.

Solution

1) In order to check if the ASMLIB API is correctly configured, please execute the next commands and provide us the output (from each node if this is RAC):

$> cat /etc/*release $> uname -a $> rpm -qa |grep oracleasm $> df -ha $>/usr/sbin/oracleasm configure $> /sbin/modinfo oracleasm

2) Check the discovery path (from each node if this is RAC)

$> /etc/init.d/oracleasm status $> /usr/sbin/oracleasm-discover $> /usr/sbin/oracleasm-discover 'ORCL:*'

3) Please check if the ASMLIB devices can be accessed (from each node if this is RAC)

$> /etc/init.d/oracleasm scandisks $> /etc/init.d/oracleasm listdisks $> /etc/init.d/oracleasm querydisk -p <each disk from previous output> $> ls -l /dev/oracleasm/disks $> /sbin/blkid

4) Upload the next files from each node if this is RAC

=)> /var/log/messages* =)> /var/log/oracleasm =)> /etc/sysconfig/oracleasm

5) Please show us the partition table (from each node if this is RAC)

$> cat /proc/partitions

6) If you are using multipath devices (mapper devices or emcpower) then show me the output of

$> ls -l /dev/mpath/* $> ls -l /dev/mapper/* $> ls -l /dev/dm-* $> ls -l /dev/emcpower*

Or if you have another multipath configuration then list the devices

$> ls -l /dev/<multi path device name>*

7) Finally connect to your ASM instance, execute the next script and upload me the output file (from each node if this is RAC):

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

Note: please compress those files in just one file (*.zip or *.tar) and upload it thru Metalink.

8) Also, if this is not a new ASM/ASMLIB implementation, please describe in detail what has changed since this last worked (OS patches, OS kernel upgrade, SAN migration, etc.)?

Note: If you are installing UEK (Unbreakable Enterprise Kernel), therefore the Oracle ASMLib kernel driver is now included in the Unbreakable Enterprise Kernel. No driver package needs to be installed when using this kernel. The oracleasm-support and oracleasmlib packages still need to be installed from ULN (below):

Example

# up2date -i oracleasm-support oracleasmlib oracleasm-`uname -r`

The above command will install only 2 packages (oracleasm-support and oracleasmlib)

[oracle@cstdb02 database]$ cat /etc/*release Enterprise Linux Enterprise Linux Server release 5.7 (Carthage) Oracle Linux Server release 5.7 Red Hat Enterprise Linux Server release 5.7 (Tikanga) [oracle@cstdb02 database]$ uname -a Linux cstdb02.cstdi.com 2.6.32-200.20.1.el5uek #1 SMP Fri Oct 7 02:29:42 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux [oracle@cstdb02 database]$ rpm -qa |grep oracleasm oracleasm-support-2.1.7-1.el5 oracleasmlib-2.0.4-1.el5

This is due to the driver package is now embedded in the UEK kernel

[root@cstdb02 database]# modinfo oracleasm filename: /lib/modules/2.6.32-200.20.1.el5/kernel/drivers/block/oracleasm/oracleasm.ko description: Kernel driver backing the Generic Linux ASM Library. author: Joel Becker < [email protected] > version: 2.0.6 license: GPL srcversion: BB13CDD65668CBDA51D0C25 depends: vermagic: 2.6.32-200.20.1.el5 SMP mod_unload

DBRECOVER Recovery Options

For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.

When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.