search cancel

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)