Re: Oracle communication errors

Paul wrote:

> We have many NT servers communicating with our Oracle 8 database (running on
> a SUN platform). The traffic is Net8 traffic, specifically SQL traffic over
> TNS over TCP (I was told).
>
> When we do sniffer traces of converations with our Oracle database server,
> we notice that on a regular basis, our NT servers never get a response from
> the Oracle server for anywhere up to 4 minutes on many occasions. During
> those moments, we notice there are TONS of the following error messages
> coming from the Oracle server (as seen in the sniffer traces):
>
> Basic operation=4
> Error return status
>
> Does anyone know what these errors mean? Does anyone know why the Oracle
> server doesn't respond on a regular basis and how we might look into
> resolving this?
>
> Thanks!

I can't answer the question you asked. But I can ask a question that I think most people in this usenet group would find far more useful if answered.

What is happening on the Oracle server? Any error message? Any queries hanging? What kind of traffic is being routed to the server that Oracle is handling?

We are primarily Oracle DBAs and developers ... net network admins or UNIX SAs.

Daniel A. Morgan Received on Thu Apr 26 2001 - 07:15:08 CEST