Improve this answer. This helped me to look for the list. If you encounter this situation, check the file path to see whether there are any other files located in. Save Article. Not the answer you’re looking for? It is having the flexibility to write some Oracle specifics code.
 
 

How to Install and Configure SQL*Plus Instant Client on Windows – Oratable

Sqlplus is an interface provided by Oracle database to interact only with Oracle Database. It is having the flexibility to write some Oracle specifics code. Sqlplus is a tool created by Oracle for its Oracle DB. It is a very popular tool since it comes. It has its own syntax in addition to supporting SQL. Hence, it is called Sqlplus. Step 1: First browse to this link. Step 3: Then on the next page you will find the Start Download button. There you have to click. Step 4: Then in the downloaded zip file there will be a setup.

You have to remember the password for future references. Step After installation, you will find oraclexe folder in the C drive. Step You have to enter that folder.

Then bin folder there you will find sqlplus exe file. So, your installation is successfully completed. Writing code in comment? Please use ide. Skip to content. Change Language. Related Articles. How to install Jupyter Notebook on Windows? How to setup Anaconda path to environment variable? How to filter object array based on attributes? How to Install Anaconda on Windows? How to Install Selenium in Python? How to Install php-curl in Ubuntu? How to Recover a Deleted File in Linux?

How to Install FFmpeg on Windows? How to Connect Two Monitors? How to check Active Network Connections in Windows? View Discussion. Improve Article. Save Article. Like Article. Last Updated : 09 Nov, Previous How to Install Angularjs on Linux? Recommended Articles. Article Contributed By :. Easy Normal Medium Hard Expert. Load Comments. What’s New. We use cookies to ensure you have the best browsing experience on our website. Start Your Coding Journey Now!

Login Register.

Sqlplus for windows 10 64 bit.How to Install SQLplus on Windows?

 
Request Pricing. If you still can’t find the file you need, you can leave a “message” on the webpage. This is a message for seeking help when you choose this option, please fill in your Email correctly, and we will reply to you as soon as possible. Save Article.

How to Install and Configure SQL*Plus Instant Client on Windows – Oratable

SQLplus is a command line utility to manage Oracle Database. It is a powerful tool that all Oracle database administrator must have. The new version of sqlplus Once the connection is made between the client and the server using sqlplus, we can perform many database administration, query, user management and so on. Before we can install and run the sqlplus utility, we need to configure the Oracle Instant Client Utility first.

From the previous step, you should have a zip file called : instantclient-sqlplus-windows. Now extract the file to your instant client directory you created on the Step 1. 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 manjaro pdb1 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. Like this: Like Loading Leave a Reply Cancel reply. Loading Comments Email Required Name Required Website.