Code Tester for Oracle 2024 R2 - Installation Guide

Removing a Repository

You can remove a repository from Code Tester if required.

Important!

• Removing a repository removes all test definitions that are stored in that repository.
• Only a user with the CTO_ADMIN_ROLE role can remove a repository.

To remove a repository

1. Select All Programs | Quest Software | Code Tester for Oracle version | Administration | Remove Repository. The Uninstall Repositories dialog displays.

2. This window displays the names of any schemas into which Code Tester repository was installed from this workstation. If you do not see the schema from which you wish to uninstall Code Tester, do the following:

   1. Click Add New Schema. The Provide schema information dialog displays.
   2. Provide the schema name, password, and database name.
   3. Press Next to add this schema to the grid.
   4. Repeat as many times as necessary.

3. In the Password column of the grid, type the password and then verify the repository version.

   Note:Delete Schema deletes the schema from the grid but does not delete the schema from the database.

4. Click Next. The Confirm deinstallation dialog displays.
5. Select Yes, I want to remove the selected repositories check box.
6. Click Next. The repository uninstalls and the Finished dialog displays.

Managing the Repository

From Code Tester for Oracle Repository Manager, you can:

• Rebuild the Code Tester backend
• Provide instance-wide access to Code Tester
• Restrict access to Code Tester to a single schema

To access the Repository Manager

1. Click the Start button from the Windows task bar.
2. Select All Programs | Quest Software | Code Tester for Oracle version | Administration | Repository Manager. The Code Tester Repository Wizard displays. The following options are provided:
   • Rebuild Code Tester Backend
   • Provide instance-wide access to Code Tester
   • Restrict access to Code Tester to single schema

Note: The following three procedures require that you begin from the Code Tester Repository Wizard dialog.

Rebuilding the Code Tester Backend

This option reinstalls all Code Tester backend packages from disk.

To rebuild the Code Tester backend

1. Click the Rebuild Code Tester backend radio button.
2. Click Next. The directory and login information dialog displays.
3. Enter the User Name.
4. Enter the Password.
5. From the Database drop-down, select the desired database.
6. Click Next. The backend rebuilds. This will take several minutes. When the rebuilding process completes, the Finished dialog displays.
7. Click Finish.

Providing Instance-wide Access to Code Tester

This option creates public synonyms for Code Tester objects in the connected schema.

To provide Instance-wide access to Code Tester

1. Click the Provide instance-wide access to Code Tester radio button.
2. Click Next. The directory and login information dialog displays.
3. Enter the User Name.
4. Enter the Password.
5. From the Database drop-down, select the desired database.
6. Click Next.
   • If no installation issues are detected, instance-wide access will be granted.
   • If installation issues are detected, the Repository installation issues dialog displays. Review the issues displayed and click Back to select another schema, or fix the issue presented. Or, click Ignore missing privileges and continue by clicking Next.
7. Click Finish when the processing completes.

Restricting Access to a Single Schema

This option removes public synonyms for Code Tester objects from the connected schema.

To restrict access to Code Tester

1. Click the Restrict access to Code Tester to single schema radio button.
2. Click Next. The Provide directory and login information dialog displays.
3. Enter the User Name.
4. Enter the Password.
5. From the Database drop-down, select the desired database.
6. Click Next. The restrictions are applied.
7. When the processing completes, click Finish.

Uninstalling Code Tester for Oracle

To remove Code Tester for Oracle, use the Programs and Features option of the Windows Control Panel.

1. Click the Start button from the Windows task bar, then select Control Panel.
2. In the Control Panel, select Programs and Features.
3. Right click Code Tester for Oracle version, then select Change.
4. Click Next on the first page of the wizard.
5. Select Remove.
6. To remove the repository at this time, select Remove Code Tester database repository.

7. This window displays the names of any schemas into which Code Tester repository was installed from this workstation. If you do not see the schema from which you wish to uninstall Code Tester, do the following:

   1. Click Add New Schema. The Provide schema information dialog displays.
   2. Provide the schema name, password, and database name.
   3. Press Next to add this schema to the grid.
   4. Repeat as many times as necessary.

8. In the Password column of the grid, type the password and then verify the repository version.

   Note:Delete Schema deletes the schema from the grid but does not delete the schema from the database.

9. Click Next. The Confirm deinstallation dialog displays.
10. Select Yes, I want to remove the selected repositories check box.
11. Click Next. The repository uninstalls and the Finished dialog displays.