Chat now with support
Chat with Support

SQL Optimizer for Oracle 9.2.3 - Installation Guide

Installation

System Requirements

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

Requirement Details

Platform

1 GHz Processor

Memory

1 GB of RAM for SQL Optimizer for Oracle 32-bit

2 GB of RAM for SQL Optimizer for Oracle 64-bit

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

180 MB of disk space for SQL Optimizer for Oracle 32-bit

217 MB of disk space for SQL Optimizer for Oracle 64-bit

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

Operating System

Microsoft Windows Server 2008 R2

Microsoft Windows 7 32-bit and 64-bit

Microsoft Windows 8 32-bit and 64-bit

Microsoft Windows 8.1 32-bit and 64-bit

Microsoft Windows 8.1 (with Update) 32-bit and 64-bit

Microsoft Windows Server 2012 R1

Microsoft Windows Server 2012 R2

Microsoft Windows Server 2012 R2 (with Update)

Microsoft Windows 10 32-bit and 64-bit

Microsoft Windows Server 2016

.NET Framework

Microsoft .NET Framework 4.0 Full Profile

Browser

Microsoft Internet Explorer 6.0 or later

Note: Other browsers may also be used.

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

Oracle v10 Client (Net10)

Oracle v11 Client (Net11)

Oracle 12c Client

Oracle Instant Client

Note: You must use the 32-bit version of SQL Optimizer if you use the 32-bit Oracle Client, and the 64-bit version of SQL Optimizer if you use the 64-bit Oracle Client.

Database Server

Oracle 10g R2, 11g R1, 11g R2, 12c Release 1, 12c Release 2

SQL Optimizer has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

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

Cloud Database Service

Oracle Database as a Service

Oracle databases running on Amazon EC2, Amazon RDS, and Microsoft Azure

Virtualization Support

Before installing SQL Optimizer for Oracle®, review the following for virtualization support:

Type Details
Application Virtualization

SQL Optimizer has been tested with the following:

  • Citrix XenApp 6.5 on Windows Server 2008 R2
  • Microsoft Application Virtualization (App-V) 5.0 on Windows 7 and Windows Server 2012
Server Virtualization

SQL Optimizer has been tested with the following:

  • Oracle VM 2.2.0 running on Oracle Enterprise Linux 5 Update 2 64-bit with Oracle 10g R2
  • Oracle VM 2.2.0 running on Oracle Enterprise Linux 5 Update 3 32-bit with Oracle 11g R1
  • Oracle VM 3.1.1 running on Windows Server 2008 R2 with Oracle 11g R2
  • Oracle VM 3.2.2 running on Oracle Linux Release 6 Update 4 Media Pack v1 for x86 (32-bit) with Oracle 10g R2.
  • Oracle VM 3.2.2 running on Windows Server 2008 R2 64-bit with Oracle 11g R1.
  • Oracle VM 3.2.2 running on Oracle Linux Release 6 Update 4 for x86_64 (64-bit) with Oracle 11g R2.

Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested.

 

Install SQL Optimizer

Note: SQL Optimizer supports side-by-side installation. If you have a previous version of SQL Optimizer installed, when you run the installation program for the current version, you can either install the upgrade into the existing directory or you can install it into a new directory to have both versions installed side-by-side.

To install SQL Optimizer

  1. Run the SQL Optimizer installation program.

  2. In the License Agreement page, review and accept the license agreement. Click Next.
  3. In the Select the Products to Install page, select SQL Optimizer for Oracle and select an installation directory. Click Install.
  4. When the installation finishes, click Finish.

The commercial, trial, and beta versions of SQL Optimizer are installed independently of one another. You can install or uninstall one without impacting the other.

Notes: 

  • A known Oracle issue causes the database connection to fail when using a pre-11g client and when the application directory path contains parentheses. In a 64-bit environment, the default directory for a 32-bit application is "C:\Program Files (x86)\". In this situation, if you use the default directory when installing SQL Optimizer, you cannot connect to Oracle. To work around this issue, install SQL Optimizer into a directory path that does not contain parentheses (if you are using a pre-11g client).
  • When installed as part of a Quest Software suite, SQL Optimizer is located within the suite root folder.

Silent Install of SQL Optimizer

To perform a silent installation of SQL Optimizer

  • Execute the following command: 

    msiexec /i "path to msi file\SQLOptimizerForOracle_version.msi" /qn

    Note: The following command line parameters are used:

    Command-Line Parameters Definition

    /i

    Installs a product.

    /qn

    Sets user interface to No UI.
    Optional Command-Line Parameters Definition

    INSTALLDIR=
    "InstallDir"

    Specifies the install directory path.

    LANG=
    "LangOption"

    Specifies the language version.

    LANG="EN"—Installs the English language version of the application.

    Note: If you do not specify a language during install, the default is English. If you do not specify a language when repairing after install, the old language option is overwritten by the English language option.

     

To perform a silent installation of SQL Optimizer in a directory other than the default product directory

  • Execute the following command: 

    msiexec /i "path to msi file\SQLOptimizerForOracle_version.msi" /qn INSTALLDIR="InstallDir"

    Note: Use the INSTALLDIR parameter if you are upgrading and want to install the new version side-by-side with the previous version. Otherwise, the upgrade overwrites the current version.

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