RE: Oracles network logging

Thanks for this input. I like your thoughts particularly on 12518/12564. This system was recently (few months back) upgraded to a new server and now has 18 gbs for pga and sga (we're using memory_target and memory_max_target) whereas the old server only had 3gb in total to work with, IIRC 50mb for pga; they never reported this issue on the old server. Still, perhaps the connections are happening so fast that the memory is still a bottleneck, I'll review.

Thanks,
-joel

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hans Forbrich Sent: Saturday, July 27, 2013 10:56 AM
To: oracle-l_at_freelists.org
Subject: Re: Oracles network logging

There are a number of possible reasons for each.

For the 12535/12170, one place you want to start looking is the DNS performance. Try adding the host name resolution to the {Windows}/system32/driver/etc/hosts file [temporarily] to see whether the problem reduces. OS and TNS trace route & ping are your friends here.

For the 12518/12564, two places you want to look are the connection rate from the application and the memory page rate. (Are you attempting to create new connections very quickly, are you running short on memory, is the PGA starving, while trying to create new threads)

These are not easy to resolve - good luck. /Hans

On 26/07/2013 1:07 PM, Joel Slowik wrote:
> Hello everyone,
> We have a client on an 11.2.0.3 64-bit database on Windows server
> 2008. One of their vendors, using SQLSERVER, is having an intermittent
> issue connecting to the oracle database; their sqlserver program is
> sending a generic timeout expired exception. We've reviewed the sqlnet
> log, alert log, listener.log, and the audit trail for connections for
> this system. While we have found frequent TNS 12535/12170 combinations
> from that server in the alert log and TNS 12518/12564 from the
> enterprise manager agent in the sqlnet log file, all of those errors
> are unrelated to the specific instance that we're trying to track down
> (as a side, we are investigating resolutions to those as well)

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


________________________________
 Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
--
http://www.freelists.org/webpage/oracle-l