大佬教程收集整理的这篇文章主要介绍了Oracle EBS Forms查看trace file,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
Introduction:
Some times we need to diagnose the issue or error coming in forms. For such situation we need to get more information about the issue we are facing in forms. One of the best way to get such information is using tracing.
@H_356_6@many types of tracing are available in forms. We will discuss couple of methods for enabling the tracing and see how that can Help us in diagnosing the issue.Enabling sql Tracing
First we see how to enable a normal sql tracing. In my case I have a forms where I am entering few values and then saving the form. This will have some insert and updates command in the BACkend which will get executed when we save the form. sql tracing is used to track those DML querIEs to deBUG the issue. When we open the form we can see on the menu option
Help -> Diagnostic -> Trace ->
Here we have many options available (default is ‘No Trace’). We can enable tracing by SELEcing on of the options from here. ‘Regular Trace’ gives the least information and ‘Trace with Binds and Waits’ (level 12) gives maximum information. Be careful while enabling sql trace with wait and binds as this will make the trace file huge.
Also we can start the tracing in the mIDdle of forms sessions also. Example in my case I wanted to check the last insert/update DML statements that gets fired when we save the form. So after we fill all the values in the fIElds,we can start the tracing so that the initial SELEct statement does not come in trace file.
When we enable the trace it will give the trace file LOCATIOn (This LOCATIOn will be the LOCATIOn of user_DUMP_DESTinATION parameter of databasE).
After you save the form you can stop tracing by SELEcTing ‘No Trace’ again from Help -> Diagnostic -> Trace -> No Trace
Use tkprof to covert trace file in readable format.
-bash-2.05b$tkprof@H_484_3@md9ys210_ora_20412_MFG.trc
output =trace_sql.txt
TKPROF: Release 10.2.0.4.0 – Production on Mon Jul 28 23:54:31 2008
copyright (C) 1982,2007,Oracle. All rights reserved.
-bash-2.05b$
Enabling Forms Tracing
Another way for deBUGging is to enable tracing at forms level for a particular user. This method is also explained in Metalink note ID 373548.1. By default,it will trace errors only. To utilize the full flexibility of Forms Trace,therecord=formsparameter must be used in conjunction with thetracegroupparameter.
Applications Development has created several recommended levels of tracing,which are predefined in the file$ORA_CONfig_HOME/10.1.2/forms/server/ftrace.cfg
In my case I am enabling the tracing for sqls.
Please follow below steps to enable form level tracing.
record=forms tracegroup=medium
Before doing this,Metalink note ID also mention to append “record=forms” at the end ofICX: Forms Launcherprofile for that user. Example
http://rws60048remS.Us.Oracle.com:8058/forms/frmservlet?record=forms
But when I trIEd that I got following error.
FRM-90926: Duplicate Parameter on command line.
So I removedrecord=formsand I was able to generate the trace files without any issue. This may be some issue with my instance.
Once you set the profile “Forms Runtime Parameters”,bounce the forms and try to acceCSS forms,it will generate a trace file at the LOCATIOn defined by FORMS_TRACE_DIR. After you finish the navigation in form and exit,your trace file will get created FORMS_TRACE_DIR LOCATIOn.
This file will be in binary format and cAnnot be read. You need to convert this into .txt or .HTML format using following command
java -cp $OracLE_HOME/forms/java/frmxlate.jarOracle.forms.diagnostics.XlateDATAFILE=forms_8842.trc outputfile=forms_trace1.HTML outputclass=WriteOutHTML
Here,
DATAFILE=forms_8842.trcis the name of trace file that got created due to activitIEs on forms.
outputfile=forms_trace1.HTMLis the name of output file that will get created. You can use HTML or .txt
outputclass=WriteOutHTMLparameter decIDes if the output file should be HTML or TXT. If you use justWriteOutthen output file will be TXT. If you useWriteOutHTMLthen output file will be HTMl.
The output HTML file will look like this.
Hope this Helps !!
References:
@H_356_6@metalink note ID373548.1以上是大佬教程为你收集整理的Oracle EBS Forms查看trace file全部内容,希望文章能够帮你解决Oracle EBS Forms查看trace file所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。