How to enable tnsping in windows 10?

This assumes there's already an Instant Client or similar installed on the destination machine; and that the oracle path and registry keys are set.

(1) Copy tnsping.exe from the source to the destination machine, into client_1\bin.

(2) Copy the following files from client_1\bin to client_1\bin:

This should be about 84.6 MB.

(3) In the client_1 on the destination machine, make a backup of the following files:

Now on the source machine, find those files in client_1\bin and copy them to client_1\ (no bin) on the destination machine, overwriting the existing files. (Note: oci.dll is ~330 kb smaller, orasql12.dll is ~300 kb smaller. I'm not sure what's lost, hence the backup).

(4) On the destination machine, create the directory mesg in client_1\Network. Now copy the following file from the source to the destination:

(5) Open up regedit. Create the following key:

(From another machine, it looks like the x64 version is named HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient12Home1, but the tnsping program I'm using says it's 64 bit, so ...)

Under the key, create a string named ORACLE_HOME with the value C:\Oracle\product\12.1.0\client_1.

You should be done now ($$$ = redacted):

Here's the process I followed, sharing for when these steps invariably fail to work on a later version.

First off, I just copied the tnsping.exe over.

I didn't haphazardly pick the above dlls, as far as I can tell everyone is required. I ran the exe, and it would popup an error, I would copy the dll over and try again:

After a few dlls, you'll run into a different kind of error:

If that happens, fire up process monitor and put a filter in for the ProcessName to contain tnsping and try to run the program again. You should see something like the following. The main thing to notice is that it tries to load (in this example) orawsec12.dll, which succeeds, but then it continues to try to load the dll looking in different paths, and then at the end it triggers werfault and the program ends. I guess it realizes there's some kind of version mismatch and keeps looking for the right version.

Open Command Prompt, type tnsping , then press Enter. If the response to this command is 'tnsping' is not recognized as an internal or external command, operable program or batch file. , then you do not have an Oracle client installed. Any other response indicates an active Oracle client installation on the machine.