Re: Concurrent program failing with ORA-29285: file write error and ORA-06512
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 2 Jan 2008 22:43:52 +0530
Thanks a ton for all,
I did check for all the TMP directories, everything is fine.
We have other CP working fine, but this is a custom CP, Should this be taken
care by Developers and to have a look in Pl/SQL code. I see other Custom CP
and standard CP's are working fine.
Also I dont see any previous successful completed requests :-(.
Thanks,
An
On Jan 2, 2008 5:28 AM, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:
> The problem is on DB side you need to check in addition that UTL_DIR
> init.ora parameter meet APPLTMP variable value.
> Some times if more then 1 Apps environments running on the same server
> it might be that they have got the same directory specified if this is
> the case then at some point in time first environment might create a
> file with the same name as second one would like to. It will introduce
> a conflict (perditions to overwrite the file).
>
> Check this out.
>
> J.
>
> On Jan 1, 2008 10:54 PM, Na'eem <naim.deen@xxxxxxxxx> wrote:
> > Hi
> > check for APPLPTMP ,APPLTMP variable in env file .
> > Check for permission on the directory .
> >
> > Regards
> > naim
> >
> >
> >
> >
> > On 1/1/08, Shastry(DBA) <shastry17@xxxxxxxxx> wrote:
> > > Hi all,
> > >
> > > I have the below error while running a Concurrent program, I checked
> for
> > the UTL parameter and the file location, Space, Everything looks fine,
> but
> > not able to figure out the problem for the below error, Searching
> Metalink
> > did not help. So please advice me if you have any light on this.
> > >
> > > ORACLE error 29285 in FDPSTP
> > >
> > > Cause: FDPSTP failed due to ORA-29285: file write error
> > > ORA-06512: at "SYS.UTL_FILE", line 18
> > > ORA-06512: at "SYS.UTL_FILE", line 722
> > > ORA-06512: at " APPS.XXTP_ENDUSER_HULP_PKG", line 792
> > > ORA-06512: at line 1
> > >
> > > Thanks,
> > > Ananth
> > >
> >
> >
>
>
>
> --
> Yury
> +371 29268222 (+2 GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
>
Other related posts:
