How to upgrade Spotlight on Oracle user from old version to new version (4305808)

How to upgrade Spotlight on Oracle user from old version to new version

 

Prior to install/upgrade, please check the system requirements from the Release notes.

 

There is no upgrade process actually as you can install any number of Spotlight of different versions in one machine. When the new version is installed then launched, the user will be asked to "Upgrade or create new Spotlight user". Just follow the wizard.

 

The Getting Started guide has the steps to install:

https://support.quest.com/spotlight-on-oracle/technical-documents

 

To install Spotlight from the downloaded installer from the Support Portal:

1. Close all open applications on your PC.

2. Execute the downloaded installer.

3. Follow the instructions on the screen to complete the installation.

 

Note: To cancel installation at any time, press Esc or click Cancel. If Spotlight is delivered as part of the Toad DBA Suite and you require multiple Spotlight

installations on your computer then contact Quest Software for more information.

 

OLD SOLUTION FOR version 3.6: PROBLEM DESC: We are using Spotlight on Oracle 3.6 on old PC and have a new PC and installed the latest version of Spotlight on Oracle and need help upgrading objects. RESOLUTION: The Spotlight objects can be upgraded using the Oracle User Wizard by clicking File | Oracle User Wizard on the Spotlight menu bar and then following the wizard. However, it is sometimes worthwhile to re-create the object rather than upgrading (ie if there is a significant difference in version levels) In the case where there is a significant difference in version levels and the Spotlight user account is used only for Spotlight, it would be best to drop cascade the Spotlight user and create a new Spotlight account using the Oracle User Wizard (from the Spotlight menu bar click File | Oracle User Wizard)