Re: utl_file and listener

From: Stephen Andert <andert_at_gmail.com>
Date: Tue, 30 Jun 2009 11:45:56 -0700
Message-ID: <6d45e210906301145m4ee65ecckae7087fe15200d52_at_mail.gmail.com>



Nope, same machine, and same user for both.

Thanks.

On Tue, Jun 30, 2009 at 11:38 AM, Stefan Knecht <knecht.stefan_at_gmail.com>wrote:

> Is the listener running under a different OS user than the database ?
>
> Stefan
>
>
> =========================
>
> Stefan P Knecht
> CEO & Founder
> s_at_10046.ch
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info_at_10046.ch
> http://www.10046.ch
>
> =========================
>
>
>
> On Tue, Jun 30, 2009 at 8:05 PM, Stephen Andert <andert_at_gmail.com> 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 (_at_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>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 30 2009 - 13:45:56 CDT

Original text of this message