Re: Oracles network logging
Date: Fri, 26 Jul 2013 22:10:00 -0400
Message-Id: <D0F5292A-6854-4FCE-8877-838DADA1795D_at_gmail.com>
In my experience one of our downstream extract from Oracle 11g to SQL SERVER, It was reported either job not finishing or time out.
We found SQL Server side connection driver not latest version, which was upgraded.
Network data transfer byte rate was increased.
Records to Commit rate was increased
With all changes on SQL SERVER our extract was fast.
HTH
Karth
On Jul 26, 2013, at 3:26 PM, "Lange, Kevin G" <kevin.lange_at_ppoone.com> wrote:
> Hate to ask the obvious, but have you gone over the documentation on Diagnosing Oracle Net Services provided by Oracle ?
>
> http://docs.oracle.com/cd/B28359_01/network.111/b28316/troublestng.htm
>
> Maybe you might find something there or maybe a setting that might help you put specific info in the logs that will help you diagnose the issue .
>
> Kevin
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel Slowik
> Sent: Friday, July 26, 2013 2:08 PM
> To: 'oracle-l_at_freelists.org'
> Subject: Oracles network logging
>
> 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)
>
> Now, here is our problem, since we cannot find any information in the alert log, sqlnet log, listener.log, or the audit trail pertaining to the exact date and time that this sqlserver tried, but failed, to connect, I'm personally left with two thoughts: 1) SQLservers attempted connection didn't even make it to the oracle database or 2) there is another log out there somewhere that we are not aware of.
>
> I'm asking for your help on #2; are there any other logs that oracle keeps that pertain to connections to the database?
>
> I need to exhaust every possible corner of oracle before I can move on and point to the network and/or firewall.
>
> Thank you for any input you may be able to provide, -joel slowik ________________________________ 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
>
>
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 27 2013 - 04:10:00 CEST