Autosys DB Resync script - autobcpORA.pl

book

Article ID: 74930

calendar_today

Updated On:

Products

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

Issue/Introduction



Tried to use autobcpORA.pl to sync two AE databases but encountered errors.
EXP-00008 
ORA-00904 
ORA-01003

Environment

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

Resolution

Errors like these can occur due to a difference in ORACLE versions between the source and target databases and/or utilities from the system(s) where autobcp is run.

Run the following steps and note the full versions 
login as the autosys operating system user 
 run "exp" note the version and break out
 run "imp" note the version and break out
 run "sqlplus @<db1>" note the version
  continue with the login as as autosys 
  run "select * from V$VERSION;" 

All of the version results should be the same.
Perform the same steps on the secondary AE machine / database (db2).