7

I have recently downloaded latest version of Oracle SQL Developer (4.0.0.13), 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?

Improve this question
3
  • 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, 2014 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, 2015 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, 2015 at 11:20

2 Answers 2

Reset to default
4

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

Improve this answer
5
  • 4
    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, 2015 at 4:53
  • It's not in my bin folder. :-(
    – Jeff Roe
    Jul 18, 2018 at 18:43
  • Yeah, me neither
    – ds_practicioner
    Jan 8, 2019 at 18:20
  • 3
    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, 2019 at 8:10
  • 2
    for testing without tnsping, e.g. from instant client, use sql plus: sqlplus %USERNAME%@%DBSERVER%
    – matt wilkie
    Nov 6, 2019 at 22:31
3

You have to download the Database Client. Please note that this is not the same package as the Instant Client.

  1. Go to the Oracle DB download page
  2. Click on "See all" on the right column, next to the version and platform of your choice.
  3. Scroll down to the "Client" section.
  4. You'll have to choose between the Client home, or Client package. The former only allows an "Administrator" installation type, while the latter lets you choose. More details here. But please note that you'll have to run the installer either way: you can't run ~/bin/tnsping successfully until you've run the installer.
Improve this answer
2
  • Is there a way to install the tnsping on mac? It doesn't come with the instant client or instant client support tools.
    – Michael
    Oct 5, 2022 at 22:49
  • 1
    I just love the way Oracle names its clients. With that effort they could name all downloadable files on their website as download.zip
    – SandorRacz
    Mar 15 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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