Compare fails with the following entries in desvr.log
921: Oracle Error 904: ORA-00904: ROUTE_NUM: invalid identifier
921: Error 904 calling OCIStmtExecute in de_splextab_insert_row
921: Status : Error
921: Error 1 inserting into SHAREPLEX_DATAEQUATOR table. (de_thrdmgr_sub_main,L1
615)
921: Compare USER.TABLE to USER.TABLE failed. See error message above.
000: DEQ done reading.
ora_setup was not executed, as a result ROUTE_NUM was not added to table SHAREPLEX_DATAEQUATOR.
Perform the following on source and target to resolve the issue:
1. shutdown shareplex
2. cd <proddir>/bin
3. ./ora_setup
4. follow the prompts, make sure there are no errors
5. start shareplex
6. rerun compare
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center