After setting the default credentials for the host, these newly created credentials can now be used by the Connection Details wizard to attempt to log in to the instances.
This video is applicable for Foglight 5.6.11 and higher
Please refer to KB 4310893 for details on opening the Databases Administration Dashboard
1. From the Oracle Administration page, choose the Connection Details option and click Test Connection.
The Verifying Connectivity progress bar appears. At the end of this process, any connectivity issues are listed in the Status column of the instance table. When the connection is successful, the Status column displays the status message Validated, which indicates that the instance connected successfully and the specified Oracle user has the required permissions.
If the connection failed verification, the Status column displays one of several connectivity status messages.
The messages, causes, and appropriate responses are:
Use this dialog box to specify a SYSDBA (System Database Administrator) user with sufficient privileges.
Type a SYSDBA user and password, and then click Grant.
After correcting the mistakes that resulted in the connectivity failure, click again Test Connection.
2. Click Test Connection on the status bar.
3. Once the validation completes, click Save Changes.
The Applying Modified Settings progress bar appears to save any changes from the validation.
NOTE: As there are seem to be ten concurrently used to validate agents, Support recommends validating agents in small groups of ten or less. This will reduce the change of timeouts, particularly if other users might be making changes to agents in the system at same time as the validation of agents are queued up.
2 If the option to edit the host connection details is selected, select whether to disable OS monitoring, which is enabled by default.
3 Specify the requested authentication type:
4 If any option other than Agent Manager local user is selected, enter the required credentials.
* IMPORTANT: If either of the UNIX authentication types is selected, to run certain commands that require administrative privileges as root, without having to log in as administrator, select the Use sudo check box.
* IMPORTANT: It is possible to delete or edit existing credentials by clicking Select from stored credentials and entering the User Credentials dialog box. However, it is highly advisable not to make any changes to existing credentials, as such changes will affect all agents that currently use these credentials.
Use the user-defined collections feature to add customized collections to all of the currently selected agents, thereby providing for queries not included in Foglight for Oracle.
Use the Connection Details view to enable and configure the creation of user-defined collections.
To add user-defined collections, go to the User-defined Collections view in the Databases Administration dashboard. For details, see KB 106430
If you have Oracle instances that run on virtual hosts, monitoring such instances requires setting a dedicated connection profile, in order to connect to the requested VMware server.
* NOTE: The VMware connection profile can be defined only if OS monitoring is enabled.
Establishing such a connection is necessary in order to retrieve the Virtualization overhead data, that is, the percentage of CPU that is unavailable to this virtual machine because it is being utilized either by other virtual machines or by VMware itself. The Virtualization Overhead indicator is displayed in both the real-time and history summary pages.
To edit the VMWare Connection Profile: