How To Install Sqlplus On Windows 10

GUI tools like TOAD and SQL Developer are all fine, but those who have cutting their teeth on SQL*Plus will not exercise without good old command-line interface. And so, a message like the i below makes one want to fix things right immediately…

Here's a step-by-step guide for doing away with this error, past installing SQL*Plus Instant Customer on Windows.

First things first: What is SQL*Plus Instant Customer?

From the Oracle documentation:

SQL*Plus Instant Client is a standalone production with all the functionality of SQL*Plus control-line. Information technology connects to existing remote Oracle databases, but does not include its ain database. It is like shooting fish in a barrel to install and uses significantly less disk space than the full Oracle Database Client installation required to use SQL*Plus command-line.

If all yous desire is a unproblematic command-line interface to connect to remote Oracle databases, Instant Customer meets your purpose well.

On to the installation…

1. Download the installers from OTN: Bones OCI + SQL*Plus

SQL*Plus Instant Client packet needs OCI Instant Client as a pre-requisite. For things to work, the ii must be (i) of the same version, and (two) installed in the same directory.

To download:

Go to OTN's Instant Client Downloads for MS Windows.

Accept the license agreement.

Cull the packages you want to install — in this case:

• Basic Calorie-free Package – Smaller version of the Basic OCI package, with just English error messages
• SQL*Plus Package – The SQL*Plus command line tool for SQL and PL/SQL queries

Versions used: SQL*Plus 12.2.0.1.0, for a Windows 64-bit environs.

Click on the hyperlinks to outset download — this will download the Nothing files to your local auto.

2. Extract the downloads

Extract both the ZIPs to the same local folder, say D:\Tools\sqlplus. A new subfolder (instantclient_12_2 in this example) volition go created.

iii. Edit the PATH variable to include the SQL*Plus Instant Client directory

Add the directory containing the Instant Client files to the PATH environment variable. Brand sure this improver does not take a conflict with another existing Oracle path — if it does, either remove the existing value or movement the new value to the front of the PATH variable.

Nosotros at present have the SQL*Plus Instant Client ready to connect to remote databases.

4. Connect to a Database with SQL*Plus Instant Client via Oracle Net connexion identifier

To connect to a database, first open a command prompt window.

Enter the Easy Connection identifier to connect to the database. For example, the Piece of cake Connection identifier for the 60 minutes schema in an XE database, running on host sales-server, port 1521 is:

sqlplus hr/your_password@\"//sales-server:1521/XE\"

Once entered, SQL*Plus Instant Client will establish the database connection and you volition see the SQL prompt.

You can now run your SQL commands through SQL*Plus Instant Customer's easy command-line interface.

Other than Easy Connection identifiers, Net Service Names tin can exist used for making database connections via Instant Client. Net Service Names may come up from sources such as LDAP or a tnsnames.ora file. For more details on connection options, come across the user'southward guide and reference.

Notes:

Remember that the fault in the first screenshot ('sqlplus' is not recognized as an internal or external command) could be because of a misconfigured PATH — see footstep 3. Earlier you lot keep to install SQL*Plus, verify that SQL*Plus is actually absent!

For more on SQL*Plus Instant Customer, run across the Oracle documentation: link. Besides check out the advanced configuration tips in this neat tutorial at williamrobertson.net.

Source: https://www.oratable.com/sqlplus-instant-client-installation/

Posted by: cooksioned69.blogspot.com

Share this post