My Oracle Support Banner

Alert Log Shows ORA-600 [17147] In Streams Environment (Doc ID 743144.1)

Last updated on AUGUST 04, 2018

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)


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.