The database connection objects created using GENERICJDBC connection type to the Oracle RAC database. The jobs using the specific connection objects failed with the following message -
2022-06-08 10:21:59 - U02012000 Agent DB-Type 'ORACLE' doesn't match Connection DB-Type 'GENERICJDBC'.
Release : 12.3, 21.0 and higher
The database agent can only take single database connection type at a time. The problem appears if the database connection objects created using different database type other than what agent is configured to accept.
Login to the agent machine with an appropriate privileged account.
Stop the agent.
Go to agent install directory and open the agent configuration file (ucxjsqlx.ini) for edit.
Update the property "type=GENERICJDBC" and save the file.
Restart the agent
Agent SQL -Structure of the INI File ucxjsqlx.ini