Category
Product Version
Topic
Subtopic
Manual install script to create the database objects for Spotlight on Oracle 4.5 / Spotlight on R (4277194)
Is there a manual install script for Spotlight on Oracle 4.5 and Spotlight on RAC 2.0? ... This is needed because 'O7_DICTIONARY_ACCESSIBILITY' is set to false and 'remote_login_passwordfile' is set to none, and the parameters cannot be changed.
What is PPCM job and how to turn off predictive diagnostic ? (4341713)
What is PPCM job and how to turn off predictive diagnostic ? ... PPCM is used for the feature to provide predictic diagnostic. ... The easiest way is to drop cascade that Spoltight user and create one without Predictive Diagnostic feature (assuming that that user is used for this Spotlight only).
Spotlight Unable to connect. Error: Oracle ASM connection error (4274970)
tns entry for ASM instance does not exist in tnsnames.ora file ... add tns entry for ASM instance in tnsnames.ora file (see sample tns entry attached)
Spotlight displays wrong Oracle Parameters "CHOOSE" (4335202)
Spotlight displays wrong value for optimizer_mode. ... Spotlight shows value as CHOOSE, while db shows a value of ALL ROWS.(see atachments). ... Customer is looking for the explanation since they don't know if all the information they are getting from spotlight are correct.
Error: "This TNS entry is a duplicate of another" (4272647)
When trying to connect in Spotlight on RAC, the user gets the error message: "This TNS entry is a duplicate of another" ... 2) If TNS entry is correct, please delete and re-create the connection profile.
Where do I download Spotlight on Oracle 7.1? (4267730)
Where do I download Spotlight on Oracle 7.1? ... To download Spotlight on Oracle v7.1: ... 1) Go to http://support.quest.com and login ... 2) Under "Go to Product Information Page" enter "Spotlight on Oracle" for the product and click "Go".
Access violation at address 0048E7C8 in module 'Spotlight.exe'. Read of address 00000004 (4339681)
Spotlight on Oracle 7.1.0.1481 - The following internalerror occurred: Access violation at address 0048E7C8 in module'Spotlight.exe'. ... The following internal error occurred: ... Access violation at address 0048E7C8 in module 'Spotlight.exe'.
Does Spotlight support jump servers to monitor the OS? (4266773)
Does Spotlight support jump servers to monitor the OS? ... Spotlight needs to be able to directly log into the database server via ssh or rexec in order to monitor the OS. ... Jump servers are not supported.
Cannot edit metrics in Spotlight on Oracle RAC (4260506)
After right-clicking the instance box in my RAC overview I selected metrics. ... My wish is to see and edit the metric settings for reported alarms. ... The instance metrics page comes up but there doesnnâ€t seem to be much I can do there except reorder things and the information in the Metric Help box is empty and so is the alarm help.
What is the difference between Toad DBA Suite for Oracle and Toad DBA Suite for Oracle - RAC Edit (4296286)
Do we need to install both? ... What are the different components or products that come with them? ... The Toad for Oracle product that comes in the Toad for Oracle DBA Suite and the Toad for Oracle DBA Suite - RAC Edition is actually the same.
Invalid license key on versions prior to 7.1 (4260301)
I am unable to apply my license key to Spotlight on Oracle versions prior to 7.1. ... If you were recently issued a license key, the format for license keys has changed for Spotlight on Oracle 7.1.
getting "no data" with the DTrace (4342022)
 ... From the man page for â€/etc/usr/attrrâ€, it looks like it should work but it doesn't
