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

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.