Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Intermittent Error with UTL_file

sandeepgupta_18Nov 16 2022

Hi All,
we have been using multiple pl/sql scripts or code those creates file using utl_file but from last 2 months we are seeing intermittent issue when ever code runs it shows error "Can not open File" once this errror starts occuring all scripts/jobs/queries those creates files using utl_file shows same error . this keeps happening for one or two hours after that everything come back to normal.
can anyone advise what could be the reason for this intermittent issue
Oracle version is 19c
below is the error

ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 878
ORA-06512: at line 687
ORA-29283: invalid file operation: cannot open file [29435]
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at line 346
ORA-06512: at line 1048
29282. 00000 - "invalid file ID"
*Cause: A file ID handle was specified for which no corresponding
open file exists.
*Action: Verify that the file ID handle is a value returned from a
call to UTL_FILE.FOPEN.

Comments
Post Details
Added on Nov 16 2022
1 comment
266 views