there may be a corruption in TNSNAMES.ORA or an OCI-related DLL (4334865)
Getting error when try to make new connection: ... The OCIDLL parameter may be incorrect, or there may be a corruption in TNSNAMES.ORA or an OCI-related DLL. ... The following error has been reported:
Prompted for ASM password on a non-ASM database (4266913)
I set up the user for Spotlight and am trying to launch it but it is asking for the ASM password. ... This is not an ASM database. ... You will be prompted for the ASM password if you have the "Monitor ASM" option checked in the connection profile.
Error after recent Microsoft patches: "soo5049 : The following error occurred in "<CONNECT (4267378)
After installing recent security patches that Microsoft released, and it appears to have broken Spotlight.<br><br>Im running the latest version 7.1.0.1481<br><br><br>Spotlight starts normally, but when I try to start a database connection I get this error:<br><br>soo5049 : The following error occurred in "<CONNECTION>" during connection:<br><br>Assertion failure (C:\Spotlight Console\MDK\2.0\Plugins\RepositoryLW\LightweightRepository.pas, line 822)<br> WORKAROUND 1<br><br>Delete and re-create the connection profile.<br><br>WORKAROUND 2<br><br>Delete the XML repository data by going to View | Options | History | Repository Management and click on the "Clear All" button.
Flashback Recovery drilldown is disabled (4257650)
Flashback Recovery drilldown is disabled/greyed on the Spotlight homepage. ... Flashback feature on the database is turned OFF. ... Run the following SQL statement on the monitored database to check if flashback is turned ON or OFF:
How to Completely Uninstall Toad Product Line (4317922)
How to completely uninstall all products in the Toad Product Line. <p>Please see attached file for detail on how to completely uninstall Toad Products below:</p><p>- Toad for Oracle</p><p>- Toad Data Point</p><p>- Toad for Sql Server</p><p>- Toad Data Modeler</p><p>- Toad for DB2</p><p>- Toad for SAP Solutions</p><p>- SQL Navigator for Oracle</p><p>- Benchmark Factory for Database</p><p>- SQL Optimizer </p><p>- Spotlight on RAC</p><p></p><p></p>
What does the Oracle User Wizard do? (4301407)
I am trying to run Spotlight on Oracle and the User Wizard is asking me to create a new user or re-configure an existing user. ... What does the wizard do with regard to the database user that is configured?
Can't download Spotlight on Oracle RAC (4330306)
Can't download Spotlight on Oracle RAC on the website. The link to download doesn't work. The installer for <span>Spotlight </span>on Oracle and Spotlight on RAC is the same one now.<br> Please download <a href="https://support.quest.com/spotlight-on-oracle/download-new-releases" target="_blank">Spotlight on Oracle</a> instead
What does the server limit in the license means? (4246073)
<div>What does the server limit in the license means?</div> <div>Server limit means that you are allowed to connect to the limited amount of database server at the same time. ... For example, if you have a server limit = 3, then you can connect to 3 database server at the same time.
Which versions of SSH are supported for the connection from Spotlight to the Unix? (4252447)
<div>Which versions of SSH are supported for the connection from Spotlight to the Unix?</div> <div>Spotlight supports SSH1 and SSH2 protocols.</div>
Is the Spotlight client supported on 64 bit machine? (4277229)
Is the Spotlight client supported 64 bit client machine? ... Receivedthe following errorwhile running Spotlight on 64 bit Windows: soo5072 :There was an error reading the tnsnames.ora .. ... On 32 bit Windows everything works fine.
How do I remove the Spotlight on Oracle Database user? (4328198)
As long as you have not reconfigured an existing database user, you can drop cascade the user from within the Oracle database you have used Spotlight on Oracle against. ... For those that have reconfigured an existing user, a drop script is attached called SoOdrop.sql.
ORA-03135 error while connecting to a database (4258936)
I'm getting ORA-03135 error while I'm trying to connect to a database ... You also can not connect to the same database with the same Oracle Home using SQL*PLus. ... ORA-03135: connection lost contact
The CPU, Avg CPU Load, Total RAM information missing in RAC monitoring. (4271176)
1. From Spotlight, disconnect from the RAC connection in question. ... 2. Pull up the Connection Manager buy clicking on the plug icon. ... 3. Go to your RAC section and right-click on RAC connection and choose Properties.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All