After setting the default credentials for the host, these newly created credentials can now be used by the wizard to attempt to log in to the instances.
This video is applicable for Foglight 5.6.11 and higher
Please refer to KB 232102 for details on opening the Databases Administration Dashboard
To validate the instances’ connectivity:
1 Click Validate connectivity.
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 Validate connectivity.
2 Click Validate connectivity on the status bar.
3 Click Save Changes.
The Applying Modified Settings progress bar appears.
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.
Enabling and setting credentials for user-defined collections
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: