How to make configuration changes to Shareplex when the target database is changed from a RAC to a single instance Oracle (non-RAC Oracle).
Carry out the following steps:
1. Quiet the source database.
2. Issue flush from source sp_ctrl:
sp_ctrl>flush o.SID (where SID denotes the SID of the source database)
3. Make a copy of the currently active config file, edit it to reflect the new SID of the target and activate the copy.
4. After post stops due to flush, shutdown SharePlex on target and change the target database from RAC to single instance Oracle.
5. Run ora_setup with the new SID on target.
6. Start SharePlex and post on target.