When issuing flush on sp_ctrl, the following error is encountered:
sp_ctrl (source_server:port_num)> flush o.SID
cnc_flush() Attempt to deactivate or flush an inactive datasource
Incorrect Oracle SID specified in the flush command.
The following are the causes and the resolution thereof:
1. The flush was issued on a SID that is not a source SID for the replication in question. Issue the command with correct source SID value.
2. There was a typo in the value specified for source SID in the "flush" command. Correct the typo and re-issue the command.