Re: Network errors: Oracle TNS - Error: Return status 4

Lou,

So, the network guy gets a new tool that tells him something he never knew before and he is trying to push this issue off on you? Wow, give this guy some arbitrary Oracle performance tool and he'll have you fired by the end of the week.

    Tell him that if his stinking network is losing packets then he needs to fix the problem. Last time I checked, lost packets were a network issue, not an application issue. I'm guessing if the network loses a packet and succeeds on a retry, then it never looks like an error to the application. Maybe you could file a TAR and see if you can get a better explanation.

Dennis Williams

On 2/24/06, Lou Avrami <avramil_at_concentric.net> wrote:
>
> Hi all,
>
> I thought I would throw this one out here.
>
> OS: HP-UX 11.11
> RDMBS: 9.2.0.6
> App: JD Edwards
>
> Hello all,
>
> A network engineer in my group has informed me that there is a high packet
> failure rate for the network traffic between the servers of a particular
> application, JD Edwards. Here is an example error message from his tool:
>
> Oracle TNS - Error: Return status 4
>
> I've checked the SQLNET logs on the database server and there doesn't
> appear to be any errors there. The logs on the application servers also
> don't seem to have any Oracle connectivity errors.
>
> Does anyone have any hints as to what should be investigated?
>
> Thanks,
> Lou Avrami
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l