Toad for Oracle 12.11 - Installation Guide

Install Toad silently from the command line

Install Toad for Oracle > Install Toad silently from the command line

A silent installation enables you to deploy Toad and other Edition products to multiple machines. To install silently, you download an MSI file and then execute command-line parameters to install one product at a time. You can change the parameters to fit your environment or standards, such as installing to a different directory.

These instructions are for performing a silent installation of Toad and, optionally, installing licenses on the target computers. To perform a silent installation of other products that are provided with your Toad Edition, see the installation guide for that product on https://support.quest.com/technical-documentation.

Run the silent installation

  1. Go to https://support.quest.com/download-product-select.
  2. Search for Toad for Oracle.
  3. Under MSI Installers (Special Installations Only), download the Toad 2017 Editions zip file.
  4. Unzip the download file.
  5. From the Windows command prompt, run the Toad for Oracle MSI file. The basic command to run a silent installation is the following:

msiexec /i "full path to MSI file"

Example

msiexec /i " C:\Users\jdoe\Downloads\ToadForOracle_12.10.0.111_x86_En.msi"

See Command-line options for additional options.

Install licenses

To install licenses on the target computers, you do the following:

  • Create a Questkey.reg text file to specify each license key.
  • Send the file to the target PC and import it to the Registry there.

To create the Questkey.reg file

Create the Questkey.reg file in a text editor. The following is a template:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}]

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}\Local]

[HKEY_CURRENT_USER\Software\{08439167-4CA5-48E9-A810-A3A7C0B80B06}\Local\REPLACE_WITH_KEY]
"SiteMessage"="REPLACE_WITH_SITEMESSAGE"
"ProductName"="REPLACE_WITH_PRODUCTNAME"
"ProductVersion"="REPLACE_WITH_PRODUCTVERSION"

Follow these steps to configure the file:

  1. Do not change the first two HKEY_CURRENT_USER lines. They are the key entries.
  2. Replace the “REPLACE_WITH_(KEY | SITEMESSAGE | PRODUCTNAME | PRODUCTVERSION)" text with the relevant information supplied with your license.

  3. Add any additional licenses as required in the same file by replicating the last four lines and then applying the correct information.

  4. Save the file.

To apply the file on the target computer

  1. Transfer the Questkey.reg file to the target PC.
  2. Import the file to the Registry on the target PC with the following command in the Windows command prompt:

    C:\> reg import Questkey.reg

When the user runs Toad and any product installed with Toad, the software validates the license and removes the entries from the Registry.

Toad (and any other product) is ready for use when the license is validated.

Command-line options

You can use the following command-line parameters when you silently install Toad:

Option Parameter Description
/l Package|ProductCode Installs or configures the product.
/f

[p|o|e|d|c|a|u|m|s|v]

Package|ProductCode

Repairs the product. This option ignores any property values entered in the command-line. The default argument list for this option is 'omus.' The following options are available:

  • p—Reinstalls only if a file is missing.
  • o—Reinstalls if a file is missing or an older version is installed.
  • e—Reinstalls if a file is missing or an equal or older version is installed.
  • d—Reinstalls if a file is missing or a different version is installed.
  • c—Reinstalls if a file is missing or the stored checksum does not match the calculated value. This option only repairs files that have msidbFileAttributesChecksum in the Attributes column of the File table.
  • a—Forces all files to be reinstalled.
  • u—Rewrites all required, user-specific registry entries.
  • m—Rewrites all required, computer-specific registry entries.
  • s—Overwrites all existing shortcuts.
  • v—Runs from source and re-caches the local package. Do not use this option for the initial installation of the product or feature.

/a

Package

Installs the product on the network.

/x

Package/ProductCode

Uninstalls the product.

/l

[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*]

Logfile

Writes logging information to a logfile in the specified path. The path to the logfile location must already exist. The installer does not create the directory structure for the logfile. Flags indicate which information to log. If no flags are set, the default is 'iwearmo.' The following options are available:

  • i—Status messages.
  • w—Nonfatal warnings.
  • e—All error messages.
  • a—Start up of actions.
  • r—Action-specific records.
  • u—User requests.
  • c—Initial UI parameters.
  • m—Out-of-memory or fatal exit information.
  • o—Out-of-disk-space messages.
  • p—Terminal properties.
  • v—Verbose output.
  • x—Extra debugging information. Only available on Windows Server 2003.
  • +—Append to existing file.
  • !—Flush each line to the log.
  • "*"—Log all information except for the v and x options. To include the v and x options, enter "/l*vx".

/q

n|b|r|f

Sets the user interface level. Review the following options:

  • q, qn—No UI
  • qb—Basic UI. Use qb! to hide the Cancel button.
  • qr—Reduced UI with no modal dialog box displayed at the end of the installation.
  • qf—Full UI and any authored FatalError, UserExit, or Exit modal dialog boxes at the end.
  • qn+—No UI except for a modal dialog box displayed at the end.
  • qb+—Basic UI with a modal dialog box displayed at the end. The modal box does not display if you cancel the installation. Use qb+! or qb!+ to hide the Cancel button.
  • qb- —Basic UI with no modal dialog boxes. Note that /qb+- is not a supported UI level. Use qb-! or qb!- to hide the Cancel button.

Note: The ! option is available with Windows Installer 2.0 and works only with basic UI. It is not valid with the full UI.

RESTRICTIONS

p Prevents users from saving their connection password by disabling the Save password field in the Database Login window. For example: RESTRICTIONS=p

i

Prevents users from accessing the Internet via Toad by disabling all Internet access in Toad. This can be combined with the 'p' parameter; for example: RESTRICTIONS=p,i

Install Toad as Read-only

Install Toad for Oracle > Install Toad as Read-only

A Read-only version of Toad prevents the user from making any changes to the database, regardless of his or her Oracle privileges. Toad provides a read-only installer in 32-bit and 64-bit versions. You must have the appropriate license for a read-only version of Toad.

To install Toad for Oracle Read-Only

  1. Obtain the license key and site message text for your installation.
  2. Go to https://support.quest.com/download-product-select.
  3. Search for Toad for Oracle.
  4. Under Read Only, download the appropriate Toad Edition installer.
  5. To install other products that are bundled with your Toad Edition:

    1. Under Web, download the appropriate Toad Edition installer.
    2. Run the Edition installer to install all of the desired products except Toad for Oracle. For help, see the Toad 2017 Editions Installation Guide at http://support.quest.com/technical-documentation.
  6. Run the Toad for Oracle Read-only installer.
  7. Select Toad for Oracle processor-type Read Only. (This is the only option in that installer.)
  8. Click Install.

Post-installation tasks

Post-installation tasks

Apply license keys to bundled products

Post-installation tasks > 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 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.

Related Documents