While replication is carried out from 8i to 10g, the following error appear in the event_log and the post process will not restart.
"Notice: ORA-03124: two-task internal error. [sp_opst(osp)/17944]"
"Error: Unexpected Oracle error: ORA-03124: two-task internal error. (object name: "xxx"."xxx") [sp_opst (for o.xxx-o.xxx queue xxx)/17944] "
The error "ORA-03124: two-task internal error" is most likely an Oracle issue.
A. Set post to ignore this error via the following procedure.
1. Go to vardir/data/ directory
2. Edit the oramsglist file
3. Increment the error count (number) on the top of the file by one ( equals to total number of lines in the file -1 )and add a new line with the error 3124 at the bottom of the line
4. Save the file and exit
5. In sp_ctrl > set param sp_opo_cont_on_err 1
6. start post in sp_ctrl> start post
Once post is past the error the above can be unset:
1. sp_ctrl> stop post
2.sp_ctrl> status (Make sure post is stopped by user)
3. Edit the file oramsglist in the vardir/data directory, decrease the number in first line by 1, remove the message number 3124 from the file and then save the file.
4. from sp_ctrl> set param SP_OPO_CONT_ON_ERR 0
5. sp_ctrl> start post
B. Once the above step is completed contact Oracle to determine the root cause of the error.
