Mahmoud Elsonbati

let say we have s insurance xml data as a response of a web service and we want to expose this data as  a complex structure data type to deal with it in SAP   (the same like DOM parser in other programming languages) the xml data as below <?xml version="1.0" encoding="utf-8"?> <RequestResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">   <Response>     <TreatmentBasis>1</TreatmentBasis>     <TreatmentClassification>1</TreatmentClassification>     <MemberDetails>       <Tag>         <ID>1</ID>         <Label>DOB</Label>         <Value>05-Jun-2011</Value>         <Type>Date</Type>       </Tag>       <Tag>         <ID>2</ID>         <Label>Gender</Label>         <Value>Female</Value>         <Type>Text</Type>  

It was not a firewall or port blockage It was  a trace listener.log file increasing (5 Giga) ( it was located under  C:\app\admin_user_name\diag\tnslsnr\onlinesurvey\listener\trace) i have resolved this issue by 1- stop the listener      lsnrctl stop 2- shutdown db  sqlplus / as sysdba SHUTDOWN IMMEDIATE 3- rename the log    ( it should be listener.log file) 4- start db sqlplus / as sysdba STARTUP 5-start listner      lsnrctl start to stop listener log at all  i used this command lsnrctl set log_status off