Collecting The Required Information To Troubleshot ASM/ASMLIB Issues_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):
$> 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):
$> /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 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/oracleasm
=)> /etc/sysconfig/oracleasm
5) Please show us the partition table (from each node if this is RAC):
6) If you are using multipath devices (mapper devices or emcpower) then show me the output of:
$> ls -l /dev/mapper/*
$> ls -l /dev/dm-*
$> ls -l /dev/emcpower*
Or if you have another multipath configuration then list the devices:
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):
Execution example:
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.)?
Example:
# up2date -i oracleasm-support oracleasmlib oracleasm-`uname -r`
The above command will install only 2 packages (oracleasm-support and oracleasmlib):
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 :
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【ASM】ASMLIB 系列ASM
- Using ASMLIB Management ASM DiskASM
- ASM using ASMLib and Raw DevicesASMdev
- oracle asm Unable to mount ASMlib driver filesystemOracleASM
- Oracle ASM REQUIRED_MIRROR_FREE_MBOracleASMUI
- 11g rac multipath asmlib ASM asm_open error Operation not permittedASMErrorMIT
- 【BUILD_ORACLE】使用ASMLib包搭建ASM磁碟UIOracleASM
- ASM學習筆記_配置ASMLIB磁碟組ASM筆記
- Using SQL Script Get Information about ASMSQLORMASM
- 不用ASMLIB建立11gr2 ASM例項ASM
- oracle ASM錯誤Initializing the Oracle ASMLib driver:[FAILED]OracleASMAI
- Oracle Collecting StatsticsOracle
- Collecting Numbers II
- ORA-15186: ASMLIB error function = [asm_open], error = [1]ASMErrorFunction
- asmlibASM
- linux vdo驗證 oracle asm diskgroup sector_size 4096 udev asmlibLinuxOracleASMdev
- Contens 5.8 安裝 oracle grid infrastruture(使用asmlib製作asm disk)OracleASTASM
- INFORMATION CENTER:Install and Configure Oracle ASM_1522675.2ORMOracleASM
- Force ASM to Scan the Multipathed First using ASMLIB RHEL 5/RHEL 6_1679409.1ASM
- oracle10g_asm_v$asm_disk之total_mb_free_mb_required_mirror_free_mb相互關係OracleASMUI
- PyCharm debug collecting data...PyCharm
- ASM 翻譯系列第四十彈:理解ASM中 REQUIRED_MIRROR_FREE_MB和USABLE_FILE_MB的含義ASMUI
- UDEV替代ASMLIBdevASM
- asmlib 報錯ASM
- ASM 翻譯系列第三十三彈:REQUIRED_MIRROR_FREE_MB的含義ASMUI
- 受困於v$asm_dksigroup裡的欄位REQUIRED_MIRROR_FREE_MB!ASMUI
- Uncertainy and informationAIORM
- Oracle ASMLib DownloadsOracleASM
- 「SWTR-4」Collecting Coins 題解
- Config LUNs for ASM Disk using WWID,DM-Multipathing,ASMLIB on RHEL 5/6_1365511.1ASM
- Disable the automatic funciton of collecting statistics in 10G
- oracle asmlib下載地址OracleASM
- oracle asmlib包相關OracleASM
- [Information Security] What is WEPORM
- Oracle Lock Information QueriesOracleORM
- 記一次AsmLib故障ASM
- Initializing the Oracle ASMLib driver: [FAILED]OracleASMAI
- Oracle RAC asmlib包下載地址OracleASM