Spotlight on Oracle 10.8 - Getting Started Guide

Add a new user to the Oracle database
Convert the account of an existing user on the Oracle database to use Spotlight
Reconfigure an existing Spotlight user to work with new versions of Spotlight on Oracle and Spotlight on Oracle RAC. Use this procedure if you have upgraded your version of Spotlight.

To open the Oracle User Wizard

The Oracle User Wizard runs automatically when required or to initiate it:

Click File | Oracle User Wizard.

Notes:

Select Don't show this page in future to hide the first page of the Oracle User Wizard.
Spotlight users must be configured for each database they are to diagnose.
You cannot configure Spotlight users for a database while Spotlight is diagnosing that database.
You must have the user ID and password of the DBA that manages the database to which you are adding the Spotlight user.
You should not use any system accounts. We recommend creating a separate user for Spotlight or using a personal account.
The Spotlight user must have sufficient privileges, views, and tables to diagnose the Oracle database. You can view the privileges, views and tables required by Spotlight users in the Database Objects and Privileges document in the Spotlight installation folder: \Console\Help\.

Connect to an Oracle Database

DBA Connection Credentials

Connect to the Oracle database via an account that has DBA privileges.

Field	Description
Enter the SQL*Net connection string…	Enter the database instance on which you wish to create the user.
Enter the user name of a DBA account…	Enter a DBA user name for that database instance (so that the Spotlight user and the relevant objects can be created). The user name requires SYSDBA access.
Enter the password…	Enter the DBA user password.

User Account

Select one of the available options.

Field	Description
Create a new user	This user does not have an Oracle account on the database. Create a new Oracle user that Spotlight can use to connect to the database.
Set up an existing user	The user has an Oracle account on the database, but has not been configured to use Spotlight on Oracle. Use this option if there is an existing account on the target Oracle database that you want to use when connecting via Spotlight on Oracle.
Reconfigure "user" for use with Spotlight	(Available when a new version of Spotlight on Oracle has been installed.) Use this option if you want to connect to an Oracle database as a user that was set up within a previous version of Spotlight on Oracle. Note: This option is available only if Spotlight detects that the current user has been configured using an earlier version of Spotlight on Oracle.

Field

Description

Create a new user

This user does not have an Oracle account on the database.

Create a new Oracle user that Spotlight can use to connect to the database.

Set up an existing user

The user has an Oracle account on the database, but has not been configured to use Spotlight on Oracle.

Use this option if there is an existing account on the target Oracle database that you want to use when connecting via Spotlight on Oracle.

Reconfigure "user" for use with Spotlight

(Available when a new version of Spotlight on Oracle has been installed.)

Use this option if you want to connect to an Oracle database as a user that was set up within a previous version of Spotlight on Oracle.

Note: This option is available only if Spotlight detects that the current user has been configured using an earlier version of Spotlight on Oracle.

Note: You should not use any system accounts as your Spotlight user account. We recommend creating a separate user for Spotlight or using a personal account.

Note: (Oracle 12c) As per Oracle guidelines, the Spotlight Oracle user needs to be of the form “c##<username>” when connecting to an Oracle 12c Container database.

New Oracle User

When you create a new Oracle account for use with Spotlight on Oracle, you need to supply a user name and password for that account.

The additional options specified on this page give the Spotlight user greater access to the database. If you want to grant the additional privileges, select the Select any table and Alter system options.

Field	Description
User name	Enter a name for the new user. You can type up to 30 characters. The first character of the user name must be a letter. Note: (Oracle 12c) As per Oracle guidelines, the Spotlight Oracle user needs to be of the form “c##<username>” when connecting to an Oracle 12c Container database.
Password	Enter a password for the new user. You can type up to 30 characters.
Confirm password	Confirm the password. The password exactly as you typed it in the Password field.
Select any table	Select to allow the user to generate explain plans for SQL statements created by other users.
Alter system	Select to allow the user to trace and terminate sessions.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on Oracle 10.8 - Getting Started Guide

Oracle User Wizard

DBA Connection Credentials

User Account

New Oracle User