ORA-17500: ODM err:ODM ERROR V-41-4-2-199-28 No space left on device

book

Article ID: 100029867

calendar_today

Updated On:

Description

Error Message

ORA-17500: ODM err:ODM ERROR V-41-4-2-199-28 No space left on device

Resolution

The issue:
This error can occur when trying toextend an Oracle ODM file if the file is a Quick I/O file that was converted toan ODM file.
A converted Quick I/O file can have a space reservation set onthe file that will prevent extending the file to a size larger than thereservation.  

To resolve the issue:
Use the followingexample procedure to check and remove a space reservation.

1. Check for aspace reservation on the file using the getext command, forexample:

# /opt/VRTS/sbin/getexttest
test: Bsize 1024 Reserve 1024Extent Size 0

In the above example, the file "test" has aspace reservation (Reserve) of 1024 file system blocks.  
(Note: onolder versions of VERITAS File System the command path might be/usr/lib/fs/bin/getext.)


2. If the ODM file in question has a spacereservation, use the setext command to clear thereservation:

# /opt/VRTS/sbin/setext -r 0test

(Note: on older versions of VERITAS File System thecommand path might be /usr/lib/fs/vxfs/bin/setext.)


3. Verify theremoval of the space reservation using getext.

# /opt/VRTS/sbin/getexttest
test: Bsize 1024 Reserve 0 Extent Size 0

Note that Reserve isnow zero and the space reservation is gone.
 
 

 

Issue/Introduction

ORA-17500: ODM err:ODM ERROR V-41-4-2-199-28 No space left on device