The utility clean_vardir.sh was run on target while Shareplex was running. Later, the event log showed the following messages indicating queue corruption whereby the queue messages from source did not flow to the target and the Export remained in "idle" state and would not connect to Import:
04/23/08 22:02 Process launched: sp_mport (from trmdessu queue trmdessu) [pid =29880]
04/23/08 22:02 Connected to export on trmdessu
04/23/08 22:02 System call error: No such file or directory que_open.open_fd [sp_mport(que)/29880]
04/23/08 22:02 Notice: Error opening output queue que_ERR: Non specific error que_open(-,trmdessu+P+o.EUUAT9I-o.splex45,0xa27cc8ad+PI+trmdessu+sp_mport+0xa9a3bf48) [sp_mport(rim)/29880]
04/23/08 22:02 Error: sp_mport: failure writing to queues - exiting [sp_mport/29880]
04/23/08 22:02 Error: sp_mport: failure writing to queues - exiting [sp_mport/29694]
04/23/08 22:02 Process exited sp_mport (from trmdessu queue trmdessu) [pid=
29694] - exit(1)
The utility clean_vardir.sh is run to clean up the existing variable directory which typically includes the queue files, cache files and log files, among others. It should be run when Shareplex is shutdown. Not doing so can cause some synchronization problems between the queue files, the Shareplex internal tables, etc. The simplest way to get out of this situation is to shutdown Shareplex on target (this is where it was mistakenly run while Shareplex was up), run ora_cleansp and restart Shareplex. On restart Post may complain about missing object cache file which can easily be resolved (see solution # SOL2459 for details or call Support if encountering the error). The ora_cleansp would get rid of the contents of variable directory as well as clean up the Shareplex internal tables on target database putting all speculation about sync problems between to rest. One would not lose activation as a result of this since it went on at the target side. At the most there may be out of sync issues. If this was done on source, it would result in the loss of current activation.
