How to install tnsping

The other answer mentions a windows binary, this is an alternative to that answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings. Oracle tnsping is a utility developed by Oracle that emulates the famous ping communications.

It will allow us to test the connection against a database server. This is particularly useful when the clients accessing the database are on other machines, and best of all, it is OS independent. To be able to use it, we must have an Oracle client installed on the system from where we are going to do the connection test.

This is necessary because we will use libraries and configuration files, such as tnsnames. Tnsping is the tool that allows us to check if there is connectivity between any machine and an Oracle Database server.

Helping to diagnose possible problems. The first thing we have to do is to download the utility. To do this we must download an Oracle client. There are several types and versions of clients. Granted, it is not easy to meet all these milestones and meeting all of them is an impossible mission.

But the more of these requirements you meet, the more problems you will avoid. As I said, it is quite simple. The operation of the command is quite simple, from the client requests are launched to the listener, if it manages to reach it, it will return a reply saying if everything has gone well or if there has been a problem. At the network level, a series of packets will be launched, in the data layer, in OSI architecture, against a listener that we will pass to it.

As a descriptive title this is the OSI scheme;. All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. So, to connect, we need to specify the username as [email protected] in the Connect command.

Ok, so now we have a new user setup in the pdb1 database. From the other computer in this case Windows 10 where sqlplus is installed using above steps , open command prompt and execute the following command:. You can check your Oracle database services and instances with the following command. Make sure you execute this command on the database host as oracle user.

Thank you for reading this how to install sqlplus I hope you enjoy it and leave us comments for any queries. Step 2. Step 3. Install the Package From the previous step, you should have a zip file called : instantclient-sqlplus-windows. Here is the screenshot of my instant client folder looks like: Notice that there is sqlplus application in this instant client folder. Now we are ready to go.