My Oracle Support Banner

SuperCluster: Intermittent ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE" when access external file or KUP-04040 or KUP-04062 from external tables (Doc ID 1929525.1)

Last updated on OCTOBER 17, 2023

Applies to:

SPARC SuperCluster T4-4 - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster M6-32 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Solaris on SPARC (64-bit)

Symptoms

External file operations from the database failing due to a libc file operation such as open, stat or access being interupted by a sigalarm.

 

Database errors will look as such

 

utl_file CASE

Intermitent ORA-29283: invalid file operation  ORA-06512: at "SYS.UTL_FILE" when access external file


External Tables case

Intermittant stacks such as

ERROR at line 1:
ORA-12801: error signaled in parallel query server P011, instance
<server:sid> (1)
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file <filename> in EXT_DB_DIR_1 not found


ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04062: no data source specified

 

A truss of the failing processes  ( this example will take a sid name in and truss specific libc calls for every parallel query slave)

  

Changes

 NA

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.