PROPAGATION ERRORS ORA-30757 ON 11GR2 AFTER PATCHSET UPGRADE (Doc ID 1286513.1) (Doc ID 1286513.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-April-2013***
Advanced Queue propagation environments between 11GR2 databases


Symptoms

You have defined an AQ Propagation environment between 2 databases with different patchset level for example 11.2.0.1  to/from 11.2.0.2.

Propagation between these 2 types is not flowing.
On propagation job we can find that it is failing with error ORA-30757, although on dba_queue_schedules no error is receiving.
Another symptom is that the propagation appears hang and not progressing. By checking wait status, it is possible to see that
  - Propagation Sender process is waiting  for 'SQL*Net message from dblink'
  - Propagation Receiver process waiting for 'SQL*Net more data from client'

Relevant debugging traces files (24040) reveal that this hang situation is because error ORA-30757.

kwqpcbk: sent first piggyback
kwqpcbk3()+}
kwqpocienqcbk()+}
kwqpstrmmsg0: OCIAQEnqArray returned -1 error
kwqpstrmmsg0: Exception handler err -1 err2 30757
kwqpdest: exception 30757
kwqmbiotins: Freeing unallocated buffers, early return!
One every site a multiple consumer queue table that supports 2 queues for messages intercommunication between 2 system and propagations have been defined.

Changes

Apply of patchset on one site of the propagation end.
Payload for queues remains the same after upgrade.
Propagation was flowing normally before applying patchset.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms