Log files in $APPLCSF/$APPLLOG directory

I would like to share some important things here. You all might know these, but Oracle Apps newbie will get benefited. As we know that, when ever any Concurrent Request is submitted, log and output files are stored in $APPLCSF/$APPLOG and $APPLCSF/$APPLOUT directories respectively. Apart from *.req files, some other files are also getting stored in $APPLCSF/$APPLOG directory. I would like to give brief description about these files. These are the following files which are getting stored in that directory.

(a) l<Request ID>.req

This is the Concurrent Request log file. When any concurrent request is submitted, request log file is created in this directory with file name as l<Request ID>.req

(b) Events####.log

adstrtal.sh script writes the log information in to this file, when ever there is any problem with starting of any Application Service.

(c) Error####.log

This file contains the Java Exception Errors.

(d) #####.log

This file keeps the information of starting of Apache Listener.

(e) f60webmx_dump_<PID>

This file is created when ever any Client Forms Session ends abruptly. When user forms session got crash or terminated abruptly that diagnostics information is written into this dump file.  If you want to get rid out of this dump files. Please execute the following stepsSet the FORMS60_CATCHTERM = 0 in Registry (NT) or Environment Variable (Unix/Linux) and bounce the Forms Services

(f) em_<PID>.rti

This file contains Client run time process information. These files are used by Oracle Application Manager and Enterprise Manager for Forms Monitoring Services and are generated by Forms runtime processes. For each f60webmx session, there is one .rti file is created. These files are written to the directory set by parameter $FORMS60_RTI_DIR.  By default these are written into $APPLCSF/$APPLLOG directory. RTI files should be automatically cleaned up when user logs out of the forms session, in case user logs out of the forms sessions abruptly. Then these files are not cleaned up properly. So then you may need to clear these files manually. We can delete the files, but we should not delete these files when users are active

em –> enterprise manager

<PID> –> Process ID of Client

rti –< Run time information In some cases,

we need to delete the FNDCPPUR program log files and output files manually to free up the disk space. Here I am giving UNIX commands to find out and deleting the old files. If your FNDCPPUR program is scheduled to run daily and given AGE Mode value as 7, purge Program has to delete the files which are older than 7 days. But if program did not delete the files, use this command to find out those files.

Find the Concurrent Request Log and Output files which are not deleted

 find $APPLCSF/$APPLLOG -mtime +7 -name “*.req”

find $APPLCSF/$APPLOUT -mtime +7 -name “*.out

Delete the Concurrent Request log and output files which are older than 7 Days

 find $APPLCSF/$APPLLOG -mtime +7 -name “*.req” -exec rm “{}” “;”

find $APPLCSF/$APPLOUT -mtime +7 -name “*.out” -exec rm “{}” “;”

Delete other files in $APPLCSF/$APPLLOG directory

find $APPLCSF/$APPLLOG -mtime +7 -name “*.log” -exec rm “{}” “;”

find $APPLCSF/$APPLLOG -mtime +7 -name “*.mgr” -exec rm “{}” “;”

find $APPLCSF/$APPLLOG -mtime +7 -name “f60webmx*” -exec rm “{}” “;”

find $APPLCSF/$APPLLOG -mtime +7 -name “*.rti” -exec rm “{}” “;”

Reference:

 (1) What Are .RTI and .FLI Files? Doc ID: Note: 470850.1

(2) Oracle Forms in Applications FAQ Doc ID: Note: 177610.1

Did you get a chance to download 6 Docs Every Apps DBA Must Read for EBS R12.2 ? If not, then get it now by clicking on link below.

6 docs every apps dba must read

If you want to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 then have a look at our  Oracle Apps DBA Training .

About the Author Atul Kumar

Leave a Comment:

32 comments
Atul says January 13, 2008

Nice Post Subbu, Hope to see some more posts from you in near future

Reply
SubbaRao says January 14, 2008

Thank you Atul,

