Re: ORA-20100: File l1380173.tmp creation for FND_FILE failed
- From: abmian1981@xxxxxxxxx
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 11 May 2010 15:46:25 +0300
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:
