After a system crash or abnormal shutdown of shareplex on the target the export connects to import but post queue is not created. After clean up of the queues on the target when shareplex export process connects with import but the post process does not get spawn and no post queue is created. Sometimes the import does not get spawn at all.
The services file in $SP_SYS_VARDIR/data/ directory is not updated correctly. Starting import does not help, as there is an entry in the services database indicating that the service was disabled.The "problem" here is that there is no notification of import disabled.
Resolution:
1. shutdown shareplex at target
2 cd $SP_SYS_VARDIR/data
check for dirty file if there is one remove it
ls d*
3.Check for services file and rename
mv services services.old .
4.start shareplex .
On source restart the export
At Source:
sp_ctrl> stop export
sp_ctrl> show
make sure export is stop by user. If you having problem stopping export just do shutdown force
sp_ctrl> start export
This should take few minutes.
If source is not active then apply flush command from source to accomplish this manually.
If source is inactive and there are no messages in the export queue you could do the following steps:
login to source machine
in sp_ctrl>
sp_ctrl> flush o.ORACLE_SID
Example if oracle sid of source is quest
sp_ctrl> flush o.quest
sp_ctrl> exit
This will forces a flush message to be send to the target and this should create the post queue at the target.
Status
This has been addressed in version 6.1.
