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 MARCH 23, 2015

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 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

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 hundreds of Community platforms