ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 Workload Automation - Automation Engine

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.