Session Accessing File On Disk Fail with OS File Permission Errors
Last updated on FEBRUARY 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2017***
This document applies to situation when a session supposed to access a disk file (LOB, flat file accessed with UTL_FILE, external table and so on) errors out with ORA-22288, ORA-29283, KUP-04063 and OS file permission errors while the OS oracle user can access the same files without problems, being able to create new files and write or read the existing files.
It can occur that bequeath sessions can access the files while the listener sessions can or even the opposite, when the listener created sessions can access the files while bequeath sessions can't.
To investigate the situation, the following steps should be done:
#1. start a new session with sqlplus.
#2. in the new created session, check what is the corresponding OS process ID for the shadow process:
(select paddr from v$session where sid =
(select distinct sid from v$mystat)
#3. create a new shell and enable OS tracing for that session:
(for AIX and Solaris)
#4. in the sqlplus session run the failing operation.
#5. check the resulting trace file with a file editor and look for the directory under which the file is created. It should indicate an OS access error: EACCES
For processes created by the listener, for which the files are generated when the process starts (eg audit files), take the same trace files for the listener process.
1. obtain the listener pid:
2. set tracing in the same way as above, eg:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms