Log files in $APPLCSF/$APPLLOG directory

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

Thank you Atul,

Its a great honour to write articles in this site.

Thanks alot.

Regards,
SubbaRao

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

For R12 its

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

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

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

Thanks Atul and Subba for this information.

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

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

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

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

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

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

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

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.

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

where does adworker log files are stored

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

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

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?

@ 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

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.

@ 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

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

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

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?

AND VIEW OUTPUT DESABLE IN CONCURRENT PROGRAM.

@ 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

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.

I am getting this error while opening log file

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

Good evening. Thanks a lot! Great article.

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