Installed latest version 12.3 of database agent for oracle . Installation went fine and the agent starts normally but running the job is not possible due to
below mentiond error:
Connection test failed -
2019-10-13 21:03:13 - U02012031 The database driver returned the following error message:
2019-10-13 21:03:13 IO Error: Invalid connection string format, a valid format is: "host:port:sid"
2019-10-13 21:03:13 - U02004025 Job-script execution was aborted.
Release : 12.3
Component : AUTOMATION ENGINE
Please make the below change in ucxjsqlx.ini file on Oracle Agent Machine.
Open the file and go to [ SQL ] Section.
Specify ORACLE_OCI in type=
For Example : type=ORACLE_OCI
save the file.
Check deploying job now.