Alert Log Shows ORA-600 [17147] In Streams Environment

(Doc ID 743144.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: to
This problem can occur on any platform.


Errors like the following are frequently being appended to the alert log file and respective traces  for Ora-600 17147 are also being generated :

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17147], [0xFFFFFFFF797ADE48], [], [], [], [], [], []

The trace files names would be like : <SID>_ORA_xxx.trc

From those files, we can see that the current SQL statement for the failing session is:

WHERE consumer_name is null AND MSG_STATE='READY' and queue = 'C_RSAP1_RSADBO_G1' and address IN (select '"'||destination_queue_owner ||'"' ||'.'||'"'
||destination_queue_name||'"@'||destination_dblink from dba_propagation)


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