Database Process Hold Locks Dropped ASM Disk (Doc ID 2159941.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 While attempting to remove the LUN from OS Level failed with below errors.

ALTER DISKGROUP SCDT6P7DATA DROP DISK SCDPP7DATA_0038 REBALANCE POWER 9;

NOTE: disk 38 (SCDPP7DATA_0038) in group 2 (SCDT6P7DATA) is offline for reads
SUCCESS: disk SCDPP7DATA_0038 (38.235912897) dropped from diskgroup SCDT6P7DATA

 

$/usr/sbin/rmdev -d -l hdisk68
Method error (/etc/methods/ucfgdevice):0514-062 Cannot perform the requested function because the specified device is busy.

 

 $lsof|grep hdisk68

lsof: WARNING: compiled for AIX version 6.1.3.0; this is 7.1.0.0.
oracle 12255412 oracle 9u VCHR 18,68 0t0 33130 /dev/rhdisk68    << AQ process holding this disk

 

sqlplus ' as sysdba'
SID SERIAL# OSUSER SPID MACHINE
3 9 oracle 12255412 dbkdtms14.rze.de.db.com oracle@dbkdtms14.rze.de.db.com (Q001)

 

ps -ef|grep 12255412
oracle 12255412 1 0 Jun 13 - 0:05 ora_q001_SCDT6P71

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms