ORACLE EBS 并发请求启用TRACE调试

Tracing the Concurrent program is very good option to Debug any issue while running the concurrent program.

Goal :
To enable the Trace for Concurrent Programs
To Debug the issues in Concurrent Programs or its dependent objects.

Solution :
1. Goto Concurrent Program Definition

Application Developer –> Concurrent –> Program –> check Enable Trace

Query your concurrent program and check theEnable Tracecheck Box at the bottom of the screen.


2. Set the ProfileConcurrent: Allow Debuggingto YES.


3. Navigate to the Responsibility from where you are running the program.

4. Before Submitting the Concurrent Program in Submit Request screen there will be an option likeDebug Optionsclick on that button.


5. In the Debug Options select thesql Traceand enableTrace with binds.



6. Submit the Concurrent Program and note down the Request id.

7.Trace file name will always be post fixed withoracle_process_id.Toget the oracle_process_id use the below sql
Select oracle_process_id from fnd_concurrent_requests where request_id= &Request_id;

8.And the Trace file path can be derived using the below sql
Select * from v$parameter where name='user_dump_dest';

9. Get the trace file to your local machine.Understanding the raw trace is very complex so use TKPROF utility to make the Trace file readable.

10. Open the Command Prompt and run the below command
TKPROF < TraceFile_Name.trc> <Output_File_Name.out> SORT=fchela

11.A new outfile will be generated with the name given in the above command.Analyse the Output file to know the answers for your problem.

sql queries to find the log files by Request id
selectreq.oracle_process_id tracename,req.request_idreq.requested_byusr.user_nameprog.user_concurrent_program_namereq.request_datereq.phase_codereq.status_codereq.logfile_namereq.outfile_namedest.valueasuser_dump_destfromapps. fnd_concurrent_requests reqgv$parameter destapps.fnd_concurrent_programs_vl progapps.fnd_user usr
where req. concurrent_program_id=prog.concurrent_program_id
andreq.requested_by=usr.user_id
anddest.name='user_dump_dest'
andrequest_id=&Request_id;

sql query find the log files by username
select req.oracle_process_id tracename req.request_id req.requested_by usr.user_name prog.user_concurrent_program_name req.request_date req.phase_code req.status_code req.logfile_name req.outfile_name dest.value as user_dump_dest
from apps. fnd_concurrent_requests req gv$parameter dest apps.fnd_concurrent_programs_vl prog apps.fnd_user usr
where req. concurrent_program_id = prog.concurrent_program_id
and req.requested_by = usr.user_id
–and request_id like ‘6013239’
and dest.name = ‘user_dump_dest’
and usr.user_name like ‘Ramesh%G%’
order by request_date desc
Select oracle_process_id from fnd_concurrent_requests where request_id = & Request_id ;
select * from apps. fnd_concurrent_requests req gv$parameter dest apps . fnd_concurrent_programs_vl prog where req. concurrent_program_id = prog.concurrent_program_id and request_id like ‘601300%’
and dest.name = ‘user_dump_dest’

相关文章

数据库版本:11.2.0.4 RAC(1)问题现象从EM里面可以看到,在23号早上8:45~8:55时,数据库等待会话暴增...
(一)问题背景最近在对一个大约200万行数据的表查看执行计划时,发现存在异常,理论上应该返回100多万...
(一)删除备份--DELETE命令用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操作时,会在RM...
(1)DRA介绍 数据恢复顾问(Data Recovery Advise)是一个诊断和修复数据库的工具,DRA能够修复数据文...
RMAN(Recovery Manager)是Oracle恢复管理器的简称,是集数据库备份(backup)、修复(restore)和恢复...
(1)备份对象 可以使用RMAN进行的备份对象如下: --整个数据库:备份所有的数据文件和控制文件; --数...