Command ALTER DATABASE DATAFILE ‘/OraBase1/oradata/stenar1/PrmZav_Data10.dbf’
RESIZE 15500M;
produce error
ORA-01237: cannot extend datafile 119
ORA-01110: data file 119: ‘/OraBase1/oradata/stenar1/PrmZav_Data10.dbf’
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 22: Invalid argument
Additional information: 4
We have raw devices on aix 5.3 . and oracle 11.2
File OraBase1/oradata/stenar1/PrmZav_Data10.db is symbolic link
$ ls -ltr PrmZav_Data10.dbf
lrwxrwxrwx 1 oracle dba 19 26 nov 10:26 PrmZav_Data10.dbf -> /
dev/rPrmZav_Data10
PrmZav_Data10 is logical volume on aix and i have before increasing size of datafile increased size of logical volume. So free space on LV
or raw devise is not problem.
But adding datafile in same tablespace and on the same disk is working. This operation - resizing datafile one ore two months ago was wroking normally. I don’t
know what happened.
Thank you in advance for your answers,
Miran