Autosys DB Resync script

Article Id: 74930

Status: Published

Updated On: 09-04-2018 10:19

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).

Autosys DB Resync script - autobcpORA.pl