When shareplex oracle sessions got killed on source, it causes reader failed to fetch key value and causes target to go out of sync.
08/20/07 08:28 Notice: ORA-00028: your session has been killed. [sp_ocap(osp)/5040]
08/20/07 08:28 Error: Unexpected Oracle error: ORA-00028: your session has been killed. in rom.c:185 [sp_ocap(osp)/5040]
08/20/07 08:28 Process exited sp_ocap (for o.genprod) [pid = 5040] - exit(1)
08/20/07 08:28 Process launched: sp_ocap (for o.genprod) [pid = 15717]
08/20/07 08:28 Notice: Capture log parser queue size is 100000 [sp_ocap/15717]
08/20/07 08:28 Notice: FioSetEnsure: set redolog_ensure to 1 [sp_ocap/15717]
08/20/07 08:28 Notice: Oracle env - genprod:/dkg001/oracle8/app/oracle/product/8.1.7 [sp_ocap(pdb)/15717]
08/20/07 08:28 Notice: status = OPEN [sp_ocap(osp)/15717]
08/20/07 08:28 Notice: db_block_size 8192. [sp_ocap(osp)/15717]
08/20/07 08:28 Notice: The SharePlex supplemental logging state is: Disabled [sp_ocap/15717]
08/20/07 08:29 Notice: ocm set upgrade version from 0 to 520 [sp_ocap/15717]
08/20/07 08:29 Notice: Oracle version 81 [sp_ocap(osp)/15717]
08/20/07 08:29 Notice: Parsing Oracle RedoLog in Pre-10G format [sp_ocap/15717]
08/20/07 08:29 Notice: Oracle RedoLog compatibility is set to pre-10G [sp_ocap/15717]
08/20/07 08:29 Notice: Queue write recovery started, qrw_srcseq=1504030094600 msg.mpseq=1504029505600 [sp_ocap(que)/15717]
08/20/07 08:29 Notice: Queue write recovery complete, 590 duplicate messages skipped , 248171 bytes total [sp_ocap(que)/15717]
08/20/07 08:38 Logging user command: splex shutdown
Reader log:
07-08-20 08:28:40.077886 3731 1 ERROR: Failed to GetKeyValue with rc=1012, objid=20651, actid=7, rowid=AAAT9pAI5AAAJ2/AAG
07-08-20 08:28:40.077946 3731 1 record with seqno=42810, offset=621652512
07-08-20 08:28:40.077988 3731 1 sqlStmt=select "ACCOUNT_NUM" from "GENEVA_ADMIN"."A
Reader does not handle ORA-00028 and ORA-1012 well which causes OOS when reader failed to fetch keys
WORKAROUND:
Shutdown shareplex normally or use shutdown force instead of manually killing shareplex sessions in database.
STATUS:
Waiting for fix in a future release of Shareplex for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center