Autosys DB Resync script - autobcpORA.pl
Article ID: 74930
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:
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).
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).
Feedback
Powered by
