Post stops with the error as below:
[1] 12/30/06 21:52 Error: Failed to retrieve Shareplex_Trans info: rc = 24909, ORA-24909: call in progress. Current operation cancelled. [sp_opst_mt (for o.SID1-o.SID2 queue queue_name)/24047]
.
.
[1] 12/30/06 21:52 Error: 15030 - error getting information on SHAREPLEX_TRANS table,poster exit. [sp_opst_mt (for o.SID1-o.SID2 queue queue_name)/24047]
Could be a block contention.
The error may be caused by block contention. Check the following:
1. The INITRANS parameter for the shareplex_trans table should have a value large enough so as not to cause the block contention. Make sure that it is at least 10 or higher. If not, alter it. This should not be a problem since this table does not contain large number of rows and to modify the parameter will not take too much effort.
2. See if the tables involved in transactions around the time have appropriate (high enough) settings for INITRANS of 10 or more. This should also be true for their associated indices.
The para 2 tells us that even though the error may point to shareplex_trans table, the problem may be elsewhere, in the tables involved in transactions. Once the above has been taken care of, see if the Post behavior changes and if the problem still persists, contact Support.
The following is the description of Oracle error:
oerr ora 24909
24909, 00000, "call in progress. Current operation cancelled"
// *Cause: The OCI call was invoked when another call on the connection was
// in progress.
// *Action: Check if the OCI call is supported when the call is in progress
// under special conditions; for example, if it is being used by a
// signal handler.
