Spotlight on Oracle 10.4 - Release Notes

Toad DBA Suite for Oracle

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

1. Click the Spotlight button where it appears in Toad.
2. Spotlight on Oracle opens at the Oracle database connection associated with the Toad for Oracle connection.

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

• The Oracle database and username fields are pre filled in as per the Toad connection. Security requires that you re-enter your Oracle password.
• The default connection name is Toad followed by the name of the Oracle database. You may choose to replace this with any connection name of your choice. Note that a limitation of the integration of Toad with Spotlight on Oracle is that this is a new Spotlight connection, ignoring all other pre-existing Spotlight connections.
• You may choose a different Oracle username to connect to Spotlight. For example, in an environment with multiple database administrators there may be a communal username for Spotlight connections. Simply replace the filled in Oracle username with the appropriate Oracle username and password details.
• You can enter additional parameters to monitor ASM, the operating system and for virtualization.

Using Spotlight on Oracle

• Spotlight opens at the Home Page or Drilldown relevant to the location in Toad from where Spotlight was opened.
• You are prompted to create a new Spotlight user if the Oracle username has not been created in Spotlight. Oracle User Wizard
• This Spotlight connection can be found in the Spotlight Connection Manager. It can be managed the same as any other Spotlight connection. For example, you can close the connection, edit the connection details and re-open the connection in the Spotlight Connection Manager.

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.