Adding a column on the target database before adding it to the source database results in the following errorwhenever the new column is updated:
[7] 01/05/08 23:02 Notice: column SEUSER.ACCOUNT. num 2857, type 0, len 0 [sp_opst_mt(osp)/8142]
[7] 01/05/08 23:02 Error: OCIAttrGet failed with ORA-24338. [sp_opst_mt (for o.prod-o.prod queue db0b)/8142]
Updating the target prior to the source does not allow shareplex to update the poster object cache.
Copy the capture object cache from source to post object cache on file
1.sp_ctrl>stop capture
2. sp_ctrl>start capture
3. cd $SP_SYS_VARDIR/state and and copy the o.<SID>-objcache_sp_ocap.<highest number> to the target vardir/state - if using ftp, copy it in binary mode.
4. on the target rename this file to same name as the name of thehighestnumber of the poster object cache. The poster object looks like the following:
<xxx>+PP+<xxx>+sp_opst+o.<xxx>-o.<xxx>-objcache_sp_opst.<highest_number>
5. change the permission and ownership of this file to same as other files in this directory.
6. sp_ctrl>start post
For example:
If thefile is:
/u01/oradata/splex_var/state/0x0a010814+PP+poly+sp_opst+o.t1r0-o.t2r0-objcache_sp_opst.32
The corresponding capture object cache would be named:
o.PSTSB-objcache_sp_ocap.32
You would copy the capture object cache file to target directory:
/opt/var/splex/state
You would rename it on target to:
0x0a010814+PP+poly+sp_opst+o.t1r0-o.t2r0-objcache_sp_opst.32
