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
Was this article helpful?
thumb_up
Yes
thumb_down
No