soapfaultcode:5 Server was unable to process request Data Base Error: ORA-12154:TNS:could not resolve the connect identifier

[former_member435556]

Hi

I am trying to extract data from another oracle database through Consuming web service by using Client proxy generation approach(Wsdl file), After I generated the  client proxy and going to test run the web service  it giving me the error: soapfaultcode:5 Server was unable to process request Data Base Error: ORA-12154:TNS:could not resolve the connect identifier as I am doing it first so don't have much idea what kind of issue actually it is either my side consuming side or service provider side which actually created this web service and give it to me  to invoke.

Given below is snap shot of error.

<n0:GetData xmlns:n0="http://tempuri.org/">

  <n0:user>us9001</n0:user>

  <n0:pass>******</n0:pass>

  <n0:fromdate>31/12/2010</n0:fromdate>

  <n0:todate>31/12/2015</n0:todate>

</n0:GetData>

In result it give this error:-

[JamesZ]

Hi Raima,

Please refer to SAP note 443867 for the general check.

Best regards,
James

[former_member204746]

provide contents of file tnsnames.ora on your server

also provide the SID of your external Oracle system.