Can I disable the filesystem check in Spotlight? (4246322)
Some of the fileystems I have on my database server listed with the comment: "access denied". ... That by itself is true because only the owner of the filesystem has access. ... How can I disable the filesystem check without disabling the complete OS monitoring?
Getting error when trying to add a new database in spotlight. (4335354)
The error is: ... success with compilation error ... PLS-01918: 9.2 and earlier wrap formats are not permitted in table SooBody ... ORA-04063: package body "SPOT.QUEST_SOO_SCHEMA_MGR" has errors ... ORA-06508: PL/SQL: could not find program unit being called: "SPOT.QUEST_SOO_SCHEMA_MGR"
'Range Check error' when connecting to the database in a direct connection in Citrix environment (4242523)
In a Citrix environment, when connecting to the database using a direct connection, the following error appears: ... The OCIDLL parameter may be incorrect, or there may be a corruption in TNSNAMES.ORA or an OCI-related DLL.
Which OS charts will be empty if the OS user does not have access to sar command? (4252149)
Which OS charts will be empty if the OS user does not have access to sar command? ... Spotlight on Oracle OS charts affected when "sar" is disabled on the host. ... The CPU Utilization chart on the "OS Performance" drilldown will not display the Waiting I/O area of the chart.
Error in alert.log: "ORA-00001: unique constraint (QUEST.PK_QUEST_PPCM_SQL_TEXT) violated" (4273483)
Unique constraint errors are showing up in alert.log for Spotlight objects. ... Errors in file /home/oracle/admin/instance/bdump/tlit_j000_23699474.trc: ORA-12012: error on auto execute of job 192
Connection is unable to find its OEM agent. (4280576)
On Spotlight home page, connection is unable to find its OEM agent, and archive log icon is grayed out. ... Another connection is having the same problem (but it's a DataGuard system).
Connection - Access to repository path has been denied (4306960)
When trying to connect to a database with the Spotlight on Oracle, getting the following error message: ... An unexpected problem has occurred in the connection "Connection-Name" It is recommended that you send a support bundle to Quest Software.
RAC connection keeps requesting user to install SoO objects into the schema over and over. (4337802)
When trying to create a connection to an Oracle RAC database, spotlight has an unexpected problem and wants to send information to support. ... When creating a spotlight user successfuly using the wizard, it keeps sending the user in the loop asking to create user.
ORA-04031: unable to allocate num bytes of shared memory num (4249580)
ORA-04031 unable to allocate shared memory error occurs when running user wizard in Spotlight. ... Cause: More shared memory is needed than was allocated in the operating system process. ... SGA private memory has been exhausted.
Is there a guide or best practice on setting up metrics / thresholds in a RAC environment? (4243450)
Is there a guide or best practice on setting up metrics / thresholds in a RAC environment? <p>There isn't a specific guide, or guidelines on setting up standard thresholds for alerts. ... Spotlight on RAC has many default alarms, you can find the details in the Help | Spotlight on Oracle RAC | Alarms section, however for some alarms, there are no pre-defined thresholds set up.
"ORA-00603: ORACLE server session terminated by fatal error" while attempting to refresh table Da (4332436)
The Oracle connection to TESTDB has failed with the error: ORA-00603: ORACLE server session terminated by fatal error while attempting to refresh table Datafile. ... Spotlight is attempting to re-establish this connection.
Error when launching Spotlight: "sox5010 : Notification 8 has the following error" (4267767)
When useri tries to start Spotlight, the following error message is shown: ... (B:\BuildArea\Running\SoO\6.0.0.1325\work\MDK\3\Plugins\SoO\6.0\Shared\Units\SoXTraceClasses.pas, line 143) ... 0042B46E (Spotlight.0002A46E)
Getting error "ORA-00918" when seeing Top Sessions from Oracle database 12.2.0.1 (4334010)
Getting error below when seeing Top Sessions from Oracle database 12.2.0.1:<br><br>ORA-00918: column ambiguously defined in table TopSessionsWithoutEvent Source: "RACTopSessionsWithoutEvent" table <p>This version of Spotlight on RAC is not certified with Oracle 12.2 as it came out before 12.2 did.<br><br>We'll certify the next Spotlight on RAC release (10.4) with 12.2.</p><p></p> <p>WORKAROUND</p><ol><li>Go to \Spotlight on Oracle \Plug-ins\SoO</li><li>Backup file sql12.dat </li><li>Replace it by the one attached at this KB</li></ol><p>STATUS</p><p>Waiting for fix in a future release of Spotlight on RAC</p> SOO-2605
Does Spotlight on Oracle support keyboard-interactive authentication? (4285327)
Spotlight on Oracle does not support keyboard-interactive authentication. ... As a result UNIX connection may display the following error, "SSH UNIX connection error: Login credentials are incorrect."
I would like more information about the Parse Activity Page (4332993)
I would like more information about the Parse Activity Page.Where can I find a detailed explanation? <p>The Parse Activity page displays information on SQL statements associated with high parse rates.<br>For more information please check the Spotlight on SQL Server help or click <a href=" https://support.quest.com/technical-documents/spotlight-on-oracle/10.1/getting-started-guide/parse-activity-page" target="_blank">here.</a></p>
Monitored databases are not seen neither in web interface not mobile application. (4278998)
There are several monitored instances in Spotlight Client, but neither of them can be seen in Spotlight Cloud even if the Diagnostic Server is configured properly with the correct credentials.
Blocking lock created while running Spotlight's job at night (4339733)
1. Open this ppcm connection; ... 2. Go to Spotlight Options -> Predictive Diagnostics -> Impending Bottlenecks Oracle job; ... 3. Change the default Interval value for this job from 30 minutes to 35 minutes or other value;
Do I need to have the Spotlight client opened for collecting of information? (4277894)
Spotlight Client is only GUI which displays information and provide interface for configuration.</p>
No buttons show up on "Verify Cluster Connect Details" dialog box (4267449)
When I create a new connection to a RAC instance, I get a "Verify Cluster Connection Details" dialog box. ... There are no buttons displayed on the box. ... The box lists all the nodes and wants you to map it to TNS entries of the individual instances.
Blank connection box when trying to connect with Spotlight on Oracle (SoO) or Spotlight on RAC ( (4320347)
Please make sure you have TNS_ADMIN setup within your registry before trying to connect.</p>
Error during connection: "Windows (WMI) connection error: Error 800706BA: The RPC server is unavailable" or "Error 800706BA: The RPC server is unavailable" or "Error 53: The network path was not found" (4240200)
Error happens in Windows connections or when monitor OS option is enabled for SQL Server connections. ... After verifying the following, the issue remains: 1. ... Try to connecting to server by using server name and by server IP address.
Why does Spotlight require execute privileges on dbms_system and dbms_job? (4267353)
Why does Spotlight require execute privileges on dbms_system and dbms_job? ... We're required to provide justification for security reasons. ... We use dbms_system.set_ev to set trace flags in other sessions.
Trace files not being generated (4267068)
When trying to put a level 8 trace on some of the top sessions, Spotlight is not tracing and we are getting these errors below: ... Failed to find trace file " xxxxx_ora_17562.trc" in directory "/u01/app/oracle/admin/xxxxx/udump".
Spotlight on RAC - monitoring of ASM (4326593)
There is a problem with communicating with the ASM, what is the additional step required to support ASM? ... The TNSNAMES entry for the ASM instance must include the option (UR = A) for the Spotlight connection to work properly.
Error returned for package QUEST_PPCM_COLLECTOR during installation of Predictive Diagnostic (4273261)
During installation of Predictive Diagnostic, wizard returned following error:<br><br>PACKAGE BODY (Line: 76)PLS 00103: Encountered the symbol 7 (QUEST_PPCM_COLLECTOR)<p><br></p> Create new database user for Predictive diagnostic and manually execute script in<br><br>{Spotlight on Oracle home}\Plug-ins\Ppcm\OracleScripts<br><br><br><br>For Oracle 11g R1 and lower: ppcm_upgrade_pre11gR2.sql<br><br>For Oracle 11g R2 and higher: ppcm_upgrade_post11.R2.sql<p></p>
新产品关联性