Code Tester for Oracle 2024 R2 - Installation Guide

Schema Privileges

The schema in which you install Code Tester must have the following privileges:

ALTER SESSION

CREATE PROCEDURE

CREATE SEQUENCE

CREATE SESSION

CREATE SYNONYM

CREATE TABLE

CREATE TRIGGER

CREATE VIEW

CREATE TYPE

Note: Some tests will require the creation of an object type and nested table type, so you may need to add a CREATE TYPE privilege to an account.

Please note the following:

• If requested, Code Tester creates a schema with the necessary privileges as part of the installation process.
• We recommend that you install Code Tester into its own schema, and create public synonyms so that all developers will be able to use Code Tester and share their test definitions. This will also help you keep application code distinct from the Code Tester code base. To do this, your schema must also have CREATE and DROP PUBLIC SYNONYM privileges.
• You may need additional privileges to test certain kinds of objects, such as files and cursor variables. If such a schema is not yet available, you will need to ask your DBA to connect to a SYSDBA account to create that schema (this can all be done from within the Code Tester installer; see the release notes to get started). 

Note: If you have not previously installed utPLSQL, then the qu_utplsql_api package will be marked invalid. Code Tester will not use this package unless utPLSQL has been installed and you want to run utPLSQL test packages.

Required Schema Packages for Code Tester Installation

The following Oracle packages are required to install Code Tester for Oracle:

SYS.DBMS_UTILITY

SYS.DBMS_DESCRIBE

SYS.DBMS_LOB

SYS.DBMS_RANDOM

SYS.DBMS_SQL

XDB.DBMS_XMLDOM

XDB.DBMS_XMLPARSER

XDB.DBMS_XSLPROCESSOR

When installing Code Tester where these packages not are accessible, you will receive the following message:

Code Tester for Oracle cannot be installed successfully because this schema does not have access to the following packages: xxx... Please contact your DBA to obtain access to these packages

Obtain the required permissions and continue with the installation procedures.

Installing Code Tester for Oracle

These instructions install Code Tester and, optionally install the required database repository. You can install the repository now or at any time after the installation by running the Install or Upgrade Repository wizard. For more information, see Toad provides a wizard for creating a new repository if you did not create one when you installed Code Tester. This wizard can be run at any time after Code Tester is installed..

To install the repository while you install Code Tester, have the following ready:

• Connection information for the database
• Login credentials of a user who can create new users (if you want to install into a new schema) and the credentials you want to use for the new user.

To install Code Tester

1. Double-click the Code Tester for Oracle installer. The Code Tester for Oracle setup wizard displays.
2. Click Next. The licenses agreement displays.
3. Read the licenses agreement and click the I accept the terms in the license agreement radio button.
4. Click Next. The Destination Folder dialog displays. Accept the default location or change it, then click Next. The Install Database Respository dialog displays.

5. By default the installer will run the repository wizard after it installs Code Tester. This gives you the opportunity to install the required repository immediately (or upgrade an existing one). If you do not want to install or upgrade the repository at this time, deselect Install or Upgrade Code Tester database repository.

6. Click Next. The Ready to Install dialog displays.
7. Click Install. The Installing Code Tester for Oracle dialog displays.

8. After installation completes, one of the following is shown, depending on whether or not you are installing the repository:

   • Launch Code Tester and exit the installer. Select your options on this page, then click Finish.
   • The Repository Installation wizard is launched. To install the repository, continue to To install the repository.

To install the repository

1. On the Repository installation dialog, select the options as desired:
   • Install into or upgrade existing user schema: Installs the repository into an existing schema.
   • Create new user and install into new user schema: Creates a new database user and then installs the repository into that schema.
   • Uninstall existing Quest Code Tester repository first: This is active only if you selected an existing schema. Select this option if you want to uninstall the existing repository before installing the new one.
   • Create public synonyms after installation: Select this option to provide access to Code Tester from any schema in this instance. If you do not create synonyms, then you can only access this installation of Code Tester from within the Code Tester schema (usually the same schema as the application code).

2. Click Next. One of two possible connection dialogs is displayed.

3. Provide one of the following:

   • If you are installing into an existing schema, provide the user name and password for the existing schema, then select the database and connection method.
   • If you are installing into a new schema, provide the user name and password of a user that has the privileges to create the new user and schema, then select the database and connection method.