Its a great honour to write articles in this site.

Thanks alot.

Regards,
SubbaRao

Reply
arvind says April 17, 2008

I just wanted to know the location for $APPLCSF; what is the default location.

Reply
Atul says April 18, 2008

For R12 its

$INSTALL_BASE/inst/apps/prodr12_r12/logs/appl/conc

For 11i its in $COMMON_TOP/admin or $INSTALL_BASE/comn/admin

Reply
SubbaRao says April 18, 2008

Hi Aravind,

As Atul Said, for the default location you can check in Autoconfig Context File (XML File). XML file will be in $INST_TOP/appl/admin directory.

Default Location for APPLCSF is

$INST_TOP/logs/appl/conc directory. If you want to change it, you can edit your location in XML file and run the autoconfig. now you are done.

Regards,
SubbaRao

Reply
arvind says April 18, 2008

Thanks Atul and Subba for this information.

Reply
arvind says April 18, 2008

Hi,

Can you please tell me step by step procedure for Rapid cloning. One more thing in which scenario we don’t require preclone? What is the purpose of preclone?

Regards,
Arvind

Reply
Amit says April 19, 2008

Hi Arvind,

Preclone basically collect the conf files and templated of source and stores in a Staged Clone directory. This is used when you run adcfgclone.pl on target. Also Step by step procedure for cloning is mentioned in “Back to Basics of Cloning ” Post that is in details of Cloning.

Also there are scenerios where customization of Rapid clone methos is required and we need not run the preclone but that is not supported by Oracle.

Let me know if you have any confusion.

Cheers
Amit

Reply
arvind says April 28, 2008

Hi,

Can some one please tell me how to recover my context file (for both db and apps tier), if removed?
Is adadmin utility will help here?

Regards,
Arvind

Reply
Atul says April 28, 2008

You can recreate them by using adbldxml script (Rebuild XML file)

Reply
cesar santamaria says August 8, 2008

Hi all. I would like to know if deleting the .req files manually(without any purge script) could cause the apps to behave erratically?

Reply
SubbaRao says August 8, 2008

Hi,

You can delete the requests files manually. But always recommended is to use the “Purge Concurrent Requests/Manager Data” to delete the concurrent requests information from tables and operating system.

Hope it helps,

Regards,
Subbarao

Reply
Mike says December 31, 2008

Thanks for the post .It was a great place to start and very encouraging too .
There are a few changes to the contents of the original post

***.log is not an apache log file .It actually logs information about middle tier servers and services during and recycle.This information was culled by reading the contents of the log file.

Events####.log is related to the logging in the fulfillment server not adstrtal.sh.
ML 601375.1 .
Again thanks for your help

Mike

Reply
laksha says February 6, 2009

In my $APPLCSF/$APPLOUT directory there are many files with ctl and dat extension of the format
M9681817MRLD_PURCH_SUPPLY.dat
M6406405MRLD_BOM.dat
M5675807MRLD_WIP_COMPONENTS.dat
M4473523MRLD_AGG_RATES.dat
etc
and
M939023MRLD_PURCH_SUPPLY.ctl
M6519603MRLD_BOM.ctl
etc.
what are these files and it it safe to delete these files?
I have scheduled “Purge Concurrent Request and/or Manager Data” on daily basis but this does not delete the ctl and dat files.

Reply
SubbaRao says February 6, 2009

Hi Laksha,

I am not sure about those.

the following metalink notes might be helpful

Why are .dat .ctl Temp Files being Created by the Memory Based Planner? Doc ID: 152056.1

MRP MPS ASCP .DAT and .CTL Files Left Over From Memory Based Planner Doc ID: 112851.1

Memory Based Planner FAQ Doc ID: 111691.1

Regards,
SubbaRao

Reply
Ash says July 29, 2009

where does adworker log files are stored

Reply
SubbaRao says July 29, 2009

Hi Ash,

for adworker log files, please check the below location

$APPL_TOP/admin/PROD/log

