Toad for Oracle Editions Silent Installation Guide
Contents
1. Enter the following command msiexec i lt path to msi file QuestSQLOptimzer Oracle version msi gt qn Toad for Oracle Editions Silent Installation Guide 14 Silent Installation where i install qn quiet no UI To silently install SQL Optimizer in a custom directory 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information See Extract MSI Files page 7 for more information Enter the following command msiexec i lt path to msi file QuestSQLOptimizer Oracle Common msi gt qn INSTALLDIR InstallDir Enter the following command msiexec i lt path to msi file QuestSQLOptimzer Oracle version msi gt qn INSTALLDIR InstallDir Note Use the INSTALLDIR parameter if you are upgrading and would like to have both the current version and the new version installed Otherwise the upgrade overwrites the current version Install Benchmark Factory Silently To install Benchmark Factory silently 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information See Extract MSI Files page 7 for more information Enter the following command msiexec exe i lt path to msi file BenchmarkFactory version msi gt qn INSTALLDIR lt destination directory gt Where version is the full version including the build number for example 6 0 0 147 Install Toad Data Modeler Silently To install Toad Data Modeler silently2. qn TARGETDIR install_dir Knowledge Xpert ARPSYSTEMCOMPONENT 1 Toad for Oracle Editions Silent Installation Guide 13 Silent Installation Install Code Tester Silently To install Code Tester silently 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information See Extract MSI Files page 7 for more information Enter the following command msiexec exe i lt path to msi file QuestCodeTester_ version msi gt qn Where version is the full version including the build number for example 1 8 4 447 You can also specify an install directory by entering the following command MSIExec exe i lt path to msi file QuestCodeTester version msi gt qn INSTALLDIR lt destination directory gt Install SQL Optimizer Silently Review the Microsoft INET requirements for the various operating systems required to run the SQL Optimizer for Oracle application Operating System NET Requirement Windows 2000 2003 or XP Professional NET Framework 2 0 Service Pack 1 or Service Pack 2 or NET Framework 3 5 Windows Vista 7 or 2008 NET Framework 3 0 To silently install SQL Optimizer in the default directory 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information See Extract MSI Files page 7 for more information Enter the following command msiexec i lt path to msi file QuestSQLOptimizer Oracle Common msi gt qn
3. 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information 2 Enter the following command Toad for Oracle Editions Silent Installation Guide 15 Silent Installation setup msi q INSTALLDIR C Program Files Quest Software Toad Data Modeler version The argument for the silent installation from a command line is q To specify a directory where Toad Data Modeler should be installed use INSTALLDIR PATH Otherwise the default path is used Example To specify the database platform where you want to install Toad Data Modeler or which shortcuts should be created and where use the ADDLOCAL parameter If this parameter is not used a default installation is performed Example setup msi q INSTALLDIR C Program Files Quest Software Toad Data Modeler version ADDLOCAL Complete XPMANIFEST SUPPORTDATABASES SHORTCUTUNINSTALL SHORTCUTDESKTOP SHORTCUTSTARTMENU SHORTCUTQUICKLAUNCH SHORTCUTHELP POSTGRESQL POSTGRESQL81 POSTGRESQL82 If you use the ADDLOCAL parameter always select the Complete XPMANIFEST and SUPPORTDATABASES options These options are required for the correct installation When installing support for a particular database platform you must install basic support for the selected database platform For example to support the Oracle 10g database Oracle must also be selected Shortcuts You can use the following t
4. 20 0 0 00 000202 c eee ee cece cece cee eceecececececececeseeeeeeees 5 Silent Installation 7 Extract NIS Ll a ee e Ee ORE en eee Ee Oe T Parameters for Silent Installations 2 2 2 0 020 000 0c ce cece cece ee ce cececeeeeeee es 8 Install Toad for Oracle Seny 11 Install Patches Sent yoii ai 2990 0 epics R eide R AA RRR RR dR CA 11 Uninstall Toad Silent 12 Install Knowledge Xpert Sien 12 Install Code Tester Sien 13 Install SQL Optimizer Sien 13 Install Benchmark Factory Seny 14 Install Toad Data Modeler Sien 14 Te e Ss ace toa ees e daa nee es nace ae Ne eases ce tet tat een ete a ae 15 Install Toad for Data Analysts Sien 16 Install Spotlight Sien 17 Install Spotlight with RAC Option Silently 17 About ProductLicenses xml 00 0 0 0 ccc ce ceeeeceeeececcececcececcesecessecuseeens 17 Windows 2000 Windows XP Windows 2003 0 22 c cece cece cece eee 17 Windows Vista Windows 2008 Windows T 18 Bile o chee att ea he eaten et ee ede 18 Appendix Contact Quest 20 Contact Quest Support 20 0 0 0 020 e cece cece eee eeeeees 20 Contact Quest Software 0 0 0 0 0 02 ccc ccc ccc ce cece ces ececeecececececececeeeeeeeee 20 About Quest Software 2 20 0 0 0 0 0 cc cece cece cee aaao odaad oaoaraa aeara 20 Toad for Oracle Editions Silent Installation Guide Table of Contents Toad Editions About Toad Editions Each Toad for Oracle edition is packaged with
5. See Extract MSI Files page 7 for more information 2 Enter a command similar to the following msiexec i lt path to msi file ToadforOracle_ version msi gt INSTALLDIR lt installation folder including final gt ADDLOCAL Client Server q l v lt path to install log including file name gt Note INSTALLDIR must include the final to perform a silent installation For example msiexec i C Documents and Settings Johndoe desktop ToadforOraclel0 6 exe INSTALLDIR C Programs Quest Software Toad for Oracle ADDLOCAL Client Server q l v C install log Install Patches Silently If you already have Toad installed and want to upgrade silently you must include REINSTALLMODE vo REINSTALL ALL in the command If these parameters are not included the MSI registers that Toad is already installed and does not upgrade it For example if you are currently in the directory where the MSI resides entering the following installs to the standard location msiexec exe i lt path to msi file ToadforOracle_ version SetupFull msi gt REINSTALLMODE vo REINSTALL ALL You can also set additional parameters or run the MSI from a location other than the active directory as in the following example msiexec i C Documents and Settings johndoe desktop ToadforOraclel0 6SetupFull msi REINSTALLMODE vo REINSTALL ALL INSTALLDIR C Programs Quest Software Toad for Oracle q l v C install log Toad for Oracle Edition
6. additional Quest products to expand your Oracle experience The following editions are available Toad for Oracle Base Edition Toad for Oracle Knowledge Xpert for PL SQL Knowledge Xpert for Oracle Admin Toad Data Modeler Toad for Data Analysts Toad for Oracle Xpert Edition Toad for Oracle Xpert Quest SQL Optimizer for Oracle Knowledge Xpert for PL SQL Knowledge Xpert for Oracle Admin Toad Data Modeler Toad for Data Analysts Toad for Oracle Professional Edition Toad for Oracle Professional Knowledge Xpert for PL SQL Knowledge Xpert for Oracle Admin Toad Data Modeler Toad for Data Analysts Toad Development Suite for Oracle Toad for Oracle Xpert 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 Data Modeler Toad for Data Analysts Toad for Oracle Editions Silent Installation Guide Toad Editions Toad DBA Suite for Oracle Toad for Oracle Xpert DB Admin Module Add on Quest SQL Optimizer for Oracle Knowledge Xpert for PL SQL Knowledge Xpert for Oracle Admin Spotlight on Oracle Benchmark Factory for Databases Oracle Edition Toad Data Modeler Toad for Data Analysts Toad DBA Suite for Oracle RAC Edition Toad for Oracle Xpert DB Admin Module Add on Quest SQL Optimizer for Oracle Knowledge Xpert for PL SQL Knowledge Xpert for Oracle Admin Spotlight on Oracle with
7. e Flush each line to the log e Log all information except for the v and x options To include the v and x options enter NI Toad for Oracle Editions Silent Installation Guide 10 Silent Installation Option Parameter Description q nibir f Sets the user interface level Review the following options e q qn No UI e qb Basic UI Use qb to hide the Cancel button e qr Reduced UI with no modal dialog box displayed at the end of the installation e qf Full UI and any authored FatalError UserExit or Exit modal dialog boxes at the end e qn No UL except for a modal dialog box displayed at the end e 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 e 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 UL It is not valid with the full UI RESTRICTIONS p Toad for Oracle only Prevents users from saving their connection password by disabling the Save password field in the Database Login window For example RESTRICTIONS p Toad for Oracle Editions Silent Installation Guide 11 Silent Installation Install Toad for Oracle Silently To install Toad silently 1 Extract the MSI from the Quest Installer
8. E QUEST SOFTWARE Toad for Oracle Editions 10 6 Silent Installation Guide 2010 Quest Software Inc ALL RIGHTS RESERVED This guide contains proprietary information protected by copyright The software described in this guide 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 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 O
9. R 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 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 Benchmark Factory Knowledge Xpert Quest vWorkSpace Spotlight Toad T O A D Toad World and vToad are trademarks and registered trademarks of Quest Software Inc in the United States of America and other countries For a complete list of Quest Software s trademarks please see http www quest com legal trademark information aspx Other trademarks and registered trademarks used in this guide are property of their respective owners Toad for Oracle Editions 10 6 Silent Installation Guide September 2010 Table of Contents Toad Edi0OonS sega gs ccd het ora ath oa lacie ns ee ceel ad ceee celeste 5 About Toad Editions
10. RAC Option Benchmark Factory for Databases Oracle Edition Toad Data Modeler Toad for Data Analysts The DB Admin Module can be added to any Toad edition Knowledge Xpert is now available as a web application at http www toadworld com kxpert oracle Quest recommends using the web version of this product because the desktop version will not be supported in the near future Commercial versions of Toad editions also include a copy of the Toad for MySQL freeware product Quest support is not available for this product Silent Installation Extract MSI Files You can open the Quest Installer in extract mode to extract product MSI installers included in the Toad Editions to use for silent installations To extract MSI files from the Quest Installer 1 Run any of the Toad Editions from the command prompt and add the extract parameter cx C WINDOWS system32 cmd exe IC gt me lf lsw 1i qe_ftp Distributables Milestone_Buil 6 Toad Bundles Lice mseTesting4 Toad DBA Suite for Oracle 10 0 Commercial exe extract Note Make sure that you use a bundle that contains the MSI files that you require 2 Review the following for additional information Product Description Selection Page Select the Verify that all the products you want to extract display in this list product If a product does not display you should start over and select an you want edition that contains all the files to extract Finsh Page Descript
11. Spotlight on Oracle RAC SQL Optimizer Toad Data Modeler Toad for Data Analysts Spotlight on Oracle RAC silent instal Spotlight on Oracle silent instal SQL Optimizer silent install T Toad Data Modeler silent install 14 Toad Editions 5 Toad for Data Analysts silent install 16 Toad for Oracle silent install 11
12. ion Readme txt Click this link to open the extraction log as well as the command line parameters that are needed to perform default installations of the products This file also defines the order in which the products need to be installed to satisfy the dependencies between the products See Parameters for Silent Installations page 8 for more information about performing a custom installation Note You do not need to install the Quest Installer on any of the computers where you are silently installing Toad products The Quest Installer is only used to extract the required MSI files Toad for Oracle Editions Silent Installation Guide Silent Installation Parameters for Silent Installations The following parameters are available for a silent install Option Parameter Description I Package ProductCode Installs or configures the product f plo e d c ajujm s v Repairs the product This option ignores Package ProductCode 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 Th
13. is 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 Toad for Oracle Editions Silent Installation Guide 9 Silent Installation Option Parameter Description a Package Installs the product on the network Ix Package ProductCode Uninstalls the product l i wlela rju c mlo p v x Writes logging information to a logfile 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 e i Status messages e w Nonfatal warnings e e All error messages e a Start up of actions e r Action specific records e u User requests e c Initial UI parameters e m Out of memory or fatal exit information e o Out of disk space messages e p Terminal properties e v Verbose output e x Extra debugging information Only available on Windows Server 2003 e Append to existing file
14. mally by the product for determining key priority when more than one suitable key is found It is interpreted as an OLE date type and is represented as a floating point number When performing a silent installation or manually editing the ProductLicenses xml file it is recommended that you omit this attribute If this value is missing the product automatically updates this attribute with the file s last modified date value Toad for Oracle Editions Silent Installation Guide Silent Installation License Node Elements The following describes the elements for the license node s LicenseKey This is the license key that was provided by Quest e SiteMessage This is also provided by Quest and typically contains the name of the customer and other asset information 19 Appendix Contact Quest Contact Quest Support Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract Quest Support provides unlimited 24x7 access to SupportLink our self service portal Visit SupportLink at http support quest com From SupportLink you can do the following e Retrieve thousands of solutions from our online Knowledgebase e Download the latest releases and service packs e Create update and review Support cases View the Global Support Guide for a detailed explanation of support programs online services contact information policies and pr
15. o create shortcuts when installing silently Command Description SHORTCUTUNINSTALL Creates a shortcut for uninstall in the Start menu SHORTCUTDESKTOP Creates a shortcut for Toad Data Modeler on the desktop SHORTCUTSTARTMENU Creates a shortcut for Toad Data Modeler in the Start menu SHORTCUTQUICKLAUNCH Creates a shortcut for Toad Data Modeler in the Quick Launch bar SHORTCUTHELP Creates a shortcut for the Help file User Manual and Reference Guide in the Start menu Tip Other parameters for silent installs can be found if you enter the setup msi command Toad for Oracle Editions Silent Installation Guide 16 Silent Installation Install Toad for Data Analysts Silently Before you perform a silent installation you must install the following software on every computer where you are installing Toad for Data Analysts e Microsoft NET Framework 3 5 Service Pack 1 e Existing DB2 client on system Toad for Data Analysts installs a DB2 9 7 client as part of the installation process The DB2 9 7 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 installation stops and cannot complete You must first upgrade to the DB2 8 client Then restart the installation to avoid losing functionality in some DB2 native tools To install Toad for Data Analysts silently 1 Extract the MSI from the Quest Installer See Ext
16. ocedures The guide is available at http support quest com Contact Quest Software Email info quest com Quest Software Inc World Headquarters Mail 5 Polaris Way Aliso Viejo CA 92656 USA Web site www quest com See our web site for regional and international office information About Quest Software Quest Software simplifies and reduces the cost of managing IT for more than 100 000 customers worldwide Our innovative solutions make solving the toughest IT management problems easier enabling customers to save time and money across physical virtual and cloud environments For more information about Quest go to www quest com Index B Benchmark Factory silent install C Code Tester silent install contact support E editions Toad F files extract MSI I install Benchmark Factory silently Code Tester silently Knowledge Xpert silently parameters for silent Spotlight on Oracle RAC silently Spotlight on Oracle silently SQL Optimizer silently Toad Data Modeler silently Toad for Data Analysts silently Toad silently K Knowledge Xpert silent install 14 13 20 14 13 12 17 13 14 16 11 12 M MSI files extracting N network silent nstallation P parameters silent install ProductLicenses xml Q Quest Installer extract MSI files silent installation Benchmark Factory Code Tester extract MSI files Knowledge Xpert parameters Spotlight on Oracle
17. ract MSI Files page 7 for more information Enter the following command msiexec i lt path to msi file ToadforDataAnalysts_version msi gt q You can use an msi logging switch to include an install log by entering the following msiexec i lt path to msi file ToadforDataAnalysts_ version msi gt q L v path_to_verboseLog txt You can override the following optional properties INSTALLDIR Specify a folder other than default installation folder READONLY Enter TRUE if you want to install as read only ApplicationUsers Enter AllUsers to install the product for all users Enter OnlyCurrentUser to install the product only for the user that performs the installation The following is an example command to install as read only for all users to a user selected folder msiexec i path _to_installer msi INSTALLDIR Your install path READONLY TRUE ApplicationUsers AllUsers q Toad for Oracle Editions Silent Installation Guide 17 Silent Installation Install Spotlight Silently You cannot install the extracted Spotlight on Oracle file because it is not an MSI file and cannot be mn outside of the Quest Installer To obtain a copy of the Spotlight on Oracle MSI that you can install silently contact Quest Support Install Spotlight with RAC Option Silently You cannot install the extracted Spotlight on Oracle with RAC Option because it is not an MSI file and cannot be run outside of the Quest In
18. rogramData Quest Software ProductLicenses xml File Format The format of the ProductLicenses xml file consists of a collection of license nodes There is a license node for each license that has been saved to the computer Each license node is comprised of three attributes and two elements The following is an example of a License node lt License ProductName product name ProductVersion product version KeySaveDate key save date gt lt LicenseKey gt License Key lt LicenseKey gt lt SiteMessage gt Site Message lt SiteMessage gt lt License gt License Node Attributes The following describes the attributes for the license node e ProductName This is a case sensitive text value that is assigned by Quest to uniquely identify the product associated with the license key ProductNames are not likely to change between versions of the product It is recommended that you do not alter this attribute e ProductVersion This is a unique identifier for a specific version of a product It is typically only specific to the major version number 1 x This means that all minor and patch updates are still able to use this key However it can be specified all the way down to the build number if required by the product 1 0 0 13 Its primary purpose is to support side by side installations for different versions of a product e KeySaveDate This is the date that the key was saved into the system This is used inte
19. s Silent Installation Guide 12 Silent Installation Uninstall Toad Silently To silently uninstall Toad Enter a command similar to the following msiexec x lt path to msi file ToadforOracle _ version SetupFull msi gt q Install Knowledge Xpert Silently When silently installing Knowledge Xpert Oracle Admin and PL SQL you must also install the Knowledge Xpert Engine and the Knowledge Xpert Oracle Common components To install Knowledge Xpert silently 1 Extract the MSI from the Quest Installer See Extract MSI Files page 7 for more information See Extract MSI Files page 7 for more information Enter the following command msiexec exe i lt path to msi file KXEngineSetup msi gt q l v path_to_ install log KxXEngineSetup msi log qn TARGETDIR install dir Knowledge Xpert ARPSYSTEMCOMPONENT 1 DISABLEADVTSHORTCUTS 1 Enter the following command msiexec exe i lt path to msi file KXOraCommon msi gt q l v lt path to install log KXOraCommon msi log gt qn TARGETDIR install dir Knowledge Xpert ARPSYSTEMCOMPONENT 1 Enter the following command msiexec exe i lt path to msi file KXOraAdmSetup msi gt q l v lt path to install log KXOraAdmSetup msi log gt qn TARGETDIR install_ dir Knowledge Xpert ARPSYSTEMCOMPONENT 1 Enter the following command msiexec exe i lt path to msi file KXPLSQLSetup msi gt q l v lt path_to_install_ log KXPLSQLSetup msi log gt
20. staller To obtain a copy of the Spotlight on Oracle with RAC Option MSI that you can install silently contact Quest Support Note The Spotlight on Oracle with RAC Option is only included in the Toad DBA Suite for Oracle commercial or trial RAC edition About ProductLicenses xml The ProductLicenses xml file can be found in one of three locations depending upon the needs of the product The locations are Local User Roaming User and All Users By default all Toad products save the license key information in the Local User directory However all edition products can read from any of the locations These directories are defined by the operating system and vary from platform to platform The following tables list the directory locations by operating system Windows 2000 Windows XP Windows 2003 Local user C Documents and Settings lt username gt Local Settings Application Data Quest Software ProductLicenses xml Roaming User C Documents and Settings lt usemame gt Application Data Quest Software ProductLicenses xml All Users C Documents and Settings All Users Application Data Quest Software ProductLicenses xml Toad for Oracle Editions Silent Installation Guide 18 Silent Installation Windows Vista Windows 2008 Windows 7 Local user C Users lt username gt A ppData Local Quest Software ProductLicenses xml Roaming User C Users lt username gt A ppData Roaming Quest Software ProductLicenses xml All Users C P
Download Pdf Manuals
Related Search