How to install toad for oracle 11g


What is TOAD?

TOAD - Tools for Oracle Application Development
TOAD is a set of development tools used for application development, 
database development, or business intelligence and assist developers 
in deploying Oracle-based applications and Web services on the Windows
platform. Developers use the applications for defining business logic, 
creating user interfaces, applications as Web services, and more.

Toad is a application development tool built around an advanced SQL and PL/SQL editor.
 Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions.
 You can create and edit database tables, views, indexes, constraints, and users. 
The Schema Browser and Project Manager provides quick access to database objects.
Toad’s SQL Editor provides an easy and efficient way to write and test scripts and queries, 
and its powerful data grids provide an easy way to view and edit Oracle data.
With Toad you can:
View the Oracle Dictionary
Create, browse, or alter objects
Graphically build, execute, and tune queries
Edit PL/SQL and profile stored procedures
Manage your common DB tasks from one central window
Find and fix database problems with constraints, triggers, extents, indexes,and grants
Create code from shortcuts and templates
Create custom code templates
Control code access and development (with or without a third party version control product) 

using Toad's cooperative source control feature.

Hardware Requirement for Toad.

75 MB disk space required to run Toad
1GM RAM 32bits required, 2 GB for 64-bits recommended.
VGA monitor, 1024x768 resolution, small fonts Mouse pointing device

Software Requirement for Toad.

Client - Windows 2000/XP/2003/Vista/7 (64-bit support for Windows 2003/XP/Vista/7 with 32-bit Oracle Client)
Oracle SQL Net, Net 8 (32-bit only) Net 9, Net 10, Net 11 or Instant Client
Server - Oracle versions 7.3.4; 8.0.6; 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11g


Once you have verified that your system meets the requirements listed above, paying special attention to the need for the 64 bit Oracle client, Toad for Oracle should work in your environment without any issues.

Steps for the installation of toad in a 64 bit environment after the installation of database:

1.     Install Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit).
2.     Install Toad.
3.     Configure TNS

1. Install Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit).

Download and install oracle database 11g release 2 client (11.2.0.1.0) for windows (64) bit. you can download the same from the below mentioned link.

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) 
Downloadwin64_11gR2_client.zip (615,698,264 bytes) (cksum - 2947608743)

  • Extract win64_11gR2_client.zip
  • Run setup.exe
  • following screen will appear.
  • Select Installation type as Administrator and click next
  • Select your desired language and click next.
  • Provide the base location of Oracle product and click next.
  • Wait for the installation
  • This screen will be displayed when the installation is completed.

2.    Toad setup installation steps.

  • Click Toad DBA Suite for Oracle 10.6.1 Commercial.exe
  • Following screen will appear.
  • Click Next.
  • Accept the agreement and click next.
  • Change the location from C:\Program Files (x86)\Quest Software to C:\Quest Software and click next.
  • Select your desired products.
  • Click Install.
  • Installation is completed.
3.     Configure TNS


Configure your newly installed oracle client's TNS.


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...