Forum Stats

  • 3,875,405 Users
  • 2,266,911 Discussions


intermittent issue with UTL_FILE

sandeepgupta_18 Member Posts: 51 Red Ribbon

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.