An environment is using a Oracle RAC Database with two RAC node instances (2 databases on two hosts in the cluster).
When creating an Oracle (DBO) agent using the "Add Database" wizard, it automatically detected the RAC configuration but allows only one FglAM (Foglight Agent Manager) to be used for the monitoring, so the user can only select one of the two hosts.
As a result, there is a SSH connection to that host using the "Local User" connection method for OS monitoring.
This is the error results:
>> Failure: Cannot establish connection to xxxxxx: Local credential xxxxxxx cannot be used for a remote connection: xxxxxxx
How can the OS use the "Local User" on both nodes?
How to use a different Agent Manager for each Oracle RAC instance node from the same Oracle RAC when adding new Oracle agent from the Oracle installer wizard?