Hi everyone,
We recently moved our DB 12cR1 on Windows 2016 to a DB19c on windows 2022
We have an automatic batch running every 20 minute looking at a folder and reading files into it with SYS.UTL_FILE.FOPEN function
Since the migration, sometimes it happens that we get an
"ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]" error when using SYS.UTL_FILE.FOPEN
Our automatic procedure send an email for each error we get several error email recently and I would like to fix this asap
We received 1 or 2 email per day so it means most of the times it works well
Our account have the grant to read/write in the related directory and on the next run 20 minutes later all works well
And I am unable to reproduce it with SQL Developer
I didn't found anything useful on My Oracle support for this error
But maybe anyone can help me to understand what happens and how to avoid it please?
Thanks
Best regards,