Categoria
Versione prodotto
Argomento
Argomento secondario
Install Toad and Spotlight on a different computer (4377766)
From a licensing perspective, is it possible to install each tool on a different computer?" ... Yes, that is possible. ... Please run the Toad for Oracle installer in both computers and select the tools you want to install on each one of them.
Spotlight query on v$latch is executed several times in the database. Why does Spotlight run this query? (4330460)
It is noticed that the Spotlight Query below is run a lot of times on the server. ... What is this query for? ... SELECT l.latch#, l.gets, l.misses, l.sleeps, l.immediate_gets, l.spin_gets, COUNT ( * ) n_latches
Does Spotlight on Oracle supports autonomous Database monitoring? (4374452)
Does Spotlight on oracle supports autonomous Database monitoring? ... An autonomous database is a cloud database that uses machine learning to automate database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs.
How to export diagrams graph from drilldown where there is no safe button? (4375898)
Customers report certain dashboard do not show a save icon and wonder how to export the diagram graphs. ... The only way export the graph is to take a screenshot from outside the application.
How to make spotlight on Oracle run from the startup? (4374040)
Customers inquire about why spotlight on oracle does not run as a service and if its possible to run it automatically from windows startup. ... Spotlight on Oracle is an application, not designed to run in the background as a service.
New Metric for I/O Service Time (4273673)
Backup {Spotlight on Oracle folder}\Console\Templates\SoU.STX to another folder (make sure it is backed up to a folder outside Spotlight folders)</div><div>3. ... Copy the attached file to this folder;</div><div>4.
Error: "An error has occurred in table SortHash in connection ..." when connecting to a database. (4250261)
Error received while connecting to database: ... User is trying to connect to Spotlight with a non Spotlight user. ... Enter and connect to Spotlight on Oracle with a Spotlight's user: ... 1. Launch Spotlight.
Error: "soo5049 - ORA-12154: TNS: could not resolve the connect identifier specifier." (4322563)
This error usually occurs when there is a 10g client with other multiple Oracle homes on the client PC whether these are known to exist or not. ... Sometimes the Oracle clients are not removed completely and Spotlight detects them in the registry.
Error: "This profile appears to have load balancing set on. It cannot be diagnosed due to potenti (4234755)
Spotlight installed on a cluster with loading balancing will give the following error when connecting: ... "This profile appears to have load balancing set on. ... It cannot be diagnosed due to potential problems with failover"
Error: "An error occurred while refreshing the table "GetTNSAdmin" in connection" with Spotlight (4291657)
Error received when making a connectation to an Oracle 10.2 from Spotlight on Oracle 4.0.2: ... 1. Oracle client 10.2 is required for Oracle 10.2. ... 2. Recreate the connection from Spotlight connection properties after ensuring Oracle Home and Tnsname entry is set correctly.
Error when trying to connect to database via the Oracle User Wizard: "Spotlight connections runni (4287272)
When upgrading to the latest version of Spotlight on Oracle, I encounter a message to upgrade the Spotlight user account via the Oracle User Wizard prior to connecting to the database. ... When I attempt to upgrade the Spotlight user account via the Oracle User wizard by selecting "Reconfigure <userName> for use with Spotlight", the following error occurs:
ORA-12154 - TNS:could not resolve service name (4260330)
While trying to open a database connection the following error occurred: The following error occurred while connecting to "connection name" ORA-12154 - TNS:could not resolve service name ... The sqlnet.ora parameter NAMES.DIRECTORY_PATH was set to ONAMES.
Spotlight query high CPU cost (4232025)
Queries taking too long to run may cause performance issues. ... This is due to setting optimizer_mode=first_rows for all queries using v$parameter ... Setting optimizer_mode=first_rows, causes all queries using v$parameter to take a long time.
Error: "Oracle client you're using is not reliable when connecting to a 10g we recommend you upgr (4258085)
"Oracle client you're using is not reliable when connecting to a 10g we recommend you upgrade to oracle 10g release 2..." ... B) Trying to connect Spotlight on Oracle to Oracle 10gR2 database with earlier version than Oracle client 10gR2.
Error 32: The process cannot access the file as this is already used by another. (4315765)
Getting "The following error occurred Error 32: The process cannot access the file as this is already used by another" when using Spotlight on Oracle RAC. ... The problem is being caused by the virus scanner running on your desktop.
Error message showing that the template file xxx could not be found (4313743)
when configure the monitoring for a RAC DB, it displayed "the template file xxx could not be found <span></span> <p>WORKAROUND</p><p><span>1.Open Spotlight folder ..\Spotlight for Oracle 10.9.0\Console\Template</span><br><span>2.Copy and paste SpotlightOnOracle.stx in the same folder;</span><br><span>3.Rename the new file "SpotlightOnOracle - Copy.stx" to " SpotlightOnOracle_CHS.stx "</span><br><span>4.Open the RAC connection.</span></p><p><span>STATUS:</span><br><br><span>Waiting for fix in a future release of Spotlight on RAC/Spotlight on Oracle.</span></p> TMB-3637
How to download a commercial software installer? Need installer by FTP or mail. (4290597)
In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. ... Steps to download a commercial product:
Upgrading or creating new Spotlight objects causes invalid objects MakeXView, build_xview,quest_s (4287448)
Upgraded Spotlight on Oracle from SoO4.0.4 to SoO4.5.1 and are prompted to upgrade objects when connecting to database. ... However, when trying to upgrade database objects, we get "An error has occurred in table MakeXView" message
How to setup email alert? (4284126)
How to setup email alert in Spotlight on Oracle? ... To setup email alerts (or alerts generally), go to View | Options and there select the Alarm action option under the Alarms and notifications section.
SYS.BUILD_XVIEW error while creating/upgrading Spotlight database user (4252218)
While creating or upgrading the Spotlight database user the following error occurs: ... Set the Oracle parameter PLSQL_CODE_TYPE to INTERPRETED. ... INTERPRETED is the default value. ... Use the Oracle command ALTER SYSTEM or ALTER SESSION to change the parameter.
Intermittently freezes, cpu reaches 100% and application becomes Not Responding. (4323309)
Spotlight on Oracle would intermittently freeze, cpu reaches 100% and application becomes Not Responding. ... This could happen with or without StealthCollect. ... Usually occurs for a heavy loaded databases
Error during connection in User Wizard: "Range check error" (4223532)
Please ensure the Oracle Client software is properly installed. ... The following error has been reported: Range check error"</p> Spotlight was installed by a different Windows user. ... Run Spotlight as the same user used to install the application.
How to display more than a day worth of graph data? (4275152)
Spotlight allows data to be stored for indefinite amount of time but the graphs only display a day worth of data. ... Can the graph be adjust to display for a greater period of time? <div>Due to present architecture which limits the real estate available, to display a graph with more than a day worth of data might not present anything real meaningful.
No data for 8K buffer (4339765)
Under memory & Config, Buffer Cache there is no data displayed for the 8k buffer under Buffer Cache Details.
ORA-01861: literal does not match format string in table ArchivedLog (4267812)
On the home screen, the flow indicators from RedoLogs to Archiver Process to Archive Log Destination is grayed out and I get an error message on Spotlight startup. ... ORA-01861: literal does not match format string in table ArchivedLog
Associazione di nuovi prodotti
- Strumenti self-service
- Knowledge Base
- Notifiche e avvisi
- Supporto prodotti
- Download di software
- Documentazione tecnica
- Forum utente
- Esercitazioni video
- Feed RSS
- Contatti
- Supporto tecnico
- Visualizza tutto