PROPAGATION ERRORS ORA-30757 ON 11GR2 AFTER PATCHSET UPGRADE (Doc ID 1286513.1)
Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 02-April-2013***
Advanced Queue propagation environments between 11GR2 databases
You have defined an AQ Propagation environment between 2 databases with different patchset level for example 22.214.171.124 to/from 126.96.36.199.
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
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms