The following errors are observed when activating a config from a source database which is a RAC:
sp_ctrl (2100)> show log reverse
Warning 2013-12-25 03:40:33.719932 60788 2132875008 Activation: Load-balancing is not supported in SharePlex; modify the connection to remove the load-balancing option (activating sid SID1) [module osp]
Error 2013-12-25 03:40:33.719514 60788 2132875008 Activation: Error ORA-30 trying to kill locking session (6367,8511), instance id 3, from connection formed with instance id 2 (activating sid SID1) [module osp]
Notice 2013-12-25 03:40:33.698498 60788 2132875008 Activation: Killing session sid=6367 serial=8511 (activating sid SID1) [module osp]
The customer is unwilling to remove this option in a production environment.
Either modify the current tns entry in the Oracle tnsnames.ora file to remove load balancing or create a new tns entry for the SharePlex user with load balancing turned off.
Please note that if you create a new tns entry for the SharePlex user, you will need to run ora_setup once again to update the Shareplex login information. For more information on running ora_setup, please review the SharePlex for Oracle Reference Guide.
