Is the listener running under a different OS user than the database ? Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Tue, Jun 30, 2009 at 8:05 PM, Stephen Andert <andert@xxxxxxxxx> wrote: > Sort of strange scenario. > > Oracle 10.2.0.2 64 bit > SunOS 5.10 > > Added a new directory to utl_file. Let's call it /dir_a > > When a user (user1) connects locally (beq, not SQL*Net) to the db and > writes a file to /dir_a it works fine. > > When the same user (user1) connects to the db using listener (@dbtest), > they are not able to write to /dir_a, UNLESS the file is already there. The > error is: > > ORA-29283: invalid file operation > ORA-06512: at "SYS.UTL_FILE", line 475 > ORA-29283: invalid file operation > ORA-06512: at line 12 > > Same user can create a file in the directory outside the db as can the > oracle user. > > Any ideas? > > Thanks In Advance > > *Stephen Andert* > Blog <http://cactustri.blogspot.com/> | Flowing Desert > Photography<http://flowingdesert.com/> > Twitter <http://www.twitter.com/CactusTri> > > >