OraFAQ Forum: Marketplace » McTnsping: a tnsping-like program for Windows

Home » Other » Marketplace » McTnsping: a tnsping-like program for Windows (Oracle: all versions, OS: MS/Windows all versions)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

McTnsping: a tnsping-like program for Windows [message #648221]

Thu, 18 February 2016 12:02

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I have posted a tnsping-like program in our tnsping wiki page.
This is a Windows stand-alone program which requires no Oracle client.
Note that this program currently accepts only tnsnames.ora or easy connect strings; ldap is currently not supported.
The help is the following one:

C:\>McTnsping -h

McTnsping Utility by Michel Cadot: Version 2021.12.03 on 03-DÉC.-2021 18:08:02

Copyright (c) Michel Cadot, 2016-2021. All rights reserved.

Usage 1: McTnsping.exe { <tns entry> | <host>:<port> } [<count>]

with
  <tns entry>    Gives the net service name in the tnsnames.ora file.
  <host>:<port>  Give the server name or IP and port (which is mandatory).
  <count>        Sets the number of times the program checks the target, default is 1.

Usage 2: McTnsping.exe
        { -h |
          { -s <host>[:<port>] | -t <tns entry> }
          [-v { 8 | 9 | 10 | 11 | 12 | 12.2 | 18 | 19 | 21 }]
          [-dir <tnsnames.ora directory>]
          [-tim <timeout>] [-c <count>]
          [-rc { 0 | 1 | OR | AND }]
        }

with
  -c <count>             Sets the number of times the program checks the target,
                           default is 1.
  -dir <directory>       Gives the directory for sqlnet.ora and tnsnames.ora files;
                           this option is ignored if "-s" option is given.
  -h                     Displays the version and the usage help.
  -s <host>[:<port>]     Gives the server name or IP and port to check the listener,
                           default port is 1521.
  -rc { 0 | 1 | OR | AND }
                         Gives how McTnsping return code would be in case of multiple
                           addresses in the tnsnames entry, default value is AND=1.
  -t <tns entry>         Gives the net service name in the tnsnames.ora file.
  -tim <timeout>         Gives the timeout (in seconds) on connection to listener,
                           default is 5 seconds.
  -v { 8 | 9 | 10 | 11 | 12 | 12.2 | 18 | 19 | 21 }
                         Selects the version of the simulated tnsping, default is 11.

"-s" and "-t" options are exclusive.

If "-t" is choosen, the program searches for sqlnet.ora and tnsnames.ora files:
* if "-dir" option is given, in this directory.
* otherwise, first in TNS_ADMIN directory if set, then in ORACLE_HOME/network/admin.
Note: a program restriction is that a tnsnames.ora entry must be at the beginning of
a line (maybe preceded by spaces).

When there is only one address in the tnsnames.ora entry, McTnsping return code is 0
if the ping was successful and 1 otherwise.
If there are multiple addresses in the tnsnames.ora entry, McTnsping checks all of
them, "-rc" option tells what can be the return code in cases of some addresses work
and others not. "AND" and "1" mean the return should be 1 in this case, "OR" and "0"
the return code should be 0.
So return code is 1, if at least one address is unsuccessful with option "AND" or "1";
and return code is 0, if at least one address is successful with option "OR" or "0".

The program is provided as it is without any guarantees or warranty. Although the
author has attempted to find and correct any bugs in this free program, the author
is not responsible for any damage or losses of any kind caused by the use or misuse
of the program. The author is under no obligation to provide support, service,
corrections, or upgrades to this program.

You can freely use, copy and distribute this program but you can't modify it without
the permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/200058/
I encourage you to subscribe to this topic (link at top of the page) if you want to
be informed when a new version is released.

Here's an example of its usage compared to the same tnsping output (I have cut the end of entry description lines):

C:\>tnsping mikb 3

TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 18-FÉVR.-2016 19:57:44

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
E:\oracle\ora102\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ...
OK (30 msec)
OK (30 msec)
OK (50 msec)

C:\>McTnsping mikb 3

McTnsping Utility by Michel Cadot: Version 2016.02.21 on 21-FÉVR.-2016 21:23:04

Copyright (c) Michel Cadot, 2016. All rights reserved.

Used parameter files:
E:\oracle\ora102\network\admin\sqlnet.ora
E:\oracle\ora102\network\admin\tnsnames.ora

Found tnsnames.ora entry:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=...

Attempting to contact myserver:1530
OK (41 msec) -- listener version 10.2.0.4.0
OK (21 msec) -- listener version 10.2.0.4.0
OK (21 msec) -- listener version 10.2.0.4.0

Note: a small difference with Oracle tnsping is that if the tnsnames.ora entry contains several ADDRESS parts, McTnsping reports the result of all addresses and not only the first one which works.
So if you want to test all your listeners in a single command you can reference all of them in a single tnsnames.ora entry like the following one (it does not even need the tnsnames.ora entry to be complete, it only have to contain the IP/hostname and the port number):

ALL_LISTENERS = 
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1528))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1529))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1530))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1531))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1531))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1531))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1532))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1533))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1538))
      )
    )
  )

Then:

C:\>McTnsping -dir c: -t all_listeners

McTnsping Utility by Michel Cadot: Version 2018.11.27 on 27-NOV.-2018 18:15:04

Copyright (c) Michel Cadot, 2016-2018. All rights reserved.

Used parameter files:
c:\tnsnames.ora

Found tnsnames.ora entry:
(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.7)(PORT=1528))(A
DDRESS=(PROTOCOL=TCP)(HOST=192.168.1.7)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.7)(PORT=15
30))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.7)(PORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.9)(P
ORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.3)(PORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.
1.3)(PORT=1532))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.3)(PORT=1533))(ADDRESS=(PROTOCOL=TCP)(HOST=19
2.168.1.3)(PORT=1538)))))

Attempting to contact 192.168.1.7:1528
OK (23 msec) -- listener version 8.1.7.4.0
Attempting to contact 192.168.1.7:1529
OK (17 msec) -- listener version 9.2.0.8.0
Attempting to contact 192.168.1.7:1530
OK (12 msec)
Attempting to contact 192.168.1.7:1531
OK (12 msec)
Attempting to contact 192.168.1.9:1531
TNS-12541: TNS:no listener
Attempting to contact 192.168.1.3:1531
OK (531 msec)
Attempting to contact 192.168.1.3:1532
OK (8 msec)
Attempting to contact 192.168.1.3:1533
OK (19 msec)
Attempting to contact 192.168.1.3:1538
OK (7 msec)

Latest version: 2021.12.10, download in tnsping wiki page

MD5:   5c86b59d4236eb8086095a09747e1eb5
SHA-1: 5a8cfc4425704408bd73e937528a17333881cb0c

[Updated on: Fri, 03 December 2021 11:20]