Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: interesting tnsping times...

RE: interesting tnsping times...

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 8 Nov 2000 08:17:03 -0500
Message-Id: <10674.121416@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04986.7F56E860
Content-Type: text/plain;

        charset="iso-8859-1"

7.3.4.4. is a really good distro...why change.

firewall can cause latencies...which one are you using?

If it were my nickel, i'd call in the network boys and break out an updated network map...NT has some traceroute-like utilities taken from Unix.

Start there.....you'll find it in one of the hops..

-----Original Message-----
From: John Dailey [mailto:John.Dailey_at_concept-solutions.com] Sent: Tuesday, November 07, 2000 4:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: interesting tnsping times...

Sorry! Firewall, but everything is taking place behind it. No Oracle Names environment. We are on 7.3.4.4. No laughing! There is a very good reason we haven't upgraded.... it's just that management won't tell me.

=)

just can't logically accept the fact that this one lone machine takes 10 times longer to TNSPING the database when the PING times are the same as all the other clients. I even have other NT machines here (and Win95)... all the same except for this one.

-----Original Message-----
Sent: Tuesday, November 07, 2000 3:49 PM To: Multiple recipients of list ORACLE-L

more info, pls.
going through a firewall? ( if so, which one?) oracle names environment?
mts or dedicated ( don't think this matters..but) database version?
-----Original Message-----
Sent: Tuesday, November 07, 2000 2:56 PM To: Multiple recipients of list ORACLE-L

Hey folks, got an interesting problem here... maybe I'm missing something so I need some help:
I have an NT machine that is acting as our reports server/OAS for a web reporting solution. This has performed terribly for us in many environments, but that is beside the point. Anyway, I can ping our server with excellent response times (<10 msec) from this NT machine. The problem is when I tnsping80 the instance, I get HORRIBLE times ( 5100 - 5300 msec). From any other client, I get response times from tnsping80 between 600-760 msec. It is just this one machine that is having the "problem". The tnsnames.ora files on this NT machine and the clients are the same.
Any thoughts, experiences, or suggestions?

John Dailey
Consultant
Concept Solutions, LLC
*Your Business Intelligence Partner*
www.concept-solutions.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dailey
  INET: John.Dailey_at_concept-solutions.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey INET: John.Dailey_at_concept-solutions.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C04986.7F56E860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: interesting tnsping times...</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>7.3.4.4. is a really good distro...why change. = </FONT> </P> <P><FONT SIZE=3D2>firewall can cause latencies...which one are you = </FONT> <BR><FONT SIZE=3D2>using?</FONT> </P> <P><FONT SIZE=3D2>If it were my nickel, i'd call in the network = boys</FONT> <BR><FONT SIZE=3D2>and break out an updated network map...NT has = some</FONT> <BR><FONT SIZE=3D2>traceroute-like utilities taken from Unix. </FONT> </P> <P><FONT SIZE=3D2>Start there.....you'll find it in one of the = hops..</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: John Dailey [<A = HREF=3D"mailto:John.Dailey_at_concept-solutions.com">mailto:John.Dailey_at_con= cept-solutions.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 4:33 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: interesting tnsping times...</FONT> </P> <BR> <P><FONT SIZE=3D2>Sorry!&nbsp; Firewall, but everything is taking place = behind it.&nbsp; No Oracle Names</FONT> <BR><FONT SIZE=3D2>environment.&nbsp; We are on 7.3.4.4.&nbsp;&nbsp; No = laughing!&nbsp; There is a very good reason</FONT> <BR><FONT SIZE=3D2>we haven't upgraded.... it's just that management = won't tell me.</FONT> </P> <P><FONT SIZE=3D2>=3D)</FONT> </P> <P><FONT SIZE=3D2>just can't logically accept the fact that this one = lone machine takes 10</FONT> <BR><FONT SIZE=3D2>times longer to TNSPING the database when the PING = times are the same as all</FONT> <BR><FONT SIZE=3D2>the other clients.&nbsp; I even have other NT = machines here (and Win95)... all</FONT> <BR><FONT SIZE=3D2>the same except for this one.</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 3:49 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=3D2>more info, pls.</FONT> <BR><FONT SIZE=3D2>going through a firewall? ( if so, which = one?)</FONT> <BR><FONT SIZE=3D2>oracle names environment?</FONT> <BR><FONT SIZE=3D2>mts or dedicated ( don't think this = matters..but)</FONT> <BR><FONT SIZE=3D2>database version?</FONT> <BR><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 2:56 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=3D2>Hey folks, got an interesting problem here... maybe = I'm missing something so</FONT> <BR><FONT SIZE=3D2>I need some help:</FONT> <BR><FONT SIZE=3D2>I have an NT machine that is acting as our reports = server/OAS for a web</FONT> <BR><FONT SIZE=3D2>reporting solution.&nbsp;&nbsp; This has performed = terribly for us in many</FONT> <BR><FONT SIZE=3D2>environments, but that is beside the point.</FONT> <BR><FONT SIZE=3D2>Anyway, I can ping our server with excellent = response times (&lt;10 msec) from</FONT> <BR><FONT SIZE=3D2>this NT machine.&nbsp; The problem is when I = tnsping80 the instance, I get</FONT> <BR><FONT SIZE=3D2>HORRIBLE times ( 5100 - 5300 msec).&nbsp;&nbsp; From = any other client, I get response</FONT> <BR><FONT SIZE=3D2>times from tnsping80 between 600-760 msec.&nbsp; It = is just this one machine that</FONT> <BR><FONT SIZE=3D2>is having the &quot;problem&quot;.&nbsp; The = tnsnames.ora files on this NT machine and the</FONT> <BR><FONT SIZE=3D2>clients are the same.</FONT> <BR><FONT SIZE=3D2>Any thoughts, experiences, or suggestions?</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>John Dailey</FONT> <BR><FONT SIZE=3D2>Consultant</FONT> <BR><FONT SIZE=3D2>Concept Solutions, LLC</FONT> <BR><FONT SIZE=3D2>*Your Business Intelligence Partner*</FONT> <BR><FONT SIZE=3D2>www.concept-solutions.com</FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: John Dailey</FONT> <BR><FONT SIZE=3D2>&nbsp; INET: = John.Dailey_at_concept-solutions.com</FONT> <BR><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from).&nbsp; You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: John Dailey</FONT> <BR><FONT SIZE=3D2>&nbsp; INET: = John.Dailey_at_concept-solutions.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT>
Received on Wed Nov 08 2000 - 07:17:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US