SQL Optimizer for Oracle 10.0 - Installation Guide

Installation

System Requirements

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

Virtualization Support

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

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.