SQL Agent for database Version 12.3 job failing with Invalid Connection String Format.

Article Id: 140412

Status: Published

Updated On: 02-07-2020 09:49

Products:

CA Automic Workload Automation - Automation Engine , CA Automic One Automation , CA Automic Operations Manager , CA Automic Oracle

Issue/Introduction:

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.

Environment:

Release : 12.3

Component : AUTOMATION ENGINE

Resolution:

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.