Collecting The Required Information To Troubleshot ASM/ASMLIB Issues_869526.1

rongshiyuan發表於2014-03-11
Collecting The Required Information For Support To Troubleshot ASM/ASMLIB Issues. (Doc ID 869526.1)

In this Document

Goal
Solution
References

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Linux x86-64
Linux Itanium
Linux x86

Goal

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
$> ls -l /dev/oracleasm/disks
$> /sbin/blkid
$> find /dev/oracleasm/disks -type b | xargs -i sh -c "echo {}; dd if={} count=100 2>/dev/null | strings"
$> cat /proc/partitions |grep sd|while read a b c d;do echo -n $d$'\t'" scsi_id=";(echo $d|tr -d [:digit:]|xargs -i scsi_id -g -s /block/{})done

 
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/*


7) Finally connect to your ASM instance, provide me the output from the 3 scripts described in the next note (from each node if this is RAC):

 

  • Doc ID: 470211.1 How To Gather/Backup ASM Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2 & 12.1? 

 

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

8) If your OS is Oracle Linux (OL), then provide the "sosreport" from all the nodes as follows (execute it as root user):

 

# /usr/sbin/sosreport

 

Execution example:

 

[root@dbaasm ~]# /usr/sbin/sosreport

sosreport (version 1.7)

This utility will collect some detailed  information about the
hardware and  setup of your  Oracle Linux  system.
The information is collected and an archive is  packaged under
/tmp, which you can send to a support representative.
This information will be used for diagnostic purposes ONLY
and it will be considered confidential information.

This process may take a while to complete.
No changes will be made to your system.

Press ENTER to continue, or CTRL-C to quit.

Please enter your first initial and last name [dbaasm]:       Please enter the case number that you are generating this report for: SR_3-4555555555

 plugin pxe finished ...

 Completed.

Creating compressed archive...

Your sosreport has been generated and saved in:
  /tmp/sosreport-dbaasm.34555555555-197437-e61be7.tar.bz2

The md5sum is: 07b981289c9b8a2141d0b19d6be61be7

Please send this file to your support representative.

[root@dbaasm ~]#

 

9) 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
version: 2.0.6
license: GPL
srcversion: BB13CDD65668CBDA51D0C25
depends:
vermagic: 2.6.32-200.20.1.el5 SMP mod_unload



For additional information please check the link/note below:


=)> http://www.oracle.com/technetwork/server-storage/linux/uln-095759.html

=)> Kernel and rpms for Oracle Enterprise Kernel (UEK). (Document 1219066.1)

 

 


References

NOTE:1219066.1 - Kernel and rpms for Oracle Enterprise Kernel (UEK).

NOTE:560992.1 - Red Hat and Oracle Linux Kernel Versions and Release Strings


NOTE:1092213.1 - ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only).
NOTE:1528148.1 - How To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) And Assign Them To ASM?
NOTE:580153.1 - How To Setup ASM on Linux Using ASMLIB Disks, Raw Devices, Block Devices or UDEV Devices?
NOTE:1376731.1 - ASM 11gR2 Grid Infrastructure And RDBMS/Database Installation & Configuration Using ASM Job Role Separation (A Complete Guide).



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1107635/,如需轉載,請註明出處,否則將追究法律責任。

相關文章