Stream Propagation Process Errors Ora-4052 Ora-6554 From 11g To 10201 (Doc ID 553017.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.8 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Cannot propagate message to destination.

ORA-04052: error occurred when looking up remote object SYS.DBMS_AQADM@DEVORACLE.IORACLE
ORA-00604: error occurred at recursive SQL level 4
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from DEVORACLE.IORACLE
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1169
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 8106
ORA-06512: at "SYS.DBMS_AQADM", line 631
ORA-06512: at line 1

 

Changes

Incorrect version setting on Source database 11.1.0.6.0 Target/REMOTE database is 10.2.0.1.0  and Errors like ora-6544 ora-4052 is generated  during remote plsql lookup of an object on 10.2 /10.1 in 11.0

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