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

ITPub博客

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

APPLIES TO:

SYMPTOMS

CAUSE

SOLUTION

REFERENCES

最新文章