Re: utl_file and listener
- From: Stephen Andert <andert@xxxxxxxxx>
- To: vamshi krishna <vamshireddy_1@xxxxxxxxxxx>, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Jun 2009 11:24:06 -0700
Thanks, that is good to know.
In this case though, it is not related to apps and everything is on the db
server.
Appreciate the info though.
On Tue, Jun 30, 2009 at 11:20 AM, vamshi krishna
<vamshireddy_1@xxxxxxxxxxx>wrote:
> In E-Business Suite
>
> this is how it works.
> the dir that exists in utl_file_dir parameter should also exist physically
> on the apps node for the connections from apps node to write to specified
> location which are connecting using tns to database node .
>
> i hope i gave an idea on how it works.
>
> Thanks,
> Vamshi .D
>
> ------------------------------
> *From:* Stephen Andert <andert@xxxxxxxxx>
> *To:* Oracle L <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Tuesday, June 30, 2009 11:05:22 AM
> *Subject:* utl_file and listener
>
> 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:
