Capture fails with the following error after upgrade from 7.0 to 7.6
Event log :
Error 2013-01-25 09:07:44.351413 8747 1 Capture: 12010 - error getting obj# for SHAREPLEX_DDL_CONTROL table due to ORA-01403: no data found. (capturing from XXXXX) [module osp]
Shareplex version 7.6 has some additional internal tables which do not exist in older versions. Those internal tables are added into Shareplex owner schema when one runs ora_setup after installing the new binary. Capture will fail when it is not able to find some shareplex internal table, in this case SHAREPLEX_DDL_CONTROL.
1.Shutdown Shareplex
2. Run ora_setup with the same DB user as the older version and that creates the additional tables.
3. Restart capture.