Access to directory files from Oracle 19.11 database is generating ORA-29283: invalid file operation
Hi!
Environment:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
Red Hat Enterprise Linux Server release 7.9 (Maipo)
We got a problem with access a files to directory where are placed a files from sftp.
Directory permissions:
drwxrws---. 2 oradba branchcz 8192 Aug 19 10:24 .
Files permissions:
/.../ATLAS ls -la
...
-rw-rw----. 1 sftp branch 835952 Aug 19 07:10 mt940.dat
...
Binaries Oracle owner is oradba user.
Now, we can do everything with the files inside this directory. Copy, read, move (change name) as the oradba user. Oradba user and sftp user got the same group branch. But from database level:
set serveroutput on
declare
file utl_file.file_type;