Select the database.
Notes:
Notes:
Click File | Connect
Select Spotlight on Oracle on the Connections menu.
Double-click Add new connection.
Fill in the connection Properties | Details page. Oracle Connection Details
Field | Description |
---|---|
Connection name |
This is the display name for the connection in Spotlight. Tip: Fill in the Connection String first. |
Oracle connection details
Field | Description | ||||||
---|---|---|---|---|---|---|---|
Connection String |
Select the name of the database that you wish to connect to. This field can be entered in one of the following ways:
Note: When selected, the Connection name field resets to this value. You can then edit the Connection name field if required. | ||||||
Oracle Username |
Enter the Spotlight Oracle user name. Oracle User Wizard Tip: If you enter a Username that does not exist, Spotlight will prompt you when you complete this dialog to create a new Spotlight user. 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. | ||||||
Oracle Password | Enter the Spotlight Oracle user password. Oracle User Wizard | ||||||
Oracle Home |
Select an appropriate Oracle Home. Select a location where Oracle client software is installed. Choose a home that contains a version of the Oracle client that is compatible with the Oracle server. For example, when using Spotlight to diagnose an Oracle 11g connection, use an Oracle Home that contains a sufficiently recent version of the Oracle client. Notes:
|
ASM is built into the Oracle database kernel. It simplifies the creation and space management in Oracle databases.
Note: Available only in Oracle 10g and later.
Field | Description |
---|---|
Monitor ASM | Select to monitor the performance of Oracle's Automated Storage Management (ASM) technology. |
ASM Connection String |
Enter the connection string required to link to the ASM database instance that is used for storage management for this Oracle database. Note: The TNSNAMES entry for the ASM instance must include the option (UR = A) for the Spotlight connection to work properly. |
ASM Password |
Enter the user password for Spotlight to login to the ASM database instance. The user that Spotlight uses to login to the ASM database is SYS. This is the only user name that can provide access to ASM-specific information. Providing SYS access to an ASM instance does NOT create a security issue for the Oracle database, but you should limit access to the SYS account to trusted individuals. Because the SYS password is stored in encrypted format, non-privileged users can still access Spotlight on Oracle. To do so:
|
Server connection details
Note: Requires Server connection details | Monitor OS selected.
Field | Description |
---|---|
Monitor ESX | Select to monitor the ESX Server that hosts the database. |
ESX Web Service | Type or select the URL of the ESX Web Service that manages the virtual machine. |
ESX Username |
Type the username required to connect to the ESX Web Service. Note: The username specified must have read only permissions for both the ESX virtual machine and the ESX host that the virtual machine resides on, or may reside on. |
ESX Password | Type the password required to connect the specified user to the ESX Web Service. |
Virtual Machine Name | Click ... to select the virtual machine. |
Click Save password details (for this connection) to save all the entered password details.
Look out for a warning or lock icon to the left of the Connect button. It might be telling you the connection to Oracle or ASM is encrypted. Click on the icon for details.
Note: (Oracle 11g Release 2 and above) The Configuring Oracle User for Spotlight Dialog will open when the setup of the Spotlight User through the Oracle User Wizard is incomplete.
Spotlight on Oracle connects to the Oracle database system through the Spotlight user.
Use the Oracle User Wizard to:
To open the Oracle User Wizard
The Oracle User Wizard runs automatically when required or to initiate it:
Click File | Oracle User Wizard.
Notes:
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
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. |
Oracle User Wizard | DBA Connection Credentials | User Account | Ready To Configure Oracle User | Configuring... | End
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center