My Oracle Support Banner

Session Accessing File On Disk Fail with OS File Permission Errors (Doc ID 392647.1)

Last updated on JANUARY 02, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2 [Release 8.1.7 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2017***

Symptoms

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:

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!


In this Document
Symptoms
Cause
Solution

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