Re: utl_file and listener
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Tue, 30 Jun 2009 20:38:57 +0200
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>
>
>
>
Other related posts: