Autosys DB Resync script - autobcpORA.pl

Document ID : KB000074930
Last Modified Date : 09/04/2018
Show Technical Document Details
Question:
Tried to use autobcpORA.pl to sync two AE databases but encountered errors.
EXP-00008 
ORA-00904 
ORA-01003
Answer:
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).