Database Administration (MOSC)

MOSC Banner

Access to directory files from Oracle 19.11 database is generating ORA-29283: invalid file operation

edited Aug 19, 2021 8:43AM in Database Administration (MOSC) 5 commentsAnswered

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; 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center