Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

The Registry ... is not accessible.

On connecting to a Windows machine, if Spotlight returns the following error:

The registry on "<<MachineName>>" is not accessible. You need to connect to this machine with an account with privileges to retrieve server information, query the registry, and access performance monitor objects.


Login to the Windows machine using an account with administrative rights.

A login with administrative rights satisfies the requirements of Spotlight on Windows, with the privileges to retrieve server information, query the registry, and access WMI and performance monitor objects.


Related Topics

Connecting As The Logged-in User

To connect to a Windows machine as a user who is already logged in, do NOT enter any user credentials (Domain, User or Password) in the Connection Properties window.


  • Spotlight on Windows requires Administrator access on all the Windows machines under diagnosis. If the current user is not an administrator on a machine, that Spotlight connection will fail.
  • Windows connections can only have one set of credentials in use at a time. If a user connects to a machine by using NO user name and password, and then disconnects and reconnects with an Administrator password, Windows returns an ERROR_SESSION_CREDENTIAL_CONFLICT error.

    For example, if you have mapped a drive to the machine \\serverA\share while logged in as serverA\administrator, you CANNOT map another drive to the same machine while logged in as serverA\user.

    You can, however, connect to the same machine with different credentials if you map to the machine via its IP address.

    In the example above, if serverA has the IP address, you CAN employ the net use command to connect to the machine \\\share as serverA\user.


Related Topics

WMI Connection Problems

If Spotlight on Windows is displaying a WMI access denied error, and the user specified in the connection profile is an administrator on that machine then it may be necessary to adjust your DCOM or Firewall settings.

Complete the following steps to ensure that your DCOM and Firewall settings are configured to allow WMI connections.

To test WMI is working on the Spotlight client:

  1. Click Start | Run.
  2. Enter WBEMTest to run the WMI Tester Utility.
  3. Click Connect | Connect.
  4. If an Access is denied error is displayed you do not have rights to make WMI connections. In this case, check (and adjust if necessary) your local DCOM setting (see below).

To check the DCOM access permissions for the monitored machine:

  1. Login to the monitored machine.
  2. Click Start | Run.
  3. Enter DCOMCnfg to run the DCOM configuration utility.
  4. Select Component Services.
  5. Click .
  6. Click COM Security.
  7. Under Access Permissions, click Edit Permission.

    Ensure Remote Access is set to Allow for the user specified in the connection profile (or the group containing this user).

  8. Under Launch and Activation Permissions, click Edit Permission.

    Ensure Remote Launch and Remote Activation are set to Allow for the user.

    For more information, see Securing a Remote WMI Connection on the MSDN site.

To check if Windows Firewall is active on the Spotlight client:

  1. Open the Control Panel | Windows Firewall.
  2. If Windows Firewall is on, see Connecting Through Windows Firewall on the MSDN site for information on how to configure the firewall to allow WMI connections.


Related Topics

Spotlight on Oracle

Cannot Connect to Database

Possible cause… Solution…
Oracle is not running.

Verify that the Oracle instance is running and can be accessed from a host or client workstation.

The connect string and alias of the database are incorrect or have changed.

Check your SQL* Net configuration and verify the connect string and alias you are using are correct.

The user ID you are using to log into Spotlight does not exist in the database.

Run the User Wizard to establish the user ID in the database.

The Spotlight user has the wrong permissions in the database. Contact your DBA to add relevant permissions to the user.
Spotlight takes too long to open the Oracle connection so it appears to be unable to connect.

Turn on Fast Initialize.

  1. Click View | Options.
  2. Select Data Collection | Oracle Initialization | Turn Fast Initialize on.
  3. Restart Spotlight.

Cannot Connect to ASM

When installed and available, Automatic Storage Management (ASM) stores Oracle data in a separate ASM database instance. Spotlight on Oracle displays performance metrics for ASM on the home page and in the ASM drilldown.

If the database under investigation uses ASM but Spotlight cannot connect to it to retrieve the required information, you may need to edit the TNSNAMES entry for the ASM instance.

  1. Locate the tnsnames.ora file in Oracle’s network/admin sub-folder of the Oracle installation folder on your Spotlight client.
  2. Edit tnsnames.ora so that the TNSNAMES entry for the target ASM instance contains the option (UR = A).


Related Topics

Troubleshooting Spotlight on Windows

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating