Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
intermittent issue with UTL_FILE
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.