Alert Log Shows ORA-600  In Streams Environment
(Doc ID 743144.1)
Last updated on AUGUST 04, 2018
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)
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