My Oracle Support Banner

ORA-7445 [_etext_f] with Intelligent Agent and Enterprise Manager/Grid Control (Doc ID 457441.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.5 to 9.2.0.7 [Release 9.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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

The following error is reported when the Intelligent Agent takes a snapshot collection and sends it to GRID Control: 
   ORA-07445: exception encountered: core dump [_etext_f()+2305843009112923042] [SIGILL] [Illegal opcode] [0x600000000047C562]

The call stack in the trace file resembles: 
_etext_f ksurlmf qerfxFetch rwsfcd qeruaFetch qervwFetch qersoFetch


The failing statement reported in the trace file is: 
   /* OracleOEM */
   SELECT usage
   FROM (select RESOURCE_NAME name, 100*DECODE(initial_allocation,' UNLIMITED',0,
   current_utilization /
   initial_allocation) usage
   from v$resource_limit
   where LTRIM(limit_value) != '0' and LTRIM(initial_allocation) != '0'
   and resource_name in ('dml_locks', 'processes', 'sessions') 
   union all
   select 'user' name
   ,100* DECODE(sessions_max,0,0,sessions_current/sessions_max) usage
   from v$license
   )
   order by name

Changes

 NONE

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.