Shareplex for Oracle
After activating a config the capture and reader processes are spawned, but not export. No errors are reported and activation finishes and exits with exit(0)
By default in version 4.5 the capture parameter SP_OCT_REDOLOG_ENSURE is set to on this is a value of "1". This parameter ensures that capture doesn't get ahead of oracle by ensuring that capture is at least 2 seconds behind oracle. A problem exists if the Time zone [TZ] of the user starting shareplex and the database are different. If the TZ differ by 3 hours capture would wait 3 hours and 2 seconds before processing messages. If this is the case you would find that the shareplex_objmap table was populated with the object id's of the replicated objects, the shareplex_actid table would be empty and the user running sharpelex would have an environment variable TZ set.
procedure to unset the SP_OCT_REDOLOG_ENSURE from sp_ctrl
sp_ctrl> set param SP_OCT_REDOLOG_ENSURE 0
sp_ctrl> shutdown force
restart the sp_cop in the background.
The TZ variable can also be set to the same value as the database.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center