Google it ....

Friday, December 17, 2021

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

When I try to query v$diag_alert_ext appears error:
ORA-00600: internal error code, arguments: [17147], [0x110A09510], [], [], [], [], [], [], [], [], [], []
ORA-48216: Field Len Exceeds Max Field Length [5] [30] [29286] [66]
Here is query which is used for quering alert.log entries
select instance_id, originating_timestamp, message_text, '1'
  from table(gv$(cursor (select instance_id, originating_timestamp, message_text
                    from v$diag_alert_ext a
                   where originating_timestamp > (sysdate - 1)
                     and (message_text like '%ORA-%' or
                         message_text like '%CRS-%'))))
 order by originating_timestamp desc;
As I found on metalink The issue is matching unpublished Bug 21266522 duplicate of unpublished Bug 18909196 - QUERIES INVOLVING X$DBGALERTEXT SOMETIMES FAIL DUE TO ORA-48216.
Solution:

1. Download and install the one-off Patch 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 /alert/log.xml (and log_*.xml).

No comments:

Post a Comment