Toad® for Oracle Editions

Version 10.0

Release Notes

October 1, 2009

Contents

Welcome to Toad for Oracle Editions

New in this Release

Product Release Notes

System Requirements

For More Information

Welcome to Toad for Oracle Editions

Toad for Oracle is available in several different editions. Each of these comes packaged with additional Quest Products to expand your Oracle experience. In addition to these editions, the DB Admin module for the Toad executable may be added to any Toad Edition where it is not included.  This document contains information regarding all of these components. Please refer to the components contained in the edition covered by your license.

Toad for Oracle Base Edition
  • Toad® for Oracle
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad for Data Analysts

Toad for Oracle Professional Edition

  • Toad® for Oracle – Professional
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad for Data Analysts

Toad for Oracle Xpert Edition

  • Toad® for Oracle - Professional
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Quest SQL Optimizer for Oracle
  • Toad Data Modeler
  • Toad for Data Analysts

Toad Development Suite for Oracle

  • Toad® for Oracle - Professional
  • Toad Group Policy Manager
  • Quest SQL Optimizer for Oracle
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Quest Code Tester for Oracle
  • Benchmark Factory for Databases - Oracle Edition
  • Toad for Data Analysts

Toad DBA Suite for Oracle

  • Toad® for Oracle - Professional
  • DB Admin Module Add-on
  • Toad Group Policy Manager
  • Quest SQL Optimizer for Oracle
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Spotlight on Oracle - Standard Edition
  • Toad Data Modeler
  • Benchmark Factory for Databases - Oracle Edition
  • Toad for Data Analysts

 

Back to Top

New in This Release

To see what is new in each product, visit our Toad Editions page on ToadWorld, or view the release notes for each individual product.

 

Back to Top

Product Release Notes

 

To read the release notes for each product, click the links below:

 

Back to Top

System Requirements

 

The various products provided with the Toad for Oracle Editions have individual hardware and software requirements, detailed below.

Toad for Oracle Version 10

Before installing Toad for Oracle, ensure your system meets the following minimum hardware and software requirements:

Hardware
  • CD-ROM drive or internet connection (needed for install only)
  • VGA monitor, 1024x768 resolution, small fonts
  • Mouse pointing device
Memory
  • 512 MB RAM required, 1 GB recommended
Hard Disk Space
  • 75 MB disk space required to run Toad
Operating System

One of the following:

  • Windows 2000
  • Windows XP
  • Windows 2003
  • Windows Vista
  • Windows 2008

Note: 64-bit support for Windows 2003/XP/Vista/2008 with 32-bit Oracle Client
Additional Software
    Client (32-bit only)
  • Oracle v8i Client Net 8
  • Oracle v9 Client (Net 9)
  • Oracle v10 Client (Net 10) or Instant Client v10
  • Oracle v11 Client (Net 11) or Instant Client v11.1.0.7
    Server
  • Oracle versions 8.0.6; 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11g

Note: It is recommended that your client version be of the same release (or higher) as your database version.

In addition, to take advantage of Toad's new Unicode support, you must be working with Oracle client/server 9i or above.

Oracle Client/Server Compatibility All versions of the Oracle client are not necessarily compatible with all versions of the Oracle Server. If the version of the Oracle client you are currently using is not compatible with the version of the Oracle server where your database resides, the incompatibilities may cause errors within Toad. For more detailed information about possible compatibility issues, see Oracle’s Metalinkarticle 207303.1 "Client / Server / Interoperability Support Between Different Oracle Versions".

Toad Group Policy Manager

Editor Version 1.3.0.2

Service Version 1.2.0.1

Hardware Requirements
  • 75 MB disk space required to run Toad
  • 512 MB RAM required, 1 GB recommended
  • CD-ROM drive or internet connection (required for installation only)
  • VGA monitor, 1024x768 resolution, small fonts
  • 1024 x 768 screen resolution
  • Mouse pointing device

Software Requirements

To make full use of the Toad Group Policy Editor user interface, you will need one of the following Oracle clients. This is not required to use the application.

SQL*Net Version Associated Oracle Version
Net 8 (32-bit only) Oracle 8i
Net 9 Oracle 9
Net 10 Oracle 10
Net 11 Oracle 11
Instant Client Oracle 10

Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Admin Version 10

Hard Disk Space 65 MB

