Alert Log Shows ORA-600  In Streams Environment
Last updated on JULY 06, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , [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