Return
-
Title
Setting up an Oracle connection with its host in Spotlight on Oracle -
Description
The information presented in the KB Article is a quick guide to setup an Oracle connection with its host. For details please consult the "Help | Content" or the Getting Start Guide from "Help | Getting Started." -
Resolution
Part I - Create the Spotlight userIt is recommended that a Spotlight User be created so that all the Spotlight objects are located in one schema and can be easily located or removed if need be.To create a Spotlight User run the wizard from "File | Oracle User Wizard" and follow the instructions from each step in the wizard. Each Oracle instance you want to monitor will require its own Spotlight user.Part II - Create the Oracle connection1. Go to "File | Connect" or by clicking on the power plug icon2. In the connection column (left side), choose "Spotlight on Oracle"3. In the center add-connection pane, click on "Add new connection"4. Fill in a user defined connection name or let Spotlight populate it with the TNS entry when selecting the "Connection String"5. Under "Oracle connection details" choose and fill in the following:a. Connection String - Choose the TNS entry form the drop downb. Oracle Username - This is the Spotlight User created in Part Ic. Oracle Password - This is the Spotlight User password sent in Part IPart III - Creating the ASM connectionIf ASM is setup and needs to be monitored, choose the "ASM Connection String" and fill in the password. If ASM doesn't need to be monitored, uncheck the "Monitor ASM" box or else, the "Connect", "Test", and "OK" button at the bottom will be grayed out and the connection setup will not be allowed to proceed.Part IV - Creating the server connectionThe main thing to point out is that the type of OS (UNIX or Windows) will need to be properly selected. An OS login is also required. If the OS doesn't need to be monitored, uncheck the "Monitor OS" box or else, the "Connect", "Test", and "OK" button at the bottom will be grayed out and the connection setup will not be allowed to proceed.Note: If OS isn't being monitored, the CPU info will not be present when monitoring Oracle