Toad for Data Analysts Version 2.5

System Requirements

Client Requirements

Ensure that the client computer meets the following minimum requirements:

Component Requirement
Platform 1 GHz minimum
Hard Disk Space 219 MB of disk space is required to run Toad
Memory

512 MB of RAM minimum, 1 GB recommended

Note: 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
Operating System

Windows Server 2003

Windows XP Professional (32-bit or 64-bit)

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Important (SQL Server only): Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista and Windows Server 2008. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.
Additional Requirements

.NET Framework

Microsoft .NET Framework 3.5 (Service Pack 1)

Note: The following conditions apply:

  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. See "User Requirements" (page 5) for more information.

Web Browser

Microsoft Internet Explorer 8.0 or later

Existing DB2 Client Support (DB2 native provider only)

Toad installs a DB2 9.5 client as part of the installation process. The DB2 9.5 client can co-exist with an existing DB2 8 client; however, it is incompatible with a DB2 7 client. If a DB2 7 client is already installed on the system, the Toad installation stops and cannot complete. You must upgrade to the DB2 8 client and restart the Toad installation to avoid losing functionality in some DB2 native tools.

Oracle Client

Toad can connect to Oracle using Direct Connect (no need for an Oracle Client) or can connect using an Oracle Client or Oracle Instant Client. However, if you want to use LDAP, you must install an Oracle Client. See "Configure Oracle LDAP Support" (page 5) for more information.Toad supports 9i or later Oracle Clients and Oracle Instant Clients. See "Create Oracle Connections" (page 5) for more information about configuring an Oracle Instant Client to work with Toad.

Server Requirements

Ensure that the server meets the following minimum requirements:

Component Requirement
Operating System

Oracle Native Database Provider

  • IBM AIX 5.1, 5.2, 5.3
  • HP-UX 11i 1.5, 2 (32-bit and 64-bit)
  • Red Hat Enterprise Linux AS release 3 and 4 32-bit and 64-bit)
  • Solaris 7, 8, 9, 10 (32-bit and 64-bit)
  • SuSE 7, 8, 9
  • Windows 2003 (32-bit and 64-bit)
  • Windows XP

SQL Server Native Database Provider

  • Windows Server 2000 (Service Pack 4 or later)
  • Windows 2000 Professional Edition (Service Pack 4 or later)
  • Windows XP 32-bit (Service Pack 2 or later) and 64-bit
  • Windows Server 2003 32-bit or 64-bit (Service Pack 1 or later)
  • Windows Vista 32-bit and 64-bit
  • Windows Server 2008 32-bit or 64-bit
  • Windows 7 32-bit or 64-bit

DB2 for z/OS Native Database Provider

  • z/OS (V1R6 Base Services [5694-A01] or later)

DB2 for LUW Native Database Provider

  • IBM AIX 5.1, 5.2, 5.3, 6.1
  • HP-UX 11i 1.5, 2 (32- and 64-bit)
  • Red Hat Enterprise Linux AS release 3 and 4 (32-bit and 64-bit)
  • Solaris 7, 8, 9, 10 (32-bit and 64-bit)
  • SuSE 7, 8, 9
  • Windows 2000, 2003 (including 64-bit), XP

MySQL Native Database Provider

  • Windows 2000 (Service Pack 4 or later)
  • Windows 2003
  • Windows XP 32-bit and 64-bit
  • Windows Vista 32-bit and 64-bit
Native Database Support

Toad supports the following databases:

  • Oracle 9i, 10g, 11g

  • SQL Server 2000 (Service Pack 3 or later), 2005 (Service Pack 2 or later), 2008

    Note: SQL Server Compact Edition is not supported.

  • IBM DB2 for z/OS 8.1 or later

    Note: At this time, Toad supports DB2 for z/OS running in Full Function mode, but does not support DB2 running in Compatibility mode.

  • IBM DB2 for LUW 8.1.5 or later, 9.1 or later
  • MySQL 5.1
  • Sybase ASE 12.5, 15.0.2
  • Access 2003, 2007
  • Excel 2003, 2007
ODBC Database Support

Toad for Data Analysts supports almost all databases that you can connect to using an ODBC 3.0 or later driver. For a list of databases that are not supported, see “Known Issues” in the release notes.

