咨询微信: dbservice1234 7 x 24 在线支持!

    你在这里

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

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

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

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638 E-mail: service@parnassusdata.com

 

 

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 <joel.becker@oracle.com>
version: 2.0.6
license: GPL
srcversion: BB13CDD65668CBDA51D0C25
depends:
vermagic: 2.6.32-200.20.1.el5 SMP mod_unload