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.

Connection Object for Oracle Agent is not working

book

Article ID: 200521

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Admin is getting the following error when testing their Oracle Connection Object:

U02000112 Remote System is not available via Connection Object 'CONN.SQL.KEUUVDEMAPP02.GMCR.COM.SQL.'.

Environment

Release : 12.3.x

Component : AUTOMATION ENGINE

Resolution

The Oracle CONN object requires:

  • a DB Service Agent installed
  • For Oracle OCI Connections -> an Oracle Client Installed on the DB Service Agent server
    • This Oracle Clients needs a tsaname.ora populated (Net Configuration Option)