Quest-TOAD FOR ORACLE

Owned by Phatchakorn Sirabenjaphakorn
Last updated: May 22, 2020
5 min read

1. System Requirements

1.1 Supported Platforms

  • Operating Systems
    - Windows Vista (32-bit and 64-bit)
    - Windows 7 (32-bit and 64-bit)
    - Windows 8 and 8.1 (32-bit and 64-bit)
    - Windows 10
    - Windows Server 2008 (32-bit and 64-bit) - 2 CPU require
    - Windows Server 2008 R2 (64-bit) - 2 CPU required
    - Windows Server 2012 (32-bit and 64-bit) - 2 CPU required
    - Windows Server 2012 R1 and R2 (64-bit) - 2 CPU required

  • Hardware Require (Minimum)
    - 1 GHz processor
    - Memory
    a) 32-bit: 1 GB RAM
    b) 64-bit: 2 GB RAM

The memory required may vary based on the following: - Applications that are running on your system when using Toad - Size and complexity of the database - Amount of database activity - Number of concurrent users accessing the database

- Hard disk space
a) 120 MB - Toad for Oracle 32 bit
b) 150 MB - Toad for Oracle 64 bit

  • Firewall Requirement
    - Windows Server

    a) Port 135 (WMI) to Destination and WMI Random port 49152 - 65535 to Spotlight Client
    b) Spotlight requires the network setting “File and Print Sharing” to be enable
    - Database Monitor

    a) Database Port

  • Microsoft .NET Framework 4.0 to support the Toad for Oracle Editions Installer.

  • Cloud database service : Oracle Database as a Service on Amazon EC2 and Oracle Cloud

  • 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.

  • Browser Support : 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).

  • Windows Privileges Requirements :

    In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.
    - Windows 7, Windows 8 and later, Windows Server 2012 and 2016
    a) Read access to the Oracle client folder
    b) Read/write privileges on the Oracle Home directories that you use for your connections

  • Adobe Acrobat Reader 7.0 or later (to view the product documentation in PDF format).

1.2 Database requirements

Requirement Details :

  • Database Client : An Oracle client must be installed and configured on the system where you are running Toad. The following 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

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
    Exadata:
    Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

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.

2. Installation

Install TOAD for ORACLE and Add License Key

There are several ways to find the installers :

  1. Finding Installers : Download product from the Website or Log in Support Portal

  2. Run the installer Click run as Administrator , Click Next

  3. Click accept the license agreement , Click Next

  4. Add the License Key and Site Message, Click Next

5. Product Selection Step : Select the Quest Software product to install, Click Next

6. Select Installation destination , Click Next
Prerequisite Check for potential installation status=All prerequisite are passed successfully, Click Install

7. Installation Process, when successfully installed Click Finish

3. Licensing

Activate License Key- TOAD For ORACLE

  • Apply license keys to bundled products All products within a Toad Edition share a licensing key. For best results, when you have completed installation of your products, run Toad for Oracle first and enter the license key when prompted. This ensures that all installed products reflect the appropriate license key.

  • If you have previously licensed versions of Toad for Oracle or the other products in this Edition, your old license keys will continue to work. If you are upgrading to a different Edition and have been issued a new key, use the following procedure to apply it.

  • To add or upgrade an existing license :
    1. Launch Toad for Oracle.
    2. Select Help | Licensing, then enter your new license key. Any new features are enabled
    automatically, and any additional Toad products are licensed using this key.

  • Cumulative licensing
    Can add multiple licenses, including those for add-on packages like Sensitive Data Protection, to Toad. Toad will use the licenses providing the highest degree of features.

4. Managing Licenses

4.1 Move License to another computer

To move the Toad application and license from one user to another user on a different computer.

  1. Launch Toad on the old computer.

  2. Select Help | Register Toad.

  3. Copy the authorization string and site message. (Case sensitive).

  4. Install Toad on the new computer.

  5. Launch Toad on the new computer and it will prompt for registration.

  6. Type in the authorization string and site message noted in Step 3 above.

  7. Uninstall Toad from the old computer.