Re: ORA-20100: File l1380173.tmp creation for FND_FILE failed
- From: Vikram <vikramsingh120@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 11 May 2010 06:21:31 -0700
Usually when I receive such an error, there are two things that I check
immediately:
1) Check the permissions on APPLPTMP
2) Ensure this directory is the *first* entry to the UTL_FILE_DIR parameter
in init.ora
The following SQL should run successfully as APPS user:
SQL> conn apps/password
SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
Let me know.
-Vikram
On Tue, May 11, 2010 at 5:46 AM, <abmian1981@xxxxxxxxx> wrote:
> Hi Yury,
>
> that would be the point. 12 instance running on same machine :). let
> me check this
>
> Thanks,
> Ahmad Bilal
> Sent by Using BlackBerry(R)
>
>
>
> 2010/5/11 Yury Velikanov <j.velikanovs@xxxxxxxxx>:
> > Another think to check: are there any other dev/test/uat environments
> > running on the same server. The tmp file with the same name could be
> > created in /tmp dir by other env. Make sure you TMP dirs pointing to
> > different locations for different envs.
> >
> > Y.
> >
> > On Tue, May 11, 2010 at 12:04 AM, Miguel A. Bennasar
> > <mabennasar@xxxxxxxxx> wrote:
> >> Hi.
> >>
> >> Do you have the DbTier and the AppTier in the same machine? If not:
> >>
> >> - Check $APPLPTMP in the AppTier
> >> - Check that this same path is in your utl_file_dir
> >> - Check that this path is available in both DbTier and AppTier and that
> both
> >> users (dbuser and appuser) can read/write on it.
> >>
> >> Regards.
> >>
> >> El 10/05/2010 14:22, abmian1981@xxxxxxxxx escribió:
> >>>
> >>> Thanks for your response
> >>> yes both are verified
> >>>
> >>> Thanks,
> >>> Ahmad Bilal
> >>> Sent by Using BlackBerryŽ
> >>>
> >>>
> >>>
> >>> On Mon, May 10, 2010 at 12:02 PM, Prasanna Pandian
> >>> <prasanna.pandian@xxxxxxxxx> wrote:
> >>>
> >>>>
> >>>> Hi,
> >>>> Do check whether the "tmp" folder has enough space and also 'applmgr'
> >>>> account has write permission on that folder.
> >>>> Thanks,
> >>>> Prasanna
> >>>>
> >>>> On Mon, May 10, 2010 at 9:49 AM,<abmian1981@xxxxxxxxx> wrote:
> >>>>
> >>>>>
> >>>>> Hi Lads,
> >>>>>
> >>>>> While running HRI Load All Assignment Events Fact in Daily Business
> >>>>> Intelligance Administrator i am Facing following error . On other
> hand
> >>>>> my all other requests working fine , utl_file_dir is properly setup.
> >>>>>
> >>>>> Human Resources Intelligence: Version : 11.5.0
> >>>>>
> >>>>> Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
> >>>>>
> >>>>> HRI_ASGN_EVENTS module: HRI Load All Assignment Events Fact
> >>>>>
> >>>>>
> >>>>>
> +---------------------------------------------------------------------------+
> >>>>>
> >>>>> Current system time is 10-MAY-2010 11:09:25
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> +---------------------------------------------------------------------------+
> >>>>>
> >>>>> **Starts**10-MAY-2010 11:09:25
> >>>>> **Ends**10-MAY-2010 11:10:30
> >>>>> SUCCESS
> >>>>>
> >>>>>
> >>>>>
> +---------------------------------------------------------------------------+
> >>>>> Start of log messages from FND_FILE
> >>>>>
> >>>>>
> >>>>>
> +---------------------------------------------------------------------------+
> >>>>> WARNING: Error processing assignment_id 1551
> >>>>> ORA-20100: File l1380173.tmp creation for FND_FILE failed.
> >>>>> You will find more information on the cause of the error in request
> log.
> >>>>> In log_process_info
> >>>>> Exiting log_process_info
> >>>>> Error at step
> >>>>> ORA-20100: File l1380173.tmp creation for FND_FILE failed.
> >>>>> You will find more information on the cause of the error in request
> log.
> >>>>> Error raised by the process, marking the ranges as error
> >>>>> Inside set_range_error
> >>>>> 551 range records marked as Error
> >>>>> exiting set_range_error
> >>>>> error in process_range =ORA-20100: File l1380173.tmp creation for
> >>>>> FND_FILE failed.
> >>>>> You will find more information on the cause of the error in request
> log.
> >>>>> SQLCODE = -20100
> >>>>> Inside watch_child_processes
> >>>>> 3 threads to watch for
> >>>>> Exiting watch_child_processes
> >>>>> A problem was encountered in this child process. See below for
> further
> >>>>> details.
> >>>>> In log_process_info
> >>>>> Exiting log_process_info
> >>>>> In log_process_end
> >>>>> In get_mthd_action_id
> >>>>> Exiting log_process_end
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
> >
> > --
> > Yury
> > Oracle Certified Master
> > Mobile number: +61 414252591
> > ============================================
> > http://otn.oracle.com/ocm/jvelikanovs_0.html
> >
> >
>
>
Other related posts:
