Chat now with support
Chat with Support

Toad for Oracle 2024 R2 Common Documents - Installation Guide

Overview of Toad for Oracle

Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:

  • Understand your database environment through visual representations
  • Meet deadlines easily through automation and smooth workflows
  • Perform essential development and administration tasks from a single tool
  • Deploy high-quality applications that meet user requirements and perform predictably and reliably in production
  • Validate database code to ensure the best-possible performance and adherence to best-practice standards
  • Manage and share projects, templates, scripts, and more with ease

The Toad for Oracle solutions are built for you, by you. Nearly two decades of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed base of over two million, Toad for Oracle continues to be the "de facto" standard tool for database development and administration.

System Requirements

About these requirements

These are the system requirements for Toad for Oracle. Additional system requirements for the products that are bundled in the Toad Editions are in the Toad for Oracle Editions Release Notes on http://support.quest.com/technical-documentation.

Requirements

Hardware requirements

Requirement

Details

Processor
  • 1 GHz processor - Toad for Oracle 32/64 bit
  • Apple Silicon (M-series processors) - Toad for Oracle on Mac

Memory
  • 1 GB RAM - Toad for Oracle 32 bit
  • 2 GB RAM - Toad for Oracle 64 bit
  • 2 GB RAM - Toad for Oracle on Mac

Note: The memory required may vary based on the following: 

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard disk space
  • 600 MB - Toad for Oracle 32/64 bit
  • 2 GB - Toad for Oracle on Mac

Operating system
  • Windows 10
  • Windows 11
  • Windows Server 2016
  • Windows Server 2019
  • Windows Server 2022
  • macOS 11
  • macOS 12
  • macOS 13
  • macOS 14

Database requirements

Requirement

Details

Database client

An Oracle client is optional.

Connecting to a database without an Oracle client has the following considerations:

  • Features requiring Oracle utilities will be unavailable including, but not limited to: SQL*Plus, Data Pumps, Import/Export Utilities, SQL Loader, TKProf, TNSPing, Wrap.
  • Oracle Net Services configuration files are required for some connection methods, e.g. TNS requires tnsnames.ora and LDAP requires both ldap.ora and sqlnet.ora. These files may be placed in the folder specified by your TNS_ADMIN environment variable or in the same folder as Toad.exe.

The following Oracle clients are supported:

  • Oracle Client or Instant Client 10.2.0.5
  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3
  • Oracle Client or Instant Client 12c Release 1 and 2
  • Oracle Client or Instant Client 18c
  • Oracle Client or Instant Client 19c
  • Oracle Client or Instant Client 21c
  • Oracle Client or Instant Client 23c/23ai

Note: You must use the 32-bit version of Toad with the 32-bit Oracle client, and the 64-bit version of Toad with the 64-bit Oracle client.

Database server

Oracle versions:

  • 10g Release 2
  • 11g Release 1 and 2
  • 12c Release 1 and 2
  • 18c
  • 19c
  • 21c
  • 23c/23ai

Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

Cloud database service

Oracle Database as a Service on Amazon EC2 and Oracle Cloud

Network

  • Internet Protocol Version 6 (IPv6) is being adopted by the US Federal Government and industries around the world. In its most basic format, the new protocol uses 128-bit addresses instead of 32-bit addresses, which are used by the current IPv4 to route packets over the Internet. Toad for Oracle features, such as FTP, access the Internet through third-party vendors that are IPv6 compliant, such as /nSoftware's IP*Works. For access to Web sites by way of the Toad Online window, Toad simply invokes the user-defined or default Web browser.

  • Toad for Oracle Subscription editions require the user to sign in when using the product. This enables the product to verify the user's identity and to check that they are entitled to use the subscription. To complete this entitlement check internet access is required to connect to Quest Software's Licensing Servers.

  • Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Quest Auto Update requires internet access and must be able to reach the cloud service at https://autoupdate.toadworld.com.

Additional requirements

Requirement

Details

Additional Software
  • Microsoft Internet Explorer 6.0 or later (to view video from the Jump list within Toad, and to view the product documentation in HTML format).
  • Microsoft Office 2016 and recent earlier releases are supported for Word and Excel output.
  • Adobe Acrobat Reader 7.0 or later (to view the product documentation in PDF format).
  • Microsoft .NET Framework 4.0 to support the Toad for Oracle Editions Installer.

Virtualization support

Type

Details

Application virtualization

Citrix® XenApp

Desktop virtualization (VDI)

vWorkspace™ 7.0 has been tested.

Server virtualization

Oracle VM 3.1 has been tested.

VMware ESX Server 3.5, 4.0, and 5.5 have been tested.

Note: Toad may work in virtualization environments other than the ones listed.

Windows Privileges

In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.

Operating System

Requirements

Windows non-Server

Windows Server
  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Home directories that you use for your connections

Note: Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Installation requires administrator privileges on all supported operating systems.

Note: Other functionality in Toad may require additional privileges.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating