The SQL Agent job fails to start.
1. Agent DB-Type 'ORACLE' doesn't match Connection DB-Type 'ORACLE_OCI'
Issue occurred after upgrading to 12.3 from 12.2, jobs were failing where the connection was set to Oracle.
Changing these to Oracle_OCI fixed those but some jobs still fail when the connection is set to Oracle_OCI.
Other jobs with the same connection and agent and almost the same SQL work. On rolling back to the previous 12.2 agent this works.
2. IO Error: Invalid connection string format, a valid format is: "host:port:sid"
Release: 12.3.0 to 12.3.3
Component: AUTOMATION ENGINE
In case of error 1:
In case of error 2:
There's no other workaround than downgrading the Agent to 12.2.0.
Solution: This was fixed with the database agent on 12.3.4