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: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.

Symptoms

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:

SELECT NVL(COUNT(MSG_STATE),0)
FROM STRMADMIN.AQ$C_RSAP1_RSADBO_G1
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)



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