RE: Where do i start for troubleshooting this issue
Date: Mon, 17 Aug 2009 07:15:30 +0000 (GMT)
I tried the ping and when the hang was going in tnsping the ping results were normal.
- On Fri, 14/8/09, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Subject: RE: Where do i start for troubleshooting this issue
To: stellr_at_cns.vt.edu, "hrishy" <hrishys_at_yahoo.co.uk>
Date: Friday, 14 August, 2009, 2:36 PM
Take a look at what does and doesn't work. First off, can you ping the host in a reasonable amount of time? If not then a traceroute between the two machines may lead to the problem. Once had a server that sent out a it's traffic for a certain host to the internet. Bad routing table was what it turned out to be.
Senior Oracle DBA
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ray Stell Sent: Friday, August 14, 2009 9:31 AM
Subject: Re: Where do i start for troubleshooting this issue
On Fri, Aug 14, 2009 at 06:40:26AM +0000, hrishy wrote:
> When i do a tnsping to the service name in a shell script the listener
responds in like 3500 secs ocassionally.
> Where do i start troubleshooting this issue ?
If it were me I'd use tcpdump first to see what the differential on the
looked like. tcpdump is unintrusive and that is why I would start there.