Toad for Data Analysts Quality Assurance has tested the following databases using an ODBC 3.0 or later driver:

  • DB2 for i5/OS V5R4 and IBM i 6.1 (limited testing)
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)
  • Netezza Data Warehouse Appliance 4.5
  • Teradata V2R6.1 (limited testing)

Citrix Requirements

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

Note: The following exceptions exist for Power Users:

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user--a Power User, Restricted User, Vista standard user--on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

Quest SQL Optimizer for Oracle Version 7.5

Before installing Quest SQL Optimizer for Oracle, ensure your system meets the following minimum hardware and software requirements:

Platform

Intel x86. (233 MHz or higher)
Memory

512 MB of RAM minimum; 768 MB of RAM recommended

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

  • Applications that are running on your local computer
Hard Disk Space 90 MB of disk space for installation
Operating System

Microsoft Windows 2000

Microsoft Windows 2003 (32-bit and 64-bit)

Microsoft Windows XP (32-bit and 64-bit)

Microsoft Windows Vista (32-bit and 64-bit)

Microsoft Windows 2008 (32-bit and 64-bit)

Note: In Windows Vista, you must use a logon with the Admin privilege or if you are logged on as a normal user, you must have the Universal Access Control (UAC) turned OFF.
Additional Software

For Windows 2000, 2003, or XP Professional, Microsoft’s .NET Framework 2.0 SP1 or SP2, or 3.5 is required.

Note: You must have either SP1 or SP2 for .NET Framework 2.0 installed. If you have only .NET Framework 3.0 installed, you must still install .NET Framework 2.0 and the service pack or you must install .NET Framework 3.5 (which includes .NET 2.0 SP1)

For Windows Vista, Microsoft’s .NET Framework 3.0 is required.
Browser

Microsoft Internet Explorer 6.0 or later
PDF Viewer Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)
Database Client

Oracle SQL*Net

Net8 (32-bit only)

Net9

Net10

Net11

Instant Client
Database Server Oracle 8.1.7, 9i, 10g, 11g

Benchmark Factory Version 6

Before installing Benchmark Factory for Databases, ensure your system meets the following minimum hardware and software requirements:

Repository

Benchmark Factory cannot run without a repository, and by default a MySQL repository is installed during the install process. After installation, you can remove the MySQL service and delete the MySQL repository, then select a repository of your choice. Benchmark Factory supports the following databases:

  • Oracle
  • SQL Server
  • MySQL
  • Sybase Adaptive Server Anywhere (iAnywhere)
Platform

1.0 GHz x86 or x64 compatible CPU
Memory

512 MB of RAM recommended

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

120 MB of disk space for installation

Note: The disk space required may vary based on options selected for installation.
Operating System

Windows 2000, 2003, 2008, XP Professional, and Vista
Database Client/Server Versions

Oracle: 8, 8i, 9i, 9.2, 10g, and 11g (Note: Requires Oracle 8.1.7 client libraries or higher.)

SQL Server: 7, 2000, 2005, and 2008

Sybase: 12.5 and 15

DB2 LUW: 8.1.5 through 9

MySQL: 4.5 and 5.x

All client libraries require the 32-bit versions.

Spotlight on Oracle Version 6.1

System Requirements

Before installing Spotlight on Oracle, ensure your system meets the following minimum hardware and software requirements:

Platform

A Pentium-based or equivalent PC with:

  • A 1.2 GHz Processor (recommended minimum). The required processing power will increase when Spotlight diagnoses Oracle RAC clusters with many instances.
  • A monitor capable of supporting a resolution of 1280x1024 or larger. (You should also set the display to use the 64K color palette [65536 colors].)
  • A CD-ROM drive or Internet connection. Spotlight can be downloaded from the Internet or installed from compact disc. The CD-ROM drive should be attached to the PC on which Spotlight is to be installed. A drive mapped to a network device could be used if a local CD-ROM is not available.
  • A printer (optional). Spotlight reports can be printed on a laser or bubble jet printer. You can print graphs in color if your printer provides this capability.
  • A sound card and speakers (optional). Spotlight can use sound to alert you when a threshold is reached. You must have a sound card and speakers installed on your PC for this feature to work.
Memory

512 megabytes of RAM (minimum). 512 megabytes is a minimum RAM requirement (assuming no other applications are running), but 1 gigabyte of RAM is recommended. Memory consumption will increase as the number of instances in an Oracle RAC cluster increases, and will also depend on the connection options chosen.
Hard Disk Space

