Spotlight is ready to change the Oracle database.
Option | Description |
---|---|
Next | Click to create / update the Oracle User based on the settings entered in the Oracle User Wizard. |
Back | Click to return to previous pages in the Oracle User Wizard, to edit the settings. |
Cancel | Click to close the Oracle User Wizard. No changes will be made. |
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
The Spotlight user has been configured successfully.
Option | Description |
---|---|
Go to Connection Manager |
Select to connect to the target database as the user you have just created or setup. Connect to an Oracle Database |
Launch {user} after closing |
Select to connect to the target database as the user you have just upgraded. |
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
Note: This dialog is applicable to Oracle 11g Release 2 and above.
This dialog will open from Spotlight Browser | All connections or the Connection Details dialog when selecting to monitor an Oracle or Oracle RAC connection, and the setup of the Spotlight User through the Oracle User Wizard is incomplete.
Field | Description |
---|---|
Install Objects in my schema |
Click to install Spotlight objects in your schema. This automates the running of the Oracle User Wizard up to Predictive Diagnostics Settings if you have DBA privileges. If you do not have DBA privileges you will be prompted for a DBA login. |
Configure another user | Click to configure another user to connect to this Oracle instance. To complete these steps you require SYS DBA privileges. |
Show connection details |
Click to view or edit the connection details. Open the Connection Details dialog. |
View information about objects installed and privileges required by spotlight | Click to open the Spotlight on Oracle Database Objects and Privileges document. |
Note: This section is relevant for systems with the following software installed: Toad DBA Suite for Oracle with Spotlight on Oracle.
To connect to an Oracle database from within Toad
The first time you open the Oracle database connection from within Toad
You are required to fill in the Details page with the following additions. Oracle Connection Details
Using Spotlight on Oracle
Caution: When you click on the Spotlight button in Toad to connect to the Oracle database, a new Spotlight connection to the Oracle database is created, regardless of any pre-existing Spotlight connections to the Oracle database. To avoid the annoyance of setting up Spotlight connections in Spotlight that will be set up identically through Toad later, you may choose to create all connections through Toad if Toad integration is desired.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center