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

book

Article ID: 140412

calendar_today

Updated On:

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.