Note: PROD is the Database Instance Name. Substitue this value according to your Database Instanance Name

and look for adworker*.log files

Hope it helps,

Regards,
SubbaRao

Reply
Abuzaid says December 20, 2009

Dear ALL;
Thanks for the good Article.
I configure concurrent Manager for “Purge ..or .. ” and Age is 50 days..and ALL.
but I find 70GB files from 2007,2008 still exists, ..
please advise.
Thanks

Reply
Avu says September 28, 2010

Hi,

I just want to know the effect on performance of deleting Concurrent logs from the Production server, Secondly I tried the “Purge Concurrent Requests/Manager Data” on a Test server but it took a very long time to finish, why this and what is the effect on performance? Lastly how often should this be done?

Reply
Atul Kumar says September 29, 2010

@ Avu,
Yes, purging Concurrent Requests/Manager Data will improve performance specially around view output and logs for concurrent request.

Frequency : depeneds on number of concurrent request you generate . On an average scheduling this every 2 weeks is good enough .

Why Purge was slow on test server ? : Well this depends on number of factors like
a) Number of concurrent request eligible to be purged
b) size of server
c) load on server
d) Any locks/hangs in database

Reply
chandru says February 9, 2011

Hi,

We have migrated the forms application server from forms6i to forms10g and we want to retain the rti files for a specified period of time. There are some rti related parameters like 1. RTI_KEEP_DAYS am not sure where to set this. Kindly help me on this issue.

Reply
Atul Kumar says February 9, 2011

@ chandru,

RTI files are generated by the forms runtime processes.

Set them in to Form Server Configuration Files at
$ORA_CONFIG_HOME/10.1.2/forms/server/default.env

This file is replacement of formservlet.ini in 11i

Reply
wajid iqbal says June 23, 2011

hy atul bhiya
what a gr8 knowldge u have, i m realy gr8 fan of u , whould that u b here kiss ur forehead,
may u live long, love u dear,amoooah,tc

Reply
mrmuds says October 24, 2011

Hi,
Where do the files which we upload from OAF gets stored. For example we upload a .rtf file for xml outputs. where does this rtf file gets stored?

thank you

Reply
anil singh says February 6, 2012

sir,

SPACE ISSUES THEN WE HAVE DELETE $COMMON_TOP/ADMIN/OUT/.OUT FILE .WE HAVE ALL DELETE .OUT FILE NOT BACKUP. THEN THIS TIME NOT OPEN VIEW OUTPUT AND NOTE( OUTPUT FOR REQUEST 175428 (0 BYTES)).

WHAT IS SOLUTION SIR?

Reply
anil singh says February 6, 2012

AND VIEW OUTPUT DESABLE IN CONCURRENT PROGRAM.

Reply
Atul Kumar says February 7, 2012

@ Anil Singh,
You should not directly delete files but use purge concurrent program which should delete tmp/out files and old requests.

If files are deleted restore from backup in order to view output/log

Reply
Mujtaba says September 28, 2015

Dear Atul,

I am very new to EBS and I would like to know about “Purge Concurrent Request”, set parameters are ALL, Age, 7, , , , , , , , , Y, Y. So I understand it will purge data from table and Logs from OS level ($APPLCSF/$APPLLOG and $APPLCSF/$APPLOUT) which is older than 7 days ? However at OS level OLD files still exists .req and .out why ? And can you share query to check howmany days data exists in tables fnd_concurrent_requests or its related tables just to verify.

Reply
sridevi says December 26, 2017

I am getting this error while opening log file

Reply
sridevi says December 26, 2017

I am getting error lin log file “fnd.src.util.aflog.afwkmetricsevent.cant_log_metrics_event”

Reply
Gloria says April 30, 2018

Good evening. Thanks a lot! Great article.

Reply
BALA says September 29, 2018

How to open oracle reports where oracle running on Unix aix ?

Reply
Add Your Reply

Not found