RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Asan si Hannah? At 05:54 AM 12/23/2003 -0800, you wrote: PING doesnt actually use a port number, as it's not TCP/IP based - it's a part of the ICMP protocol.. Mark -Original Message- Ganesh Raja Sent: 23 December 2003 13:40 To: Multiple recipients of list ORACLE-L TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping will use.. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Mercadante, Thomas F Sent: Tuesday, December 23, 2003 20:54 PM To: Multiple recipients of list ORACLE-L ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Possibly due initially to the fact that ping is ICMP and runs very low in the TCP/IP stack that is in the network layer or the third level up from the hardware and TNSPING is application layer which puts it up at the top of the stack or two more layers higher. This alone can contribute to the performance or response time differences. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28/12/2003 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE I agree that this difference might be only because sqlnet is much more fat that ICMP. But anyway, could some overhead be added be because the failover load balancing clauses that require extra work? Also, if listener logs every connection, this might add some extra IO time as well (if writes for log file aren't write buffered). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 23, 2003 3:29 AM I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
I agree that this difference might be only because sqlnet is much more "fat" that ICMP. But anyway, could some overhead be added be because the failover load balancing clauses that require extra work? Also, if listener logs every connection, this might add some extra IO time as well (if writes for log file aren't write buffered). Tanel. - Original Message - From: Murali Vallath To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 23, 2003 3:29 AM Subject: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST= myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE= SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? Do you Yahoo!?Yahoo! Photos - Get your photo on the big screen in Times Square
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping will use.. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Mercadante, Thomas F Sent: Tuesday, December 23, 2003 20:54 PM To: Multiple recipients of list ORACLE-L ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
PING doesnt actually use a port number, as it's not TCP/IP based - it's a part of the ICMP protocol.. Mark -Original Message- Ganesh Raja Sent: 23 December 2003 13:40 To: Multiple recipients of list ORACLE-L TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping will use.. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Mercadante, Thomas F Sent: Tuesday, December 23, 2003 20:54 PM To: Multiple recipients of list ORACLE-L ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Mark is right, Ping uses ICMP Echo_Request and Echo_Response. Since ICMP sit on the Network Layer along with ARP and the IP protocols, it does not need to use any TCP or UDP port number. TCP and UDP protocols need a number to differentiate from the rest of protocols, therefore the expression port number which translates into an OS network service. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Mark Leith Sent: Tuesday, December 23, 2003 8:54 AM To: Multiple recipients of list ORACLE-L PING doesnt actually use a port number, as it's not TCP/IP based - it's a part of the ICMP protocol.. Mark -Original Message- Ganesh Raja Sent: 23 December 2003 13:40 To: Multiple recipients of list ORACLE-L TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping will use.. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Mercadante, Thomas F Sent: Tuesday, December 23, 2003 20:54 PM To: Multiple recipients of list ORACLE-L ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version:
Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Murali Vallath [EMAIL PROTECTED] wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? === more layers in the OSI stack, longer code path. try passing the argument (# of attempts) to tnsping to see if its consistently high, e.g.: D:\Oracle\Ora92\bintnsping mydb 5 TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 22-DEC-20 03 23:03:38 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: D:\Oracle\Ora92\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = badmofo)(PORT = 1551))) (CONNECT_DATA = (SERVICE_NAME = mydb.mydomain.com))) OK (110 msec) OK (30 msec) OK (10 msec) OK (20 msec) OK (10 msec) Pd __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? - Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).