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

xysoul_雲龍發表於2022-02-14
View

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_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;

Call stack contains:

.. kghfrf dbgripfrm_free_mem dbgripsit2_stop_iterator_2 dbgripsit_stop_iterator_p dbgripicl_iter_cleanup dbgrip_relation_iterator qerfxFetch ...

CAUSE

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 P , 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


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29487349/viewspace-2855568/，如需轉載，請註明出處，否則將追究法律責任。

相關文章