datamover Execution Results in Error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Issue: 

Execution of “perl $AUTOSYS/dbobj/DataMover/uajmdatamover.pl” results in error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

 

Environment:  

Workload Automation AE 11.3.x, Oracle Database

 

Cause: 

This issue can occur due to the use of service name, when SID (instance name) is expected.

 

Resolution:

 When configuring the paramfile for use with DataMover, ensure that SID is used for SRCDBNAME and TGTDBNAME.

 

Resource:

See TEC586429 for additional information regarding use of DataMover on UNIX.

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: