My Oracle Support Banner

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

Last updated on JANUARY 22, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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 test01 oracle@<HOST NAME> (Q001)

 

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

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.