【BUG】ORA-00600 [17147] ORA-48216 When Querying V$DIAG_ALERT_EXT View

来源：这里教程网时间：2026-03-03 17:26:21 作者：

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Information in this document applies to any platform.

SYMPTOMS

Errors reported:

ORA-00600: internal error code, arguments: [17147], [0x110A09510], [], [], [], [], [], [], [], [], [], []ORA-48216: Field Len Exceeds Max Field Length [5] [30] [29286] [66]
Current SQL Statement is accessing 
v$diag_alert_ext like the below:
select inst_id,originating_timestamp,message_text, '1'from table (gv$ (cursor (select inst_id, originating_timestamp, message_textfrom v$diag_alert_ext awhere originating_timestamp > ( sysdate - 1 )and ( message_text like '%ORA-%'or message_text like '%CRS-%' ))))order by originating_timestamp desc;
Call stack contains:
.. kghfrf dbgripfrm_free_mem dbgripsit2_stop_iterator_2 dbgripsit_stop_iterator_p dbgripicl_iter_cleanup dbgrip_relation_iterator qerfxFetch ...
CAUSEThe issue is matching unpublished Bug 21266522 duplicate of unpublished Bug 18909196 - QUERIES INVOLVING X$DBGALERTEXT SOMETIMES FAIL DUE TO ORA-48216.

SOLUTION1. Download and install the one-off P
atch 18909196, available for your platform (this issue only exists in 11.2.0.4). If a patch does not exist for your platform please open a Service Request for Oracle Support.
-OR-
2. Implement the workaround: remove (i.e. delete) the xml-based alert log within <ADR_HOME>/alert/log.xml (and log_*.xml).

NOTE: other errors can be generated by Bug 18909196 (see 
Document 2011219.1 and 
Document 1679553.1).
 

REFERENCES


NOTE:2011219.1
 - Instance Terminated With ORA-00600:[17182], ORA-07445:[kghdsdmp] And ORA-07445:[kecucdc_destroy_cache]

NOTE:1679553.1
 - ORA-600 [1:dbktDefFileInit] ORA-07445 [dbgtrRecNewestGet()+8] ORA-48216 In Alert Log