How to install Toad DBA Suite for Oracle on Windows 7 64bit

Jephe Wu - http://linuxtechres.blogspot.com

Objective: install Toad DBA Suite 11.5.1.2 trial version on Windows 8 64bit
Environment: Windows 7 enterprise edition 64bit, 8G RAM


Steps:

1. Install Toad DBA Suite for Oracle with default options, without Oracle instant client.

2. download Oracle instant client for Windows 32bit
install 32bit client only, even you are using Windows 7 64bit according to

http://www.quest.com/Quest_Site_Assets/Documents/ToadforOracle_115_DBA_Suite_Installation_Guide
pdf at page 6 as follows:

Windows 7 (32-bit and 64-bit)
Note: When running on a 64-bit operating system, you must use the 32-bit Oracle Client.

or
you can install Oracle client for Windows instead of using instant client at
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html


3. install instant client and configure Windows PATH and variables
download instantclient-basic-nt-11.2.0.zip then unzip to c:\instantclient_11_2, the most important file is oci.dll

right client 'my computer', to add the following in the front of the PATH environment variables:

c:\instantclient_11_2

Also add an additional variable as follows:
variable name: NLS_LANG
vriable value: AMERICAN.AMERICA.IW8ISO8859P8


3. Configuring Toad DBA Suite for Oracle for database connection.

refer to http://www.quest.com/tv/All-Videos/1044396072001/Toad-for-Oracle---Using-Oracle-Instant-Client/Video/

choose the newly installed instant client as connect using:, use 'direct' tab to configure database host, port and service name, type in user and password, connect.

4. References:
http://yahawana.wordpress.com/2012/02/12/step-by-step-install-toad-for-oracle-on-a-windows-7-64-bits-oci-error/