20150506 Created By BaoXinjian
一、摘要
在开发IREP开发接口时，经常遇到错误，需要监控工作记录和日志文件，Oracle Metalink上提供的解决方案
1. 通过SOA Monitor监控日志工作记录
2. 通过前台设定SOA Log
3. 通过后天设定SOA Log
二、通过SOA Monitor设定监控
1. 查看SOA运行Reqesut的状态
2. 查看Reuest
查看接收的请求SOAP报文
(1). SOA Request Detail
(2). SOAP Request Data Detail
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:cre="http://xmlns.oracle.com/apps/bxj/soaprovider/plsql/oraclebxj_emp_pkg/create_employee/"
xmlns:orac="http://xmlns.oracle.com/apps/bxj/soaprovider/plsql/oraclebxj_emp_pkg/"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header>
<orac:SOAHeader>
<!--Optional:-->
<orac:Responsibility>SYSTEM_ADMINISTRATOR</orac:Responsibility>
<!--Optional:-->
<orac:ResponsibilityAppl>SYSADMIN</orac:ResponsibilityAppl>
<!--Optional:-->
<orac:SecurityGroup>STANDARD</orac:SecurityGroup>
<!--Optional:-->
<orac:NLSLanguage>AMERICAN</orac:NLSLanguage>
</orac:SOAHeader>
</soapenv:Header>
<soapenv:Body>
<cre:InputParameters>
<!--Optional:-->
<cre:P_EMPNO>1</cre:P_EMPNO>
<!--Optional:-->
<cre:P_ENAME>2</cre:P_ENAME>
<!--Optional:-->
<cre:P_JOB>3</cre:P_JOB>
<!--Optional:-->
<cre:P_MGR>4</cre:P_MGR>
<!--Optional:-->
<cre:P_HIREDATE>?</cre:P_HIREDATE>
<!--Optional:-->
<cre:P_SAL>5</cre:P_SAL>
<!--Optional:-->
<cre:P_COMM>6</cre:P_COMM>
<!--Optional:-->
<cre:P_DEPTNO>7</cre:P_DEPTNO>
</cre:InputParameters>
</soapenv:Body>
</soapenv:Envelope>
3. 查看SOA Response
3.1 查看SOA运行的状态
3.2 查看SOA日志的具体错误
三、从前台设定SOA Log
从控制台启动SOA日志
1. 目录 Oracle Applications Manager > Logs
Click Log Setup to open the Java System Property Settings page.
2. 启动SOA Log功能
Click the Site link and enable log for
Midtier Log File Name: Enter the file name that one would like on the middletier, for example, '/tmp/SOALog.log'.
Module=Enter an appropriate module name, for example, 'fnd/soa%'.
四、从后台设定SOALog
1. 修改配置文件，启动SOA Log功能
$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties
SOA_ENABLE_STANDALONE_LOGGING=TRUE
2. 重启adoafmctl服务
$ADMIN_SCRIPTS_HOME/adoafmctl.sh.
SOA specific log would be created at : $INST_TOP/soa/SOALog.log
3. 查看日志
[applvis@paleonode1 scripts]$ cat $INST_TOP/soa/SOALog.log
Wed Aug 19 12:49:01 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.getInterfaceType : Interface Type for Class Id 4664 = CLASS
Wed Aug 19 12:49:02 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.isDerivedEntryAlreadyPresent : Derived Class Id = -1
Wed Aug 19 12:49:03 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.createDerivedEntry : Derived Entry for Class Id 4664 = 4666
Wed Aug 19 12:49:03 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.setGenerateFlag : Generate Flag set for baseClassId = 4664
Wed Aug 19 12:49:03 CST 2015 : oracle.apps.fnd.soa.provider.wsdl.WSDLGenerator.generateServiceWSDL : Service generation complete for classId : 4664
Wed Aug 19 12:49:03 CST 2015 : oracle.apps.fnd.soa.provider.SOAProviderServlet.doGet : Service with Class Id = 4664 generated.
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.SOAProviderServlet.doGet : GetSOAPWSDLURL of Service with Class Id = 4664
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.util.SOAProperties.getSystemProperties : SOA_SERVER_URL = http://paleonode1.sh.paleotek.com:8002
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.util.SOAProperties.getSystemProperties : SOA_SERVER_TEMP_DIRECTORY_LOCATION = /u2/VIS/visappl/inst/apps/PROD_paleonode1/soa/
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.getIRepInfoForClass : Service Name = ORACLEBXJ_EMP_PKG
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.getIRepInfoForClass : Class Type = PLSQL
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.getIRepInfoForClass : Source File Name = oraclebxj_emp_pkg.pls
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.wsdl.WSDLGenerator.getSOAPWSDLURL : WSDL Location = /u2/VIS/visappl/inst/apps/PROD_paleonode1/soa//PLSQL/4664/ORACLEBXJ_EMP_PKG_soap_http.wsdl
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.util.WSDLUtil.getTargetNamespace : TargetNamespace : http://xmlns.oracle.com/apps/bxj/soaprovider/plsql/oraclebxj_emp_pkg/
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.wsdl.WSDLGenerator.getSOAPWSDLURL : Returning URL = http://paleonode1.sh.paleotek.com:8002/webservices/SOAProvider/plsql/oraclebxj_emp_pkg/?wsdl
Wed Aug 19 12:49:04 CST 2015 : oracle.apps.fnd.soa.provider.SOAProviderServlet.doGet : SOAP WSDL URL of service is : http://paleonode1.sh.paleotek.com:8002/webservices/SOAProvider/plsql/oraclebxj_emp_pkg/?wsdl
Wed Aug 19 12:49:38 CST 2015 : oracle.apps.fnd.soa.provider.util.IRepAccess.getClassId : Class Id for irep_name ORACLEBXJ_EMP_PKG = 4664
Wed Aug 19 12:49:38 CST 2015 : oracle.apps.fnd.soa.provider.SOAProviderServlet.getNativeServiceRelatedFile : File Location/u2/VIS/visappl/inst/apps/PROD_paleonode1/soa//PLSQL/4664/ORACLEBXJ_EMP_PKG_soap_http.wsdl
Wed Aug 19 12:49:38 CST 2015 : oracle.apps.fnd.soa.provider.util.FileAccess.readFile : Reading file : /u2/VIS/visappl/inst/apps/PROD_paleonode1/soa//PLSQL/4664/ORACLEBXJ_EMP_PKG_soap_http.wsdl
Wed Aug 19 12:49:38 CST 2015 : oracle.apps.fnd.soa.provider.SOAProviderServlet.getFileFromURL : File Length = 2722
Thanks and Regards
参考：Metalink
技术交流，技术讨论，欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建
