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: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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.
It implements easy connect strings, tnsnames.ora or ldap resolution method.
The help is the following one:

C:\>McTnsping -h

McTnsping Utility by Michel Cadot: Version 2023.07.11 on 11-JUIL.-2023 09:53:10

Copyright (c) Michel Cadot, 2016-2023. 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 or ldap server.
  <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 *.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 tns entry, default value is AND=1.
  -t <tns entry>         Gives the net service name.
  -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 *.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).
Note: a program restriction is that it connects to the LDAP server using an
anonymous bind (NAMES.LDAP_AUTHENTICATE_BIND sqlnet.ora parameter is ignored).

When there is only one address in the tns entry, McTnsping return code is 0 if the
ping was successful and 1 otherwise.
If there are multiple addresses in the tns 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 2023.06.29 on 29-JUIN-2023 16:03:43

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

Using ping version 11

Used parameter files:
e:\sqlnet.ora

Used LDAP adapter to resolve the alias:
e:\ldap.ora

Found entry:
(DESCRIPTION=
  (ADDRESS_LIST=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=ILLUVATAR)
      (PORT=1531)))
  (CONNECT_DATA=
    (SERVICE_NAME=MIKB.ILLUVATAR)
    (SERVER=DEDICATED)))

Attempting to contact ILLUVATAR:1531
OK (15 msec)
OK (12 msec)
OK (12 msec)

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 2023.06.29 on 29-JUIN-2023 16:06:51

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

Using ping version 11

Used parameter files:
  No known name methods found in sqlnet.ora; trying TNSNAMES

Used TNSNAMES adapter to resolve the alias:
C:\tnsnames.ora

Found entry:
(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.9)
        (PORT=1532))
      (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)))))
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: 2023.07.11, download in tnsping wiki page

MD5:   defe9f0ed184bc7bf501b85e565a145b
SHA-1: 85eca3e3bb74c4cc32769591b0d4e0aa02e4cf94

[Updated on: Tue, 22 October 2024 09:54]