Tnsping on windows

You need Oracle installed on your system, and you need the Oracle programs in your search path. Where can I find the command tnsping in Linux? Why is tnsping not working command not recognised? Why is tnsping. Post navigation « Previous. How do I enable Tnsping? How do I install Tnsping utility? Where is Tnsping EXE? Why is Tnsping not working? Here is the screenshot of my instant client folder looks like:. In the following example, I will show you how to connect to remote oracle database via sqlplus command.

Before we connect, we need to configure the user in the Oracle database. Skip the user creating step if you already have a database user that can connect to the pluggable database. In the database server host, we need to connect to the database using sqlplus in order to create a new user for the pluggable database. In this case, my container database called cdb1 and the pluggable database is called pdb1.

As you can see now we are connected to the root database. We need to switch to the pluggable database pdb1. As you can see, now we are connected to PDB1, the pluggable database. Next, we need to open the database so we can create a new user for it. You can also add multiple roles to the new users. For example:. Please note that this new user only exist in the pluggable database. 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:. Verify that both are correct, then try again. Summary How do I test Oracle connectivity? To use it: Click Start, select Programs, and then select the Oracle program folder the name for this folder may vary. Click the Connect button. The Select Data Source window appears. Need more help?

Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback?