We are receiving alerts on both "Database Agent Connection Issue" and "Database Version Unsupported By Database Agent" under the default Infrastructure profile. The odd thing is these alerts seem to resolve themselves but repeat randomly throughout the day. Our database team is unable to pinpoint any issues based on data we provide and I am unable to drill into much details from Dynatrace.
Connection Issue says this in details;
Database Agent Db-Agent1@cexa-scan:1 failed to connect to database. Reason: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
And Unsupported database version says this in details;
Database Agent Db-Agent1@cexa-scan:1 is configured to connect to unsupported database version
Any help would be appreciated!
I guess the necessary permissions for DB monitoring granted to the user that is used to connect to the DB instance.
In case if you have Oracle RAC 12c leaf nodes
The following page describes various techniques for troubleshooting.
Thanks Babar- after reviewing this closer, I think part of the issue may have been our initial configuration was just using Oracle driver and we have Oracle RAC. I have rebuilt the Database agent with Oracle RAC client and let it autodiscover. I'll let it run for a little bit to see if this helps.