Capture reports;
Error: Unexpected Oracle error: ORA-00604: error occurred at recursive SQL level 1.ORA-01410: invalid ROWID. in ../src/ocap/sp_ocap.c:833 [sp_ocap(osp)/22500]
Capture debug shows;
08-03-31 10:43:07.714112 25091 1 before calling act_get_actid_tab_info ...
08-03-31 10:43:07.714129 25091 1 osid = mydb host_name = mydb1 sp_thread_id = 0 instance_num = 1 thread_id = 1 seq/off = 0/0
08-03-31 10:43:07.714129 25091 1 thread seq/wrap = 0/0
08-03-31 10:43:07.716251 25091 1 rc = 604, actid=0
When SharePlex queried the shareplex_actid table an error occurred...
SQL> select * from shareplex_actid;
select * from shareplex_actid
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01410: invalid ROWID
This is a database problem.
The DBA should look at why this table is corrupt.
Running ora_cleansp on source and target and re-activatingmay enable replication to continue, but this will result in loss of some data, and should not be used in a cascading environment. This workaround requires that the corruption that exists in the table does not cause further issues.
