Session Accessing File On Disk Fail with OS File Permission Errors
(Doc ID 392647.1)
Last updated on FEBRUARY 03, 2022
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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.
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:
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