Post stopped with the following messages appearing in the event_log:
Failed to retrieve Shareplex_Trans info: rc = 3135, ORA-03135: connection lost contact. [sp_opst_mt (for o.SID1-o.SID2 queue queue_name)/28652]
[1] 08/01/06 10:55 Error: 15030 - error getting information on SHAREPLEX_TRANS table,poster exit. [sp_opst_mt (for o.SID1-o.SID2 queue queue_name)/28652]
08/01/06 10:55 Process exited sp_opst_mt (for o.SID1-o.SID2 queue queue_name) [pid = 28652] - exit(1)
Post is not able to get the last checkpoint information from the internal table shareplex_trans
WORKAROUND:
1. The quickest workaround is to restart Post to see if the problem goes away.
The error can happen when post loses connection to the database when trying to access the Shareplex internal table shareplex_trans. The Oracle alert log and sqlnet.log entries around the time can be checked for any clues about the error.
2. If restarting post does not resolve the issue, then do following
sp_ctrl> stop post
wait till it is 'Stopped by user'
3. logon to target database through sqlplus and truncate the shareplex_trans table.
It is important to note that you can only truncate shareplex_trans table if post is stopped normally (not stopped due to error) as shareplex_trans table contains checkpoint information for post.
sqlplus splex/xxx
truncate table shareplex_trans;
4. start post and SharePlex will populate the information in shareplex_trans table again when it start to process the messages in post queue.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center