150 megabytes of free disk space. This should exist on a local disk drive rather than a network drive. Extra disk space will be required if you choose to log historical snapshots from within Spotlight.
Client Operating System

Windows 2000, Windows 2003 Server, Windows XP Professional, or Windows Vista Business. The following specific requirements exist:

  • Windows 2000: Service Pack 4 (or later) must be installed.
  • Windows XP: Service Pack 1 (or later) must be installed.
Additional Software
  • SQL*Net 2.3.4 or later. SQL*Net enables a connection to be established to a database. The database may be local or remote. Before you start Spotlight you must have the SQL*Net connection string for the database.
  • Oracle Client. (Oracle 9.2, Oracle 10g [full client or instant client], or Oracle 11g). Spotlight also requires that the version of the Oracle client be the same or later than the version of any Oracle database being diagnosed. For example, to connect to an Oracle 10g cluster, you must use an Oracle 10g client or later.
Database Server

The following Oracle database servers are supported for database queries. (You must have the Database Administrator [DBA] user ID and password for the database you want to diagnose.)

  • Oracle 9.2.0.4 or later
  • Oracle 10g (Release 1 or Release 2)
  • Oracle 11g (Release 1)
OS Server

The following server operating systems are supported for OS Server queries:

  • Sun Solaris 8, 9, 10
  • HP-UX 11i, 11i v2, 11i v3
  • IBM AIX 5.2, 5.3, 6.1
  • Red Hat and SUSE operating systems running Linux 2.4 and 2.6 kernels
  • Compaq 4.0f, 5.x
  • Windows 2000 SP4, Windows XP SP1, Windows 2003 Server, or Windows 2008 Server.
  • Itanium server (HP-UX and Windows)

Notes:

  • Oracle connections ARE supported for Itanium operating systems, but OS commands are NOT.
  • Spotlight on Oracle RAC does NOT support OS server queries for Compaq 4.0f, 5.x servers or Itanium servers.
Oracle RAC Servers

Spotlight on Oracle RAC supports up to 16 instances in a cluster, with a theoretical limit of 36 instances.

Toad Data Modeler Version 3.4.15

Before installing Toad Data Modeler, ensure your system meets the following minimum hardware and software requirements:

Platform

Pentium IV
Memory

Minimum 256 MB
Hard Disk Space

100 MB
Operating System

Windows 2000/XP/Vista

Quest Code Tester for Oracle Version 1.8.4

Platform

1.0 GHz x86 compatible CPU
Memory

512 MB of RAM recommended
Hard Disk Space

40 MB of disk space for installation
Operating System

Windows 2000, 2003, XP Professional, Vista
Database/Client Versions

Database Server: Oracle 9i Database Release 2 (9.2.0.6 or above), Oracle Database 10g, Oracle Express Edition, and Oracle Database 11g Release

Database Client: Oracle SQL Net 9, 10 and 11, plus Instant Client. For Oracle 64bit servers, 32bit client is required.

Required Database Privileges

The schema in which you install Quest Code Tester must have these privileges:

CREATE PROCEDURE

CREATE SEQUENCE

CREATE SESSION

CREATE SYNONYM

CREATE TABLE

CREATE TRIGGER

CREATE VIEW

CREATE TYPE

Note 1: Quest Code Tester will create a schema with the necessary privileges as part of the installation process, when the create new user and install into new user schema option is selected on Step 2 of the Repository Wizard.

Note 2: We recommend that you install Quest Code Tester into its own schema, and create public synonyms so that all developers will be able to use Quest Code Tester and share their test definitions. This will also help you keep application code distinct from the Quest Code Tester code base. To do this, your schema must also have CREATE and DROP PUBLIC SYNONYM privileges.

Back to Top

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad Quest team and other community members. Join the Toad World community at www.toadworld.com

Contacting Quest Software:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com
ToadWorld http://ToadWorld.com

Refer to our web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.

The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.

 

Back to Top

©2009 Quest Software, Inc.

ALL RIGHTS RESERVED.

 

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

 

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

 

www.quest.com

Email: legal@quest.com

Refer to our web site for regional and international office information.

 

Trademarks

 

Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

 

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

 

Back to Top