4. Click Next.
5. (If you are installing into an existing schema, skip this step.) If you are installing into a new schema, the Provide New Schema Information dialog is displayed. Provide the name and password of the new user and (optional) select storage attributes.
6. Click Install. The installation completes and you are notified of the results.

IMPORTANT: If you did not install the repository, you can do so at any time by running the Install or Upgrade Repository wizard in the Administration folder of your Code Tester installation. You must install a repository to use Code Tester. For more information, see Toad provides a wizard for creating a new repository if you did not create one when you installed Code Tester. This wizard can be run at any time after Code Tester is installed..

Silent Installation

For Windows 7 and 2008, you must open the "command prompt" as the administrator to get permission to run the install.

Code Tester for Oracle provides silent installation for frontend client only installs.

The following provides procedures for command line silent installation:

The command line for silent installation is:

msiexec /i Code TesterCodeTesterOracle_3.0.0.XXX.msi/qn INSTALLDIR="<Installation Directory>"

If option INSTALLDIR="<Installation Directory>" is ommited then QCTO will be installed in the default directory:

<Install Directory> is a destination directory for QCTO installation.

Examples:

msiexec /i Code TesterCodeTesterOracle_3.0.0.XXX.msi /qn

The Code TesterCodeTesterOracle_3.0.0.XXX.msi located in the current directory will be installed in the default directory: c:\Program Files\Code Tester Software\Code Tester for Oracle.

msiexec /i "c:\My Files\Code TesterCodeTesterOracle_3.0.0.XXX.msi " /qn INSTALLDIR="c:\TEMP\MyWork

The c:\My Files\Code TesterCodeTesterOracle_3.0.0.XXX.msi will be installed in the directory "c:\TEMP\My Work".

Silent Uninstall

The following command performs the silent uninstall for Code Tester for Oracle.

msiexec /x Code TesterCodeTesterOracle_3.0.0.XXX.msi /qn

Installing a New Repository

Toad provides a wizard for creating a new repository if you did not create one when you installed Code Tester. This wizard can be run at any time after Code Tester is installed.

1. Select All Programs | Quest Software | Code Tester for Oracle version | Administration | Install or Upgrade Repository. The Code Tester Repository Wizard displays.
2. Select Install new Quest Code Tester repository, then click Next.
3. On the Repository installation dialog, select the options as desired:
   • Install into existing user schema: Installs the repository into an existing schema.
   • Create new user and install into new user schema: Creates a new database user and then installs the repository into that schema.
   • Uninstall existing Quest Code Tester repository first: This is active only if you selected an existing schema. Select this option if you want to uninstall the existing repository before installing the new one.
   • Create public synonyms after installation: Select this option to provide access to Code Tester from any schema in this instance. If you do not create synonyms, then you can only access this installation of Code Tester from within the Code Tester schema (usually the same schema as the application code).

4. Click Next. The connection dialog is displayed.

5. Provide one of the following:

   • If you are installing into an existing schema, provide the user name and password for the existing schema, then select the database and connection method.
   • If you are installing into a new schema, provide the user name and password of a user that has the privileges to create the new user and schema, then select the database and connection method.
6. Click Next.
7. (If you are installing into an existing schema, skip this step.) If you are installing into a new schema, the Provide New Schema Information dialog is displayed. Provide the name and password of the new user and (optional) select storage attributes.
8. Click Install. The installation completes and you are notified of the results.

When all of the installation scripts have been run, Code Tester will validate your installation and notify you of any problems.

Upgrading a Repository

You can upgrade a repository to a newer version by running the installation script and selecting an existing schema. You will do this by choosing the upgrade path offered in the installer. The installer will then automatically apply any necessary changes to your current installation to bring it up to the new version.

IMPORTANT! Only a user with the CTO_ADMIN_ROLE role can perform an upgrade to the repository.

To upgrade a repository

1. Select All Programs | Quest Software | Code Tester for Oracle version | Administration | Install or Upgrade Test Repository. The Code Tester Repository Wizard displays.
2. Select Upgrade existing Code Tester repository.
3. Click Next. The directory and login dialog information displays.
4. Enter the required parameters.
5. Click Next. The Upgrade Code Tester Repository dialog displays.
6. Click Next. The repository upgrades. When the upgrade completes, the Finished dialog displays.
7. Click Finish.