-
Title
Using the Connection Details panel in Oracle database agents -
Description
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
-
Resolution
Video
Please refer to KB 4310893 for details on opening the Databases Administration Dashboard
To validate the instances’ connectivity:
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:
- No valid RAC nodes were detected (for a RAC) — modify the RAC nodes’ credentials.
- Invalid username/password — check the credentials and try again.
- Process Error — see the code error under the Details column.
- Wrong Database Credentials — modify the login credentials.
- Database Connection Failed — the database to which the instance tries to connect is not running or cannot be accessed. Ensure clearing the check box near the database’s name.
- Insufficient Privileges — grant the user the privileges required for connecting to the database, by clicking the status Insufficient Privileges, the Grant Database Privileges dialog box opens.
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.
If the Sysdba credentials entered were incorrect, the column displays the status Wrong Sysdba credentials.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.Configuring OS monitoring credentials
To configure the OS monitoring credentials:
1 Use the Host Credentials section to select whether to log in to the monitored host using the existing host connection details or to edit the host connection details.
2 If the option to edit the host connection details is selected, select whether to disable OS monitoring, which is enabled by default.
* IMPORTANT: When enabling OS monitoring, ensure that the selected OS user has the privileges required for monitoring the operating system. For details, see the Foglight for Oracle Release Notes.3 Specify the requested authentication type:
- Local user — using the same credentials that were used for running the monitoring software (Agent Manager) on the Oracle host.
- Windows — the user name (in the domain\user name format) and password, used for logging in to a Windows-based monitored host.
- SSH (DSA) — using the SSH private key, generated via the DSA algorithm.
- SSH (RSA) — using the SSH private key, generated via the RSA algorithm.
- SSH (login credentials) — the user name and password used for logging in to a UNIX-based monitored host.
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 enable and configure the creation of user-defined collections:- Select the requested agents.
- Click Set credentials.
The Edit Instance Credentials dialog box opens. - Click Edit Credentials for User-defined Collections.
The Edit Credentials for User-defined Collections dialog box opens. - Select the check box Enable user-defined collections.
- Select whether to perform the collection using the existing agent credentials or by creating dedicated credentials.
- If the user-defined collections are to be enabled using dedicated credentials, type the requested user name and password.
- Select whether to connect as SYSDBA.
-
Click Set.
To add user-defined collections, go to the User-defined Collections view in the Databases Administration dashboard. For details, see KB 106430
Defining the VMware Connection Profile
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:
- Select the requested agents.
- Click Set credentials.
- In the dialog box, click Specify VMWare connection details.
The VMWare Credentials dialog box opens. - Enter the details required for monitoring the CPU distribution data, that is: vCenter or ESX host name, port, VMware user, and VMware password.
- Select the check box Enable monitoring the VMWare CPU layer.
- Click OK.
-
Attachments