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.

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

Run the SQL Optimizer installation program.
In the License Agreement page, review and accept the license agreement. Click Next.
In the Select the Products to Install page, select SQL Optimizer for Oracle and select an installation directory. Click Install.
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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem