Toad Installation Guide

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 4

Toad Installation Guide

Toad setup and installation guide


1. Run the installer as as administrator and follow through the installation:

2. You will be prompted to enter the license key. Key is included in the installer, open the file and
copy the Key and Site message and proceed to the next step.

3. Leave the default configuration and finish the installation.

4. Visit Oracle.com and search for "instant client" or click here. Download the instant client for
Windows. If you're going to be using a 64-bit version of Toad for Oracle, then you should download
and install the 64-bit version of the Instant Client. If you need a 32-bit client, then download that and
install 32-bit version of Toad for Oracle.

5. The latest version is 19.6.0 and basic


light package has all you need to
connect to a database and run some queries in about a 40 megabyte zip file.
6. Extract the contents of the zip file to a folder, such as C:\instantclient_19_6

7. Go into Windows Start Menu or Windows Settings and search for “Environment Variables.”

8. Once you get to the Environment Variables, the top half of the window are variable settings just for
your Windows account and the bottom half is for everyone who uses this computer, which you may
or may not have access to change. We’ll focus on the top half user variables.

In the user variables, select “Path” then click on Edit.


9. Click on New, and create an entry with the directory where you extract the zip file from step 1. In
my case that directory was C:\instantclient_19_6. Then move the entry to the top of the list by
clicking on “Move Up”. This makes it easy for Toad to find if you have a lot of entries. It should look
something like the following screenshot:

Click OK and OK again.


10. Now you can launch Toad for Oracle. It should pick up your Oracle Instant Client if that's the only
client you have. Enter your User / Schema, Password, then select the Direct tab and enter in Host,
Port, and Service Name or SID. You should get this information from your IT.
11. That should be all you need to connect most of the time. Of course, you may have extra security,
firewalls, and settings like languages that you may have to set up. Run select * from dual as a test:

You might also like