Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have recently downloaded latest version of Oracle SQL Developer (, and my idea was that thsping.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?

share|improve this question
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? – condiosluzverde Feb 21 '15 at 4:52
@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.

share|improve this answer
I've read elsewhere that the "instant" client does not install it. Is that true? Here's one example:… – condiosluzverde Feb 21 '15 at 4:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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