I have recently downloaded latest version of Oracle SQL Developer (, and my idea was that tnsping.exe should go along with it - but this is not the case. Also I was surprised that SQL Developer is provided as archive of files without any kind of installer.
Can somebody advice where to download tnsping.exe?

  • It's part of the client (not instant client) and database installations. In SQL Developer you may test a connection using jdbc (new connection -> <insert parameters> -> test. – Dimitre Radoulov Mar 6 '14 at 10:24
  • @DimitreRadoulov Is the SQL Developer diagnostically equivalent to tnsping? Or would tnsping be more details and/or take a simpler path, etc. - perhaps bypassing an incorrect SQL Developer configuration? – qxotk Feb 21 '15 at 4:52
  • 2
    @jmsmcfrlnd, a successful tnsping indicates only that the listener is running. A successful jdbc connection test using username, password and service name indicates that the Oracle instance offering the service is accessible and accepts connections - i.e. pretty much all you need to know when testing a connection to a database. – Dimitre Radoulov Feb 22 '15 at 11:20

Just install the Oracle client, the tnsping.exe tool comes with it ! it should be in the bin folder.

| improve this answer | |
  • 3
    I've read elsewhere that the "instant" client does not install it. Is that true? Here's one example: jasonvogel.blogspot.com/2007/10/… – qxotk Feb 21 '15 at 4:53
  • It's not in my bin folder. :-( – Jeff Roe Jul 18 '18 at 18:43
  • Yeah, me neither – ds_practicioner Jan 8 '19 at 18:20
  • tnsping and lsnrctl are not in the (SQL Plus) Instant Client, you need a full Client install from the installation media (or get them from an installed sever, which might require more files) – eckes Apr 9 '19 at 8:10
  • 1
    for testing without tnsping, e.g. from instant client, use sql plus: sqlplus %USERNAME%@%DBSERVER% – matt wilkie Nov 6 '19 at 22:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.