ORA-27072: File I/O error Linux-x86_64 Error: 95: Operation not supported

[mariamkupa]

I am trying to backup database using RMAN, I mounted Azure blob storage container using goofys on my DB server and tried to run backup, got this:

RMAN-03009: failure of backup command on disk1 channel at 04/30/2022 20:17:09
ORA-19502: write error on file "/dbbackup/790s9423_1257_1_1", block number 1 (block size=16384)
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295

After that tried to create a text file from oracle user using touch a, it succeeded. Also tried to create a parameter file from sqlplus (note the parameter file was in text format), it succeeded.

But when I tried to create binary file from database, it failed:

SQL> create spfile='/dbbackup/spfile' from pfile='/dbbackup/pfile';
create spfile='/dbbackup/spfile' from pfile='/dbbackup/pfile'
*
ERROR at line 1:
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295
ORA-01078: failure in processing system parameters
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 3
Additional information: 4294967295

Is not goofys supported with Oracle database?

[mariamkupa]

My fstab entries is the following:

/usr/bin/goofys#wasb://dbbackup@marirmanstorage.blob.core.windows.net       /dbbackup         fuse    _netdev,allow_other,--file-mode=0777,--dir-mode=0777,--uid=3001,--gid=2000    0       0

[monthonk]

I think the problem is not file type but how oracle db write the file.

Goofys does not support random write or file append operations, which I think that's what your application does. Can you verify the write pattern of your application to see if it really is the case?