-
Title
Capture stopped due to "Unexpected Oracle error: ORA-00904: "SCN": invalid identifier" -
Description
Capture is stopped due to error as below after SharePlex upgrade
Notice 2019-11-14 22:54:11.742000 6948 6740 Capture: ORA-00904: "SCN": invalid identifier (capturing from o.SourceSID) [module osp]
Error 2019-11-14 22:54:11.747000 6948 6740 Capture: Unexpected Oracle error: ORA-00904: "SCN": invalid identifier in c:\starsrc\shareplex-60\9.1.4.001\src\ocap\sp_ocap.c:1667 (capturing from o.SourceSID) [module osp]
Info 2019-11-14 22:54:11.895000 4040 5452 Capture exited with code=1, pid = 6400 (capturing from o.SourceSID)
Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger× -
Cause
SharePlex was upgraded but the ora_setup was not run after upgrade. -
Resolution
The ora_setup was not run after SharePlex upgrade. This resulted in the column SCN missing in one of the SharePlex internal table and consequently caused the Capture errors.
To resolve the above, carry out the following:
Shutdown SharePlex.
Run ora_setup so that the internal tables are updated.
Restart SharePlex.