Category
产品版本
主题
副主题
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.
How to setup email notifications. (4277191)
1.Select View | Options. ... 2.Select Alarms and Notifications | E-mail server. ... 3. Select the method that you want Spotlight to use when sending email ... Service Description ... Messaging Application Program Interface (MAPI) A standard Windows interface that you can use to send e-mail.
"An error has occurred in table (RAC)SortHash in connection ..." (4259061)
While trying to connect to a database the following error occur: ... This user may have been configured for an earlier version of Spotlight on Oracle (RAC), or Spotlight on Oracle (RAC) may not be installed.
Too many alarms are being produced, why? (4316586)
User is seeing too many alarms from Spotlight, even though the database is not having any abnormal activity. ... The initial calibration period was too short, meaning Spotlight did not calibrate an accurate picture of "normal" database activity.
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.
sox5073: Error received when parsing tnsnames.ora (4258784)
Spotlight on Oracle does not support the use of the IFILE parameter in tnsnames.ora. ... WORKAROUND ... User can commenting the IFILE path in the tnsnames.ora by following, and relaunch the Spotlight on Oracle.
Error: "ORA-01039: Insufficient privileges on underlying objects of the view" (4322617)
Error received when running an Explain Plan on certain queries in Spotlight on Oracle. ... ORA-01039:Insufficient privileges on underlying objects of the view" ... a. 'Certain' SYS-owned views that begin with x$, v$, or DBA_% cannot be explained even if the user is logged in as a DBA or SYS account.
SoO connection hangs if OS monitoring is included attempting to connect to the HP ITANIUM 11.23 (4291694)
The freeze occurs when connecting to SoO as a stand alone or when connecting to SoO from SoRAC with the OS option, ... The problem query appears to be "GetTNSadmin" which never completes its operation and therefore hangs the SoO connection.
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"
Spotlight on Oracle has problems accessing Linux OS (Operating System) when using SSH connection. (4324346)
When connecting Spotlight on Oracle to a database and setting the connection details to connect to the Operating System of a Linux computer, it does not show any OS details. ... The connection is being made via an ssh connection where Public/Private keys are required to be entered to gain access.
Unable to add new connection in Spotlight. (4312419)
Error encountered when trying to add a new connection: ... Message: An unexpected problem has occurred It is recommended that you send a support bundle to Quest. ... Click "Show details..." for more information about the problem.
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:
Can Spotlight on Oracle configure non-installing user to use existing objects, for example, Table (4249973)
Can Spotlight on Oracle configure non-installing user to use existing objects, for example, Tables, views, etc? ... No, Spotlight on Oracle will create a new set of objects when configuring non-installing user to connect to it.
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
